True Email address in "From" field

[jgus]

I have linked a MS Outlook inbox to a table in MS Access so that each email is represented by a record in the table. The problem is that in the "From" field it sometimes shows the person's name and other times shows their email address. I would like to have a field always show the true email address and not the name. Is their a way I can do this?

The true email address is obviously stored somewhere in Outlook, but I just can't see where I can pull this info into Access.

Thanks

 

[Databaseguy]

I assume you linked to the table using the linked table manager ?

 

[jgus]

Yes, it is just through linked table manager. Seems like a cool feature being able to link directly to an Outlook folder, but it is just not quite giving me the information I need.