'Script to Download xls files embeded in a .msg file
There are 1000s of .MSG files on my d drive and each containe an XLS file,as attachemnt.
Is there any way to download these xls files from these .msg file using ssis script or vb or vba? So that I do not have to open each and every msg file and download the xls files
Solution 1:[1]
I also have an other solutuion ,in which the attachments are then deleted from Outlook and in the Body of the mail a remark entered wich attachemnt is saved where; if that is of interest for you let me know.
but for your Need this here should do:
Solution 2:[2]
You can either use Application.CreateItemFromTemplate Outlook Object Model function or you can use Redemption (I am its author) and its RDOSession.GetMessageFromMsgFile method (http://www.dimastr.com/redemption/rdosession.htm) - you can then use RDOMail.Attachments collection to loop through all attachments and call RDOAttachment.SaveAsFile.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Max |
| Solution 2 |