Linking the actual email-adress from an email-message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my Access 2003 database, I have a linked table to my Outlook 2003 Inbox.
However, in the "From"-field of the linked table, the actual email-adress is
NOT shown. Instead I see the "email-name" which the sender has chosen, for
instance:
"Reg Taylor"
What I want to see in my linked table is the email-address:
(e-mail address removed)

Don't know if this is something I fix in Access or Outlook?
Hope somebody can help me, I really need this to work!

Thanks,
Anders Berlin
 
Hi Anders,

This sort of thing is a common frustration when linking to Outlook data.
The problem is that the "fields" you see in the usual Outlook forms are
only indirectly related to the actual data stored wherever that
particular installation of Outlook stores it. For instance, for Contacts
there are

1) the "fields" in the usual Contacts form, which are a subset of
2) the much wider set of "contact fields" available in the Outlook
Define Views dialog, which correspond more or less one-to-one to
3) the *properties* exposed by the Contact object in the Outlook
object model, which are *not* the same as
4) the actual data fields that are stored.

And then there are
(5) the fields that appear when you try and export from or link to the
Contacts folder.

For emails, the situation is similar, substituting "MailItem" for
"Contact".

As I understand it, just what appears in (5) is determined to some
extent by the current view of the folder, so you might try altering
the view and re-linking to Access. Otherwise, you can always get
pretty much what you want by using the Outlook object model via
Automation. The actual email address is in the SenderEmailAddress
property of the MailItem object, and the display name is in the
SenderName property.



Here are some useful links:

The best single place I know for information about Outlook is
http://www.slipstick.com

Accessing Microsoft Exchange and Outlook Data Using Visual Basic
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnout98/html/olexcoutlk.asp

Sample Procedure to Link a Microsoft Outlook Folder
http://support.microsoft.com/?id=209946

How to programmatically export Outlook items to Access
http://support.microsoft.com/?id=290792
http://support.microsoft.com/?id=253794

OL2000: How to Programmatically Import Outlook Items from Microsoft
Access
http://support.microsoft.com/?id=208232

Using Automation in Microsoft Office Access 2003 to Work with Microsoft
Office Outlook 2003
http://msdn.microsoft.com/library/d...ry/en-us/dno2k3ta/html/odc_ac_olauto.asp?_r=1
 
Back
Top