MailItems - which does i need for the recipients email adress

[netzgedanken]

Hy,

i want to know, what mail item i have to use in a vba script do find
the
recipients email adress.

look - thats my code:
.........
For Each obj In olFolder.Items
If TypeOf obj Is Outlook.MailItem Then
Set olMail = obj
sAdr = olMail.to
colAdr.Add sAdr, sAdr
End If
Next
.............

sAdr = olMail.to this line brings me up the To Item in the mails. But
sometimes there is no email adresse inside. E. g: "mathias
muehlfelder"

i want to become the email adress that have recieved this email
object.

can you tell me, what item i have to choose?

i hope you understand my problem...

thanks mathias

 

[Ken Slovak - [MVP - Outlook]]

Outlook 2003 has a MailItem.SenderEmailAddress property, for earlier
versions of Outlook you would need to use CDO 1.21 code or Redemption
code (www.dimastr.com/redemption). For a CDO code example see
http://www.slovaktech.com/code_samples.htm#FromAddress

If you reply to this message please post some of the preceding thread
in it. That ExcelTips interface you are using doesn't do that and it
makes it impossible to follow a thread.