Date:         Mon, 17 Nov 2003 22:10:15 -0500
Reply-To:     "Chang Y. Chung" <chang_y_chung@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Chang Y. Chung" <chang_y_chung@HOTMAIL.COM>
Subject:      Re: Track Email Messages
Comments: To: soundblast100@YAHOO.COM

On Sat, 15 Nov 2003 03:31:21 -0800, SASler <soundblast100@YAHOO.COM> wrote:

>I would like to know if there is a way to track the email messages
>from Microsoft Outlook in SAS. I want the time when the message was
>received, from whom the message is from, and the time when i reply to
>the message. Any help would be greatly appreciated. Thanks.

Hi,

In order to do what you want to do, you may have to access email store
through exchange server.

There is a Visual Basic 6 application example on the SAS Enterprise
Integration Community Page, called "SAS Outlook Data Extractor" at

http://support.sas.com/rnd/eai/samples/OutDataExtract/index.html

I read the code once very fast (meaning not very carefully).
Dispointingly, about the only thing about SAS in the whole thing is that
it saves extracted data in a sas dataset using SAS/Share provider. All the
heavy lifting (of opening the connection to the Exchange server and
talking to it using MAPI) seems to be done using ADO and CDO 2.1 -- I am
not saying this is not a simple trick to pull, but I was expecting
something like LDAP library engine -- which may or may not be in r9
(perhaps in SAS/Integration Technologies product).

Cheers,
Chang