Can SAS read email attachments?

[vicky07]

Hello,

I'm wondering if there is way in SAS to connect to MS outlook and download an excel attachment from XYZ email id. I know we can send emails out with attachments but thinking if we can do it the opposite way. I would much appreciate if anyone can share a sample code or any notes on how to do it.

Thanks!

[MarkBodt_NZ]

Hi,

I don't have the answer to your question, but a possible lead is: Check out the SAS Sample code:25631 SAS Outlook Data Extractor http://support.sas.com/kb/25/631.html

Mark

[MarkBodt_NZ]

Hi,

Another approach could be to set up a rule in outlook to save email the email to a partuclar folder, then use a VBA script in outlook to detach any excel files to a specific folder. I did a google search on "automatically detach file from email" and it turned up some scripts that may help.

You can then use SAS to read from that folder.

Mark

[vicky07]

Mark,

This is helpful.Thanks for your reply!

[jakarman]

You can open up you MS-outlook mail as a data-store.  All mail content etc should be retrievable.  Just open outlook from data-source...

With Attachements I am not sure how and what is working

Other interfaces (base) - (ftp url mails):

http://support.sas.com/resources/papers/proceedings09/002-2009.pdf pop3 access  
http://support.sas.com/resources/papers/proceedings12/119-2012.pdf all kind of interfacing