Access and Using Data from MS Exchange In EG

[JDMTX]

I am working on a project where a data file is sent via e-mail and wanted to ask if it is possible on EG to perform the following actions:

1. Connect to the MS Exchange message store.
2. Extract the file attachement from the e-mail.

Trying to improve a process by eliminating manual steps. Any help or suggestions would be greatly appreciated.

James

[ChrisHemedinger]

EG can connect to Exchange as a data provider and access the message stores. I'll be honest though: the process uses a MAPI provider and it can be a little flakey. And it won't get to your attachments.

What you might consider instead:
- write a Windows PowerShell script to pull the information that you're looking for. Examples of using PowerShell to access Exchange are easy to find on the Web.
- tie that into a command-shell process that you launch from EG. We have a custom task that you can use to launch such a process and tie it in with your EG process flow. See:

http://blogs.sas.com/sasdummy/index.php?/archives/136-Using-the-X-and-SYSTASK-commands-from-SAS-Ente...
http://blogs.sas.com/sasdummy/index.php?/archives/14-You-are-under-my-command-prompt.html

Chris