Get Email Address When Linking to Exchange

[MIG]

When I link to an Exchange folder, the resulting table in Access only
gives me the text of the display name of the From, To and CC.

To be really useful, I need to be able to get at the underlying email
address. It seems odd that something so significant doesn't link.

Does anyone know how to get at the email address when linking to an
Exchange folder?

Thanks.

 

[MIG]

When I link to an Exchange folder, the resulting table in Access only
gives me the text of the display name of the From, To and CC.

To be really useful, I need to be able to get at the underlying email
address.  It seems odd that something so significant doesn't link.

Does anyone know how to get at the email address when linking to an
Exchange folder?

Thanks.

Further to this, I realise that it won't be much use anyway, because
it doesn't include any kind of ID for an email.

My plan was to allow people to link a particular enquiry record in
Access, say, to a relevant email, but without an ID, this isn't really
possible.

No doubt emails in Exchange do have IDs, but would have to be linked
in a more sophisticated way.