Desktop productivity for business analysts and programmers

Access and Using Data from MS Exchange In EG

Reply
Contributor
Posts: 62

Access and Using Data from MS Exchange In EG

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
Community Manager
Posts: 2,697

Re: Access and Using Data from MS Exchange In EG

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
Ask a Question
Discussion stats
  • 1 reply
  • 88 views
  • 0 likes
  • 2 in conversation