topic Re: Can SAS read email attachments? in SAS Programming

Can SAS read email attachments?

vicky07 — Wed, 12 Sep 2012 02:02:32 GMT

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!

Re: Can SAS read email attachments?

MarkBodt_NZ — Thu, 13 Sep 2012 20:29:56 GMT

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

Re: Can SAS read email attachments?

MarkBodt_NZ — Thu, 13 Sep 2012 21:15:41 GMT

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

Re: Can SAS read email attachments?

jakarman — Fri, 14 Sep 2012 09:40:39 GMT

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

Re: Can SAS read email attachments?

vicky07 — Mon, 24 Sep 2012 23:44:06 GMT

Mark,

This is helpful.Thanks for your reply!