topic Re: Read Email from Outlook thru SAS in SAS Programming

Read Email from Outlook thru SAS

arunrami — Mon, 16 Dec 2019 14:47:03 GMT

SASians,

I know the ways of importing data from outlook thru SAS EG , which will import all the messages . it is very time and memory consuming,

I would like to write a SAS script which has to run daily and check the today's mail with specific subject line, how can I do that ?

any simple syntax would be helpful , I can develop further!!

Thanks ,

SAR

Re: Read Email from Outlook thru SAS

arunrami — Tue, 17 Dec 2019 14:24:55 GMT

@Kurt_Bremser Can you please help with this..!

Re: Read Email from Outlook thru SAS

Kurt_Bremser — Tue, 17 Dec 2019 14:35:28 GMT

I won't touch Outlook; not even with waldos behind a meter-thick, radioactivity-safe glass.

I like to keep my mental sanity.

Ask me questions about importing any text file, and I'm happy to help, but the MS crap has given me enough pain for ten lifetimes.

Re: Read Email from Outlook thru SAS

Quentin — Tue, 17 Dec 2019 14:42:42 GMT

Instead of trying to connect to Outlook (or an exchange server?) from SAS to read mail, would it be feasible to write some Outlook automation script (VBA?) to run nightly and export your mail to a SAS-friendly format (simple text or XML or ... )

That said, it looks like apparently you can configure an ODBC connection to an exchange server, e.g.

https://communities.sas.com/t5/SAS-Programming/Can-SAS-Read-email-inbox/td-p/195431

http://support.sas.com/resources/papers/proceedings10/086-2010.pdf

Re: Read Email from Outlook thru SAS

arunrami — Wed, 18 Dec 2019 09:49:10 GMT

ROFL!!

Re: Read Email from Outlook thru SAS

arunrami — Wed, 18 Dec 2019 09:51:03 GMT

by connecting exchanage lib , it is a tedious job and it will import all the outlook data at first then only we can do the filtering, ..

Will try excel macro idea ..

Re: Read Email from Outlook thru SAS

arunrami — Thu, 02 Jan 2020 17:06:58 GMT

Okay! Finally I did it . Sadly , not using SAS but with the help of beautiful python library which can interact with running window application smoothly !!

*import win32com.client