跳到主要内容

 如何始终在邮件列表中显示完整的电子邮件地址?

作者:晓阳 最后修改时间:2018-11-14

通常,发件人的名称显示在“收件箱”文件夹的邮件列表中,但是有时,您可能希望显示发件人的完整电子邮件地址,如以下屏幕截图所示。 您如何在Outlook的收件箱中显示发件人的电子邮件地址?

doc显示电子邮件地址4

始终在Outlook的邮件列表中显示完整的电子邮件地址


始终在Outlook的邮件列表中显示完整的电子邮件地址

以下步骤可以帮助您在邮件的列表中显示发件人的电子邮件地址 收件箱 文件夹,请按以下步骤操作:

1。 点击 首页 > 添加列,请参见屏幕截图:

doc显示电子邮件地址1

2。 在 显示列 对话框,请执行以下操作:

(1.)点击 新的列 按钮去 新的列 对话框;

(2.)在 新的列 对话框中,为此新列指定名称;

(3.)然后选择 公式 来自 Type 下拉列表;

(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 发布 免费版本!

体验全新的 Kutools for Outlook 免费版本拥有 70 多项令人难以置信的功能,您可以永久使用! 点击立即下载!

🤖 Kutools人工智能 : 具有人工智能魔力的即时专业电子邮件——一键天才回复、完美语气、多语言掌握。轻松改变电子邮件! ...

📧 电子邮件自动化: 自动回复(适用于 POP 和 IMAP)  /  安排发送电子邮件  /  发送电子邮件时按规则自动抄送/密件抄送  /  自动转发(高级规则)   /  自动添加问候语   /  自动将多收件人电子邮件拆分为单独的消息 ...

📨 电子邮件管理: 撤回电子邮件  /  按主题和其他人阻止诈骗电子邮件  /  删除重复的电子邮件  /  高级搜索  /  合并文件夹 ...

📁 附件专业版批量保存  /  批量分离  /  批量压缩  /  自动保存   /  自动分离  /  自动压缩 ...

🌟 界面魔法: 😊更多又漂亮又酷的表情符号   /  收到重要邮件时提醒您  /  最小化 Outlook 而不是关闭 ...

👍 一键奇迹: 使用传入附件回复全部  /   反网络钓鱼电子邮件  /  🕘显示发件人的时区 ...

👩🏼‍🤝‍👩🏻 通讯录和日历: 从选定的电子邮件中批量添加联系人  /  将联系人组拆分为各个组  /  删除生日提醒 ...

只需单击一下即可立即解锁 Kutools for Outlook -永久免费. 别等了, 立即下载并提高您的效率!

kutools for outlook 功能1 kutools for outlook 功能2
 

 

 

Comments (14)
No ratings yet. Be the first to rate!
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'
This comment was minimized by the moderator on the site
Εμένα στα εισερχόμενα αντί τη διεύθυνση του αποστολέα μου εμφανίζει τη διεύθυνση του παραλήπτη, δηλαδή τη δική μου. Τι μπορώ να κάνω;
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.
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
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!
There are no comments posted here yet
Load More
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations