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!
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
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
Mark,
This is helpful.Thanks for your reply!
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.