Recepient Email address using VBA

[neemi]

Does anyone know how I can get the recepient email address from an email using VBA for an active email...

more details posted at thread707-1085805

 

[dhulbert]

Have a look at the recipients collection or the to property.

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[nickpark]

Something similar to the following (excerpt from a script i wrote so untested).

    Dim objNS As Outlook.NameSpace
    Dim MyFolder As Outlook.MAPIFolder

    Set objNS = Application.GetNamespace("MAPI")
    Set MyFolder = objNS.PickFolder

    For Each objItem In MyFolder.Items

        For Each Recip In objItem.Recipients
           addr = LCase(Recip.Address)
        Next

    Next

 

[nickpark]

Just read my code... absolutely useless in itself, but should give you the general idea!