Can SAS read email attachments?

Reply
Contributor
Posts: 71

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

Contributor
Posts: 71

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
  • 2466 views
  • 4 likes
  • 3 in conversation