Outlook 2007 vsto add-in. Get email sender address
Asked Answered
W

4

11

I have a VSTO Outlook 2007 add-in. I am trying to get sender e-mail address when new email comes to Inbox.
To do it I use the following code:

void inboxItems_ItemAdd(object Item)
{     
    Outlook.MailItem mailItem = Item as Outlook.MailItem;

    if (mailItem != null)
        string emailAdress = mailItem.SenderEmailAddress;  
}

The problem is when e-mail comes from the same domain, emailAdress contains LDAP address like

/O=FIRST ORGANIZATION/OU=FIRST ADMINISTRATIVE GROUP/CN=RECIPIENTS/CN=ADMINISTRATOR

while I want to get SMTP address like

[email protected]

My question is how to get SMTP sender address of e-mail from internal domain?

P. S.
In Outlook 2010 this problem can be solved by using Sender property. But it is not supported in 2007.

item.Sender.GetExchangeUser().PrimarySmtpAddress
Willman answered 28/12, 2011 at 11:7 Comment(1)
If you are interested please commit for this :stackoverflow.com/documentation/outlook-addin/commitPless
B
16

In Outlook 2007 you can do it like this:

private string GetSmtpAddress(Outlook.MailItem oItem)
{
    Outlook.Recipient recip;
    Outlook.ExchangeUser exUser;
    string sAddress;

    if (oItem.SenderEmailType.ToLower() == "ex")
    {
        recip = Globals.ThisAddIn.Application.GetNamespace("MAPI").CreateRecipient(oItem.SenderEmailAddress);
        exUser = recip.AddressEntry.GetExchangeUser();
        sAddress = exUser.PrimarySmtpAddress;
    }
    else
    {
        sAddress = oItem.SenderEmailAddress.Replace("'", "");
    }
    return sAddress;
}
Boony answered 28/12, 2011 at 14:29 Comment(6)
Is there a similar method to get the senders address in visual basic?Medorra
Yes @ASM2701, you can to exactly the same in VB.NET. The VB syntax is different from the C# one, no semicolons or curly braces, but you should be able to figure it out without any big problems.Boony
If you are interested please commit for this :stackoverflow.com/documentation/outlook-addin/commitPless
There is absolutely no reason to use Namespace.CreateRecipient. Just use MailItem.Sender.GetExchangeUser().PrimarySmtpAddress,Unreconstructed
@DmitryStreblechenko I'm getting a "Attempted to read or write protected memory. This is often an indication that other memory is corrupt" error when trying to access the MailItem.Sender. Any clue how to get around this?Banyan
What version of Outlook are you using?Unreconstructed
P
2

Here I am presenting a method that can be used to get sender's email address by passing an email item as a reference. The method it self will decide weather the sender's email address type is SMTP or Exchange. If it is Exchange, it will convert the email address into SMTP. Here is the code.

    internal static string GetSenderEmailAddress(ref Outlook.MailItem oM)
    {
        Outlook.PropertyAccessor oPA = null;
        Outlook.AddressEntry oSender = null;
        Outlook.ExchangeUser oExUser = null;

        string SenderID;
        string senderEmailAddress;

        try
        {                
            if (oM.SenderEmailAddress.Contains("@") && oM.SenderEmailAddress.Contains(".com")) //Handing smtp email addresses
            {
                senderEmailAddress = oM.SenderEmailAddress;
            }
            else //Handing exchange email addresses
            {
                // Create an instance of PropertyAccessor 
                oPA = oM.PropertyAccessor;
                // Obtain PidTagSenderEntryId and convert to string 
                SenderID = oPA.BinaryToString(oPA.GetProperty("http://schemas.microsoft.com/mapi/proptag/0x0C190102"));
                // Obtain AddressEntry Object of the sender 
                oSender = Globals.ObjNS.GetAddressEntryFromID(SenderID);

                oExUser = oSender.GetExchangeUser();
                senderEmailAddress = oExUser.PrimarySmtpAddress;
            }
            Debug.DebugMessage(3, "OutlookHelper : GetSenderEmailAddress() : Completed");
            return senderEmailAddress;
        }
        catch (Exception ex)
        {
            MessageBox.Show( ex.Message);
            return null;
        }
        finally
        {
            if (oExUser != null) Marshal.ReleaseComObject(oExUser);
            if (oSender != null) Marshal.ReleaseComObject(oSender);
            if (oPA != null) Marshal.ReleaseComObject(oPA);
        }
    }
Pless answered 24/2, 2016 at 5:15 Comment(0)
S
0

You can use inspector to get current email as follow.

 Outlook.Inspector inspector = Globals.ThisAddIn.Application.ActiveInspector();
            if (inspector != null)
            {
                Outlook.MailItem  mi = inspector.CurrentItem as Outlook.MailItem;

              //Then identify whether email sender is exchange user or normal user
               string senderEmail=null;
               if (mi.SenderEmailType == "EX")
                {
                senderEmail = mi.Sender.GetExchangeUser().PrimarySmtpAddress;                    
                 }
              else
                {
                 senderEmail=mi.SenderEmailAddress;
                }
             }

you will get sender email in senderEmail variable.

Snakemouth answered 26/8, 2017 at 11:45 Comment(0)
R
0

email.Sender must be available in a higher version than outlook 2007

Rahr answered 1/7, 2020 at 8:14 Comment(2)
In what version of outlook is it available then? Or is it just a guess?Copeck
According to this website and my test. #24362226Harwood

© 2022 - 2024 — McMap. All rights reserved.