Reading Outlook EMails into Access 2000

[1897]

When i read in an Outlook Email in Access and try to retrieve the senders email address it just gives the name of the person and not the actual email address it was sent from. I've currently got this bit of code.

rst!EMail = MailObject.SendersName

Does anyone know what code i need to retrieve the actual senders EMail Address. I'm Using Access & Outlook 2000

Thanks

 

[HitechUser]

1897,

Here is a detailed article. (Outlooks perspective)

Win200mag

Let me know it this helps...

 

[PHV]

Use SenderEmailAddress instead of SenderName (not Sender[red]s[/red]Name)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[1897]

When i use SenderEMailAddress i get the error 'Object doesn't support this property or method'

 

[PHV]

which kind of object is MailObject ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244