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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.