Linked table to inbox

[Pat]

Hello:

I am linking Microsoft Access Table to Outlook inbox.
A problem is that FROM and SENDER is showing a display
name and not the actual e-mail address.
Is there any pro or non-progmatic method to obtain
sender's email address instead display name.

I would appreciate your assistance.

 

[Sue Mosher [MVP-Outlook]]

The linked table method has major limitations, including the inability to
show even all the reasonably important fields. While articles have been
written on how to expand on this method's obvious features, I've never been
able to duplicate the results. See
http://www.outlookcode.com/d/database.htm#linkedtables .

As for the sender address, in Outlook 2003, you can use the
MailItem.SenderEmailAddress, but note that it's subject to security prompts.

In earlier versions, there is no Outlook property that returns the sender's
email address. You can either use CDO (or Redemption to avoid security
prompts -- http://www.dimastr.com/redemption/) to get the From address or
use Outlook to get the Reply To address. Sample code at
http://www.outlookcode.com/d/code/getsenderaddy.htm

To get the SMTP address from an Exchange sender or recipient, use CDO or
Redemption and the PR_EMAIL (&H39FE001E) MAPI property to obtain the SMTP
address from the AddressEntry object. See
http://www.outlookcode.com/d/code/getsenderaddy.htm#redemption and
http://www.cdolive.com/cdo5.htm#EMailAddressOfSender for examples.