how to get email address of sender in outlook

[TheOne23]

Hi Everyone / MVPs / Experts

 

I have an issue on retrieving an email address of a sender in outlook using below code.

it only get the AD properties like below rather than Email Address

example:

 /O=COMCAST/OU=EXCHANGE ADMINISTRATIVE GROUP (FYDIBOHF23SPDLT)/CN=RECIPIENTS/CN=RFITZG203FAE

Below is my code: based on OutlookEX.au3

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)

$emailadd = _ArrayToString($aOL_Item,"",1,1,"",3,3) ; body
ConsoleWrite($emailadd)

Your help will be greatly appreciated.

[water]

Something like this (untested):

Local $oOL_Item = $oOutlook.Session.GetItemFromID($aOL_Item[1][1], 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)
    EndIf

 

[TheOne23]

Hi Water, 

I tried this code but does not show anything.

I tried to put an else statement to check if condition is true and got the "failed" result.

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][1], 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") ; Added this to check if condition is met or not.
    EndIf

 

[water]

Does _Arraydisplay (now commented) display EntryId in row 1?

[TheOne23]

Hi Water,

 

Sorry for the confusion. I commented _arraydisplay() just to push through the output at once.

the result of arraydisplay where "SenderEmailAddress" output shows is in row 1, column 3.

it shows like below and not as an email address.

/O=COMCAST/OU=EXCHANGE ADMINISTRATIVE GROUP (FYDIBOHF23SPDLT)/CN=RECIPIENTS/CN=RFITZG203FAE

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][3], 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

 

[water]

We need the EntryID to retrieve the senders mail address. So you need to use

$aOL_Item[1][0]

right?

[TheOne23]

Hi Water,

 

Got your point in there.

You solved it as usual. Really appreciated your help.

Thank you so much! 

More Power "Water"

[water]