跳到主要內容

 如何始終在郵件列表中顯示完整的電子郵件地址？

通常，發件人的名稱顯示在“收件箱”文件夾的郵件列表中，但是有時，您可能希望顯示發件人的完整電子郵件地址，如以下屏幕截圖所示。 您如何在Outlook的收件箱中顯示發件人的電子郵件地址？

doc顯示電子郵件地址4

始終在Outlook的郵件列表中顯示完整的電子郵件地址

始終在Outlook的郵件列表中顯示完整的電子郵件地址

以下步驟可以幫助您在郵件的列表中顯示發件人的電子郵件地址 收件箱 文件夾，請按以下步驟操作：

1。 點擊 瀏覽 > 添加列，請參見屏幕截圖：

doc顯示電子郵件地址1

2。 在 顯示列 對話框，請執行以下操作：

（1.）點擊 新列 按鈕去 新列 對話框;

（2.）在 新列 在對話框中，為此新列指定名稱；

（3.）然後選擇 公式 來自 類別 下拉列表;

（4.）然後，將此公式粘貼到 公式 箱： IIf（InStr（[SearchFromEmail]，“ @”）= 0，“”，左（[SearchFromEmail]，InStr（[SearchFromEmail]，“ @”）-1）+“ @” + Mid（[SearchFromEmail]，InStr（ [SearchFromEmail]，“ @”）+ 1））.

doc顯示電子郵件地址2

3。 然後，點擊 OK 回到了 顯示列 對話框，然後選擇創建的新列名稱，然後通過單擊將其移動到所需的位置 提前 按鈕，在此示例中，我將其移至 主題 列，請參見屏幕截圖：

doc顯示電子郵件地址3

4。 然後，單擊 OK 按鈕關閉此對話框，現在，發件人的電子郵件地址將顯示在郵件列表中，如以下屏幕截圖所示：

doc顯示電子郵件地址4

最佳辦公生產力工具

Kutools for Outlook - 超過 100 種強大的功能可增強您的 Outlook

🤖 人工智慧郵件助手: 具備人工智慧魔力的即時專業電子郵件——一鍵天才回覆、完美語調、多語言掌握。輕鬆改變電子郵件！ ……

📧 電子郵件自動化: 外出（適用於 POP 和 IMAP）  /  安排發送電子郵件  /  發送電子郵件時按規則自動抄送/密件副本  /  自動轉送（進階規則）   /  自動添加問候語   /  自動將多收件者電子郵件拆分為單獨的訊息 ...

📨 電子郵件管理: 輕鬆回憶電子郵件  /  按主題和其他人阻止詐騙電子郵件  /  刪除重複的電子郵件  /  進階搜索  /  合併資料夾 ...

📁 附件專業版: 批量保存  /  批量分離  /  批量壓縮  /  自動保存   /  自動分離  /  自動壓縮 ...

🌟 介面魔法: 😊更多又漂亮又酷的表情符號   /  使用選項卡式視圖提高 Outlook 工作效率  /  最小化 Outlook 而不是關閉 ...

👍 一鍵奇蹟: 使用傳入附件回覆全部  /   反網路釣魚電子郵件  /  🕘顯示寄件者的時區 ...

👩🏼‍🤝‍👩🏻 通訊錄和行事曆: 從選定的電子郵件中大量新增聯絡人  /  將聯絡人群組拆分為各組  /  刪除生日提醒 ...

超過 100特點 等待您的探索！ 按此處了解更多。

閱讀更多       免費下載      購買
 

 

Comments (14)
No ratings yet. Be the first to rate!
Ivan Kellenberger
Ivan Kellenberger
This comment was minimized by the moderator on the site
I would like to suggest the following formula:

IIf(InStr([SearchFromEmail],"@")=0,"MyCompany: ",IIf(From=[SearchFromEmail],"",[SearchFromEmail]+": "))+[From]

1. Create a new 'column' as described above and name it e.g. SearchFromEmail&From
2. Insert the formula IIf(InStr([SearchFromEmail],"@")=0,"MyCompany: ",IIf(From=[SearchFromEmail],"",[SearchFromEmail]+": "))+[From] and replace MyCompany with e.g. the name of your organisation (followed by a colon and a space)
3. Click 'OK' and drag or move SearchFromEmail&From just underneath the field 'From'
4. Remove 'From' and click 'OK'
Reply
0
0
Χρήστος1963
Χρήστος1963
This comment was minimized by the moderator on the site
Εμένα στα εισερχόμενα αντί τη διεύθυνση του αποστολέα μου εμφανίζει τη διεύθυνση του παραλήπτη, δηλαδή τη δική μου. Τι μπορώ να κάνω;
Reply
0
0
jay
jay
This comment was minimized by the moderator on the site
There are some OG's in this comment string. Thanks Ray, I used that to enable what should be a BASIC FEATURE for an email client. Imagine telling someone in 2000 that in 2022 you wouldn't be able to view the address of a sender... in your email client. M$ makes such arbitrary and unnecessary changes.
Reply
0
0
ratextdoffice
ratextdoffice
This comment was minimized by the moderator on the site
how add a column for Primary Email address column when there is on behalf address
Reply
Report
0
0
Cornan
Cornan
This comment was minimized by the moderator on the site
Like one other responder, I am seeking the smtp address for the "To" column.

I thought that if there is a field named "SearchFromEmail", there might be a "SearchToEmail"... but there is not.

It's also difficult to search for "SearchFromEmail" as our modern "helpful" search engines split up the field name into separate words.

In which object is "SearchFromEmail" defined?
Is there an equivalent of "SearchFromEmail" for the "To" column?

Thanks!
Reply
Report
0
0
Jill
Jill
This comment was minimized by the moderator on the site
How would I modify the formula to display the To field in my Sent Items folder?

The above works great for displaying the From field in my Inbox for most email addresses. For some reason, it won't display the email address when the Sender is internal to my organization but that's not an issue for me.
Reply
0
0
kajal
kajal     Jill
This comment was minimized by the moderator on the site
Agree with your comment. Wish there was a simple solution for email address in the sent items as well
Reply
0
0
Ray
Ray
This comment was minimized by the moderator on the site
I followed these instructions but changed to formula to the following. It adds the email address on the same line next to the From name just like it shows when you open the email. I then *removed* the From field and added my new EmailAddress field (as I named it) in its place. If the From is the same and the email address, it is only displayed once.
[From]+IIf(InStr([SearchFromEmail],"@")=0,"",IIf(From=[SearchFromEmail],""," <"+[SearchFromEmail]+">"))
Reply
0
0
joe
joe
This comment was minimized by the moderator on the site
works, but cannot sort from this field
Reply
0
0
Lucy
Lucy
This comment was minimized by the moderator on the site
Hello, I am trying to do the same think but for recipients ("to" or "cc")


Someone can help me ?
Reply
0
0
Fred
Fred
This comment was minimized by the moderator on the site
Simpler formula that does the same :

IIf(InStr([SearchFromEmail], "@") = 0, "", [SearchFromEmail])
Reply
0
0
skyyang
skyyang     Fred
This comment was minimized by the moderator on the site
Hello, Fred,
Thank you for your comment, this formula is more simpler.
Reply
Report
0
0
Rafael
Rafael     skyyang
This comment was minimized by the moderator on the site
How it is possible when open the email, to see the full email adress in the adress bar "To: eSky" -----> "To: ******@esky.bg" and not to click on "eSky" and then in new popup to see the full email adress the email was sent to.
Reply
0
0
Guest
Guest     Rafael
This comment was minimized by the moderator on the site
i have this issue too. I hate OUTLOOK
Reply
0
0
There are no comments posted here yet
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations