https://communities.sas.com/t5/SAS-Enterprise-Guide/Access-and-Using-Data-from-MS-Exchange-In-EG/m-p/32434#M4254 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:<BR /> <BR /> 1. Connect to the MS Exchange message store.<BR /> 2. Extract the file attachement from the e-mail.<BR /> <BR /> Trying to improve a process by eliminating manual steps. Any help or suggestions would be greatly appreciated.<BR /> <BR /> James Thu, 11 Nov 2010 15:10:34 GMT JDMTX 2010-11-11T15:10:34Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Access-and-Using-Data-from-MS-Exchange-In-EG/m-p/32434#M4254 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:<BR /> <BR /> 1. Connect to the MS Exchange message store.<BR /> 2. Extract the file attachement from the e-mail.<BR /> <BR /> Trying to improve a process by eliminating manual steps. Any help or suggestions would be greatly appreciated.<BR /> <BR /> James Thu, 11 Nov 2010 15:10:34 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Access-and-Using-Data-from-MS-Exchange-In-EG/m-p/32434#M4254 JDMTX 2010-11-11T15:10:34Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Access-and-Using-Data-from-MS-Exchange-In-EG/m-p/32435#M4255 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.<BR /> <BR /> What you might consider instead:<BR /> - 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.<BR /> - 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: <BR /> <BR /> <A href="http://blogs.sas.com/sasdummy/index.php?/archives/136-Using-the-X-and-SYSTASK-commands-from-SAS-Enterprise-Guide.html" target="_blank">http://blogs.sas.com/sasdummy/index.php?/archives/136-Using-the-X-and-SYSTASK-commands-from-SAS-Enterprise-Guide.html</A><BR /> <A href="http://blogs.sas.com/sasdummy/index.php?/archives/14-You-are-under-my-command-prompt.html" target="_blank">http://blogs.sas.com/sasdummy/index.php?/archives/14-You-are-under-my-command-prompt.html</A><BR /> <BR /> Chris Thu, 11 Nov 2010 16:55:39 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Access-and-Using-Data-from-MS-Exchange-In-EG/m-p/32435#M4255 ChrisHemedinger 2010-11-11T16:55:39Z