Read Email from Outlook thru SAS

[arunrami]

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

[arunrami]

@Kurt_Bremser  Can you please help with this..!

[Kurt_Bremser]

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.

[arunrami]

ROFL!!

[arunrami · Accepted solution]

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

[Quentin]

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

[arunrami]

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 ..