VBA Help (Outlook to Excel Extract)

[danny8890]

Hi,

I currently have this piece of code in a bigger piece to extract emails from outlook my issue is that the "To" is bringing back the name rather than email address the email was sent to.

strColC = olItem.SenderEmailAddress    strColA = olItem.Subject
    strColB = olItem.Sender
    strColD = olItem.Body
    strColE = olItem.To
    strColF = olItem.ReceivedTime

Any help would be great.

Thanks

 

[Norie]

You probably want the Recipients collection of the item to get the email addresses of the people it was sent to.