how to retrieve outlook sender's email address (external senders and not exchange users)

[TheOne23]

Hi MVPs, Experts,

I would like to ask your kind assistance on how to retrieve email address of senders in outlook.

Water helped me last time to retrieve email address for exchange users and now I need to retrieve even the external users.

ex. if user sends email to my yahoo account and they use google account I cannot retrieve this google email address.

But it it is associated to yahoo it can be retrieved.

 

below is my existing code (courtesy of Water)

 

Global $oOutlook = _OL_Open()
If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF", "Error creating a connection to Outlook. @error = " & @error & ", @extended = " & @extended)

Global $aOL_Item = _OL_ItemFind($oOutlook, "RonaldJayson_paggao@comcast.com\Inbox\BP_automation", $olMail, "[UnRead]=True", "", "", "EntryID,body,receivedtime,senderemailaddress", "", 2)
_ArrayDisplay($aOL_Item)

Local $oOL_Item = $oOutlook.Session.GetItemFromID($aOL_Item[1][0], Default)
    Local $oOL_Sender = $oOL_Item.Sender
    If $oOL_Sender.AddressEntryUserType = $olExchangeUserAddressEntry Or $oOL_Sender.AddressEntryUserType = $olExchangeRemoteUserAddressEntry Then
        Local $oExchangeUser = $oOL_Sender.GetExchangeUser
        MsgBox(0, "Mail", $oExchangeUser.PrimarySmtpAddress)
    Else 
        MsgBox(0,"Mail","Failed")
    EndIf

 

Regards,

 

Ronald

[water]

In this case the mail address gets returned in the array by _OL_ItemFind as senderemailaddress.

[TheOne23]

Hi Water,

Is there a way to capture the email address of the sender if the sender has external email?

Thanks

[water]

I tested with an external address (e.g. john.doe@gmx.com) and this is returned in $aOL_Item[1][2] or $oOL_Item.SenderEmailAddress (based on your script).

Edited February 5, 2019 by water

[TheOne23]

Hi Water,

Thank you for your great help.

I already got it and extract the email from the array.

 

Thank you very much. 

[water]