Topics Map > SCS Computing > How-To
HOWTO: Show a sender's domain in Outlook
Tested on Windows
In Outlook, the sender's email address is not shown in the message list, nor when you open a message. All you get is the sender's name. So, if a malicious person sent you a message from someone you know, you might not detect it.
This guide will help you to add a column to your message list that will show you the sender's domain (i.e. illinois.edu, gmail.com, etc.). That way, if you receive a message from someone but the domain isn't what you expect, you should be on guard for a phishing or other malicious email. NOTE: If the sender is using the University's Exchange server, the formula does not show any domain. Otherwise, it prints the actual domain of the sender.
Here's what you do:
- Open Outlook
- In your message list, click View (green arrow, below)
- In the View ribbon, click on Change View (purple), then on Manage Views (blue)
- Click on <Current View Settings>, then on Copy. (this will allow you to go back to your old settings if you wish)
- Call the new view something like "Standard View", (you're free to change the "Can be used on" settings if you wish) and click OK
- In the "Advanced View Settings" window, click OK. Your current view settings are now saved should you want to go back to them.
- Click on <Current View Settings>, then on Copy again.
- Call the new view something like "Domain View", (you're free to change the "Can be used on" settings if you wish), and click OK
- In the "Advanced View Settings" window, click on Columns (blue arrow, below)
- Click on the New Column... button (purple arrow).
- In the "Name" field, type Domain. (as shown, lower right corner)
- In the "Type" field, select "Formula"
- In the "Formula" field, paste in the following:
- IIf(InStr([SearchFromEmail], "@") = 0, "illinois.edu", Mid([SearchFromEmail], InStr([SearchFromEmail], "@") + 1))
- IIf(InStr([SearchFromEmail], "@") = 0, "illinois.edu", Mid([SearchFromEmail], InStr([SearchFromEmail], "@") + 1))
- Click on the newly created "Domain" column (it will be at the bottom of the list on the right), and and click the Move Up button (green arrow) until "Domain" is just below "From" (orange arrow).
-
Click OK to close the "Columns" window.
-
Click OK to close the "Advanced View Settings" window
-
Click on the "Domain View" (under "View Name") and click Apply View.
-
Click OK to close this window.
-
Done!