跳到主要内容

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

通常,发件人的名称显示在“收件箱”文件夹的邮件列表中,但是有时,您可能希望显示发件人的完整电子邮件地址,如以下屏幕截图所示。 您如何在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 - 超过 100 种强大功能可增强您的 Outlook

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

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

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

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

🌟 界面魔法: 😊更多又漂亮又酷的表情符号   /  使用选项卡式视图提高 Outlook 工作效率  /  最小化 Outlook 而不是关闭 ...

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

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

超过 100特点 等待您的探索! 单击此处了解更多。

了解更多       免费下载      购买
 

 

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!
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.
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
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]+">"))
This comment was minimized by the moderator on the site
works, but cannot sort from this field
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 ?
This comment was minimized by the moderator on the site
Simpler formula that does the same :

IIf(InStr([SearchFromEmail], "@") = 0, "", [SearchFromEmail])
This comment was minimized by the moderator on the site
Hello, Fred,
Thank you for your comment, this formula is more simpler.
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.
This comment was minimized by the moderator on the site
i have this issue too. I hate OUTLOOK
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations