09-11-2012 10:02 PM
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.
09-13-2012 04:29 PM
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
09-13-2012 05:15 PM
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.
09-14-2012 05:40 AM
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