Note: The other languages of the website are Google-translated. Back to English
English English

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
 
Comments (26)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Try this improved forumla to elimate the problem with internal exchange addresses: IIf(InStr([SearchFromEmail], "@") = 0, "", Mid([SearchFromEmail], InStr([SearchFromEmail], "@") + 1))
This comment was minimized by the moderator on the site
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.
This comment was minimized by the moderator on the site
To show the full email address from external senders while leaving internal users blank:
IIf(InStr([SearchFromEmail], "@") = 0, "", right([SearchFromEmail],len([SearchFromEmail])))
This comment was minimized by the moderator on the site
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.
This comment was minimized by the moderator on the site
this formula works great, do you know one to for the receiving email?
This comment was minimized by the moderator on the site
How would I modify the formula to show the full sending address?
This comment was minimized by the moderator on the site
delete everything after the (-) symbol and replace it with a closing parentheses.
This comment was minimized by the moderator on the site
This works perfectly EXCEPT MSO will not allow SORTing on this field. How to 'make it so'?
This comment was minimized by the moderator on the site
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.
This comment was minimized by the moderator on the site
I have the same question. I tried changing the field to "SearchToEmail", but that didn't work :).
This comment was minimized by the moderator on the site
Please reply on this how to get domain name of sent items.
This comment was minimized by the moderator on the site
Nice idea and work! Thank you :-)
This comment was minimized by the moderator on the site
So helpful, Much Thankyou to the uploader
This comment was minimized by the moderator on the site
To view the full email address, do the same steps as above, but change formula to:

right(([SearchFromEmail],[SearchFromEmail]),InStr(1,[SearchFromEmail],"@"))
This comment was minimized by the moderator on the site
Thanks so much!
This comment was minimized by the moderator on the site
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.
This comment was minimized by the moderator on the site
Is there anyway this can be deployed using group policy or via registry changes ?
This comment was minimized by the moderator on the site
Muy bueno..Thanks :)
This comment was minimized by the moderator on the site
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!
This comment was minimized by the moderator on the site
Yes this is what I would prefer as well. Have you come across something like this yet?
This comment was minimized by the moderator on the site
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" :(
This comment was minimized by the moderator on the site
Why does SearchToEmail not work? All the solutions are for the From column only.
This comment was minimized by the moderator on the site
I agree with Matt. The string from themoonandthelily, "right(([SearchFromEmail],[SearchFromEmail]),InStr(1,[SearchFromEmail],"@"))", causes Outlook to crash, closing it immediately when selecting an email.

Too bad, because it was a very welcome addition.
This comment was minimized by the moderator on the site
Great Solution - works 99% of the time.  Almost every email now shows the 'Name' of the sender and immediately below the name, it shows the domain as well. 
ISSUE: The initial suspicious email that triggered this concern still shows a blank line under the sender's name.  Thoughts?
This comment was minimized by the moderator on the site
I wish it would work for "SearchToEmail" as well. But this is only wishful thinking ...
This comment was minimized by the moderator on the site
Go to View > View settings > Columns
Click "new Columns"

Name : External
Type : FormulaFormula : IIf(InStr([SearchFromEmail],"@")=0,"",Left([SearchFromEmail],InStr([SearchFromEmail],"@")-1)+"@"+Mid([SearchFromEmail],InStr([SearchFromEmail],"@")+1))

Click OK..Ok..


There are no comments posted here yet
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations