Access 2000, How can I get the REAL email address?

[bobdydd]

Hi Everbody

Access 2000, Windows XP, Outlook 2000,

When I open my database it is set to attach to my Outlook 2000 Inbox.

So far so good..... The attaching procedure works OK and I am able to
see my Outlook 2000 Inbox........Which I can view as a table, within my
Access 2000 database.

I want to be able to see the email address in the "FROM" field.

The problem with this is that very few people have their email address
viewable in the "FROM" field.............usually just a shortened
version of their personal name.............However the real email is
underneath and if you doubleclick on the "FROM" field in Outlook
2000...it is viewable.

The kind of thing I mean is something like this:
(e-mail address removed) might have something like "elvis" in the
"FROM" field when viewed in Access 2000.

So my question is how do I get to the "REAL EMAIL ADDRESS" in Access
2000

Regards To All

Bob

 

[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 .

In Outlook 2000, there is no property that returns the sender's email address. You can either use CDO 1.21 (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.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[bobdydd]

Hi Sue

Wow! That was quick reply.....What I am thinking of is to trap the
error for no "@" sign and tell the enduser to go to Outlook and do the
doubleclick to get the proper email address manually...........Not
something I am going to be proud of though

Thanks again

Bob

 

[Guest]

why oh why is Bill so intent on hiding that "real" email address? Can you
even pick it as an inbox column in the newest outlook?

 

[bobdydd]

Hmm.........Makes you wonder

My guess he is trying to make it more difficult for the spammers

Regards Bob

 

[david epsom dot com dot au]

Hi Everbody

Access 2000, Windows XP, Outlook 2000,

When I open my database it is set to attach to my Outlook 2000 Inbox.

So far so good..... The attaching procedure works OK and I am able to
see my Outlook 2000 Inbox........Which I can view as a table, within my
Access 2000 database.

I want to be able to see the email address in the "FROM" field.

The problem with this is that very few people have their email address
viewable in the "FROM" field.............usually just a shortened
version of their personal name.............However the real email is
underneath and if you doubleclick on the "FROM" field in Outlook
2000...it is viewable.

The kind of thing I mean is something like this:
(e-mail address removed) might have something like "elvis" in the
"FROM" field when viewed in Access 2000.

So my question is how do I get to the "REAL EMAIL ADDRESS" in Access
2000

Regards To All

Bob

 

[david epsom dot com dot au]

Note that if you are on a windows network with Active Directory
and Exchange, you can probably get the email addresses from
Active Directory.

(david)