Can SAS read email attachments?

Reply
Frequent Contributor
Posts: 82

Can SAS read email attachments?

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!

Occasional Contributor
Posts: 12

Re: Can SAS read email attachments?

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

Occasional Contributor
Posts: 12

Re: Can SAS read email attachments?

Posted in reply to MarkBodt_NewZealand

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

Frequent Contributor
Posts: 82

Re: Can SAS read email attachments?

Posted in reply to MarkBodt_NewZealand

Mark,

This is helpful.Thanks for your reply!

Trusted Advisor
Posts: 3,215

Re: Can SAS read email attachments?

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


---->-- ja karman --<-----
Ask a Question
Discussion stats
  • 4 replies
  • 3070 views
  • 4 likes
  • 3 in conversation