Full Email Address Outlook Access

[Bob]

Hi Everybody


I have an MS Access Database that accesses the MS Outlook Inbox.

I want to be able to see the full email address that the communication
has come from while within Ms Access.

However, on some addresses I see "Tom Smith" instead of
(e-mail address removed)


The full address is available because I can see it in the headers

Is there any way I can access the full email address within MS Access.

Thanks to all

Smiley Bob

 

[Ken Slovak - [MVP - Outlook]]

What version of Outlook? Outlook 2003 has a MailItem.SenderEmailAddress
property but in earlier versions of Outlook you would need to use CDO 1.21
(optional installation for Outlook 2000 and later), Extended MAPI (C++ or
Delphi only) or Redemption code (www.dimastr.com/redemption) to get the
actual email address.

You could create a dummy reply item and get that address, but in cases where
the ReplyTo address was different than the sender email address your result
would be incorrect.

For a CDO 1.21 code example of getting the sending email address, see
http://www.slovaktech.com/code_samples.htm#FromAddress