문제 설명
MS‑Outlook 임베디드 이미지를 가져오고 MS‑Access VBA를 사용하여 파일 시스템에 저장 (Getting MS‑Outlook embedded images and saving them within the file system using MS‑Access VBA)
I have a very special question concerning MS‑Outlook and MS‑Access VBA. I want to import the email data from outlook into a database (and the file system > attachments and embedded images). Using Google I find ways to get the emails incl. emails properties and the attachments. But I need images too which are embedded in rich text‑ and html‑emails. Is there a way to realize this via VBA?
Thanks in advance.
Tommy
참조 솔루션
방법 1:
Embedded HTML images are just regular image attachments and can be saved using Attachment.SaveAsFile
.
Embedded RTF images are a different story: they are OLE objects, and Attachment.SaveAsFile
will fail. You can use Redemption (I am its author) for that ‑ its RDOAttachment.SaveAsFile
will extract WMF, Word, Excel, PowerPoint, PDF, etc. attachments from the attachment OLE storage and save them as files.
(by Tommy Saber、Dmitry Streblechenko)