Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to view senders’ domain in mail list in Outlook?

In Outlook, have you even received some email messages from strange senders with only showing senders’ displaying name in the mail list? See the following screen shot. Some Outlook users may think it will be safer to get the senders’ email domain before opening their email messages. In this article, I will show you how to view or display the senders’ email domains into the mail list in Microsoft Outlook.

Office Tab - Enable Tabbed Editing and Browsing in Office, and Make Work Much Easier...
Kutools for Outlook - Brings 100 Powerful Advanced Features to Microsoft Outlook
  • Auto CC/BCC by rules when sending email; Auto Forward Multiple Emails by rules; Auto Reply without exchange server, and more automatic features...
  • BCC Warning - show message when you try to reply all if your mail address is in the BCC list; Remind When Missing Attachments, and more remind features...
  • Reply (All) With All Attachments in the mail conversation; Reply Many Emails at once; Auto Add Greeting when reply; Auto Add Date&Time into subject...
  • Attachment Tools: Auto Detach, Compress All, Rename All, Auto Save All... Quick Report, Count Selected Mails, Remove Duplicate Mails and Contacts...
  • More than 100 advanced features will solve most of your problems in Outlook 2010-2019 and 365. Full features 60-day free trial.

To view or display the senders’ email domains into the mail list in Microsoft Outlook, you can follow these ways to get it.

Step 1: Open the mail folder in which you will view or display the senders’ email domains.

Step 2: Click the Add Columns button on the View tab.

Note: In Outlook 2007, you can click the View > Current View > Customize Current View, and then click the Fields button in the popping up Customize View: Compact dialog box.

Step 3: In the coming Show Columns (or Show Fields) dialog box, click the New Column button (or New Field button).

Step 3: Now you get into the New Column (or New Field) dialog box, and:

(1) In the Name box, enter a new name for this creating column.

(2) Click the Type box, and select the Formula from the drop down list.

(3) Click the Edit button, and then enter the following text into the Formula box of dialog box. See screen shot below:

right([SearchFromEmail],len([SearchFromEmail])-InStr(1,[SearchFromEmail],"@"))

(4) Click both OK buttons to close two dialog boxes.

Step 4: Now you get back into the Show Columns (or Show Fields) dialog box, select the new created column in the Show these columns in this order box, and move it below From. See screen shot below:

Step 5: Click the OK button(s).

Now you will view each sender’s email domain is added and shown below the sender’s displaying name. See the following screen shot:

To get method to save this custom view in Outlook, please click How to save and copy view settings to other folders in Outlook?


arrow blue right bubbleRelated Article

How to sort and group by sender domain in Outlook?


Kutools for Outlook - Brings 100 Advanced Features to Outlook, and Make Work Much Easier!

  • Auto CC/BCC by rules when sending email; Auto Forward Multiple Emails by custom; Auto Reply without exchange server, and more automatic features...
  • BCC Warning - show message when you try to reply all if your mail address is in the BCC list; Remind When Missing Attachments, and more remind features...
  • Reply (All) With All Attachments in the mail conversation; Reply Many Emails in seconds; Auto Add Greeting when reply; Add Date into subject...
  • Attachment Tools: Manage All Attachments in All Mails, Auto Detach, Compress All, Rename All, Save All... Quick Report, Count Selected Mails...
  • Powerful Junk Emails by custom; Remove Duplicate Mails and Contacts... Enable you to do smarter, faster and better in Outlook.
shot kutools outlook kutools tab 1180x121
shot kutools outlook kutools plus tab 1180x121
 
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Tim · 22 days ago
    Why does SearchToEmail not work? All the solutions are for the From column only.
  • To post as a guest, your comment is unpublished.
    Matt · 9 months ago
    I really loved this solution. However, my outlook keeps on crashing with the addition of this new column. I spent hours on with Microsoft tech support and they said to delete this column and that it seems to be an issue with Outlook. Really would love another solution to put senders address into the message preview. Disappointed that Microsoft support couldn't offer me any solutions to the crashing except for running Outlook in "cleanviews" :(
  • To post as a guest, your comment is unpublished.
    Net_Master · 10 months ago
    Anyone can provide a formula edit which show sender's domain or e-mail address, BUT from headers of e-mail - from Received: field. That would be useful for determine if the e-mail is spoofed or it's real!
    • To post as a guest, your comment is unpublished.
      Ricardo · 9 months ago
      Yes this is what I would prefer as well. Have you come across something like this yet?
  • To post as a guest, your comment is unpublished.
    corvety@gmail.com · 1 years ago
    Muy bueno..Thanks :)
  • To post as a guest, your comment is unpublished.
    mark · 1 years ago
    Is there anyway this can be deployed using group policy or via registry changes ?
  • To post as a guest, your comment is unpublished.
    AHalfwood · 1 years ago
    Brilliant! SOOO easy. These days it is so easy to 'mask' your email from others and send junk... This stops you opening and saves heaps of time and worry. Why Microsoft doesn't have this column is beyond me. Thanks for this, it is very helpful.
  • To post as a guest, your comment is unpublished.
    themoonandthelily · 1 years ago
    To view the full email address, do the same steps as above, but change formula to:

    right(([SearchFromEmail],[SearchFromEmail]),InStr(1,[SearchFromEmail],"@"))
  • To post as a guest, your comment is unpublished.
    Kajal · 1 years ago
    So helpful, Much Thankyou to the uploader
  • To post as a guest, your comment is unpublished.
    Lubomir · 1 years ago
    Nice idea and work! Thank you :-)
  • To post as a guest, your comment is unpublished.
    Nicholas · 1 years ago
    Thank you so much! This has saved me as I wanted the full email address and not just the domain.

    Next though, how do I do this for the Sent Items? I can only see the names of the people and I need to see their full email addresses as a column.
    • To post as a guest, your comment is unpublished.
      Steven · 1 years ago
      I have the same question. I tried changing the field to "SearchToEmail", but that didn't work :).
      • To post as a guest, your comment is unpublished.
        Laxman · 1 years ago
        Please reply on this how to get domain name of sent items.
  • To post as a guest, your comment is unpublished.
    Graham Gibby · 2 years ago
    How would I modify the formula to show the full sending address?
    • To post as a guest, your comment is unpublished.
      dave · 1 years ago
      delete everything after the (-) symbol and replace it with a closing parentheses.
      • To post as a guest, your comment is unpublished.
        Cecilia Hayes · 1 years ago
        This works perfectly EXCEPT MSO will not allow SORTing on this field. How to 'make it so'?
  • To post as a guest, your comment is unpublished.
    Steve · 2 years ago
    Try this improved forumla to elimate the problem with internal exchange addresses:
    IIf(InStr([SearchFromEmail], "@") = 0, "", Mid([SearchFromEmail], InStr([SearchFromEmail], "@") + 1))
    • To post as a guest, your comment is unpublished.
      Cecilia Hayes · 1 years ago
      See the instruction from 'dave' above regarding showing the full sending address. Can you modify your instruction to include this feature? Please and thank you.
      • To post as a guest, your comment is unpublished.
        Chris Carpenter · 1 years ago
        To show the full email address from external senders while leaving internal users blank:
        IIf(InStr([SearchFromEmail], "@") = 0, "", right([SearchFromEmail],len([SearchFromEmail])))
        • To post as a guest, your comment is unpublished.
          René Thor · 11 months ago
          Thank you! I tried to find a way to show the first receiving mailserver (name/ip). In some cases the mail is sent over open relays and the FromEmail looks safe, but the sending server is not trustable.