Reading Outlook emails in Access VBA 2

[PizMac]

I am writing code behind a form to read emails from a specified outlook folder, download attachments and do various other processing. I am unable to find the code to get the sender's email address. I can get the recipient (the TO name) with .to (although it requres permission to be granted). The .subject and .attachments all work fine but I can't find the correct property for the senders email address. Can anyone help please?

 

[Remou]

This may help:

http://www.dimastr.com/redemption/

 

[TheAceMan1]

How are ya PizMac . . .

Curious . . . Post what you have . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[ClulessChris]

Try .SenderName

Never knock on Death's door: ring the bell and run away! Death really hates that!

 

[PizMac]

Thanks to ClulessChris - that gave me the name to play with, although now I get the security confirmation prompt and may need to find a work around for that. Thanks also to Remou- I may use this link later.

 

[Remou]

Sendername will not give you the senderemailaddress, which is available, but blocked by Outlook security. Redemption (see link) will allow you to access this useful information, without warnings.