Skip i'r prif gynnwys

 Sut i ddangos cyfeiriad e-bost llawn yn y rhestr bostio bob amser?

Fel rheol, mae enw'r anfonwr yn cael ei arddangos yn rhestr bostio'r ffolder Mewnflwch, ond weithiau, efallai y byddwch chi am i gyfeiriad e-bost llawn yr anfonwr gael ei arddangos fel y dangosir y screenshot canlynol. Sut allech chi ddangos cyfeiriad e-bost anfonwr ym Mewnflwch y Rhagolwg?

doc dangos cyfeiriad e-bost 4

Dangoswch gyfeiriad e-bost llawn yn y rhestr bostio bob amser yn Outlook

Dangoswch gyfeiriad e-bost llawn yn y rhestr bostio bob amser yn Outlook

Gall y camau canlynol eich helpu i arddangos cyfeiriad e-bost yr anfonwr yn rhestr bostio'r Mewnflwch ffolder, gwnewch fel hyn:

1. Cliciwch Gweld > Ychwanegu Colofnau, gweler y screenshot:

doc dangos cyfeiriad e-bost 1

2. Yn y Dangos Colofnau blwch deialog, gwnewch y gweithrediadau canlynol:

(1.) Cliciwch Colofn Newydd botwm i fynd y Colofn Newydd blwch deialog;

(2.) Yn y Colofn Newydd blwch deialog, nodwch enw ar gyfer y golofn newydd hon;

(3.) Yna dewiswch Fformiwla oddi wrth y math rhestr ostwng;

(4.) Ac yna, pastiwch y fformiwla hon i'r Fformiwla blwch: IIf (InStr ([SearchFromEmail], "@") = 0, "", Chwith ([SearchFromEmail], InStr ([SearchFromEmail], "@") - 1) + "@" + Mid ([SearchFromEmail], InStr ( [SearchFromEmail], "@") + 1)).

doc dangos cyfeiriad e-bost 2

3. Yna, cliciwch OK i ddychwelyd i'r Dangos Colofnau blwch deialog, ac yna dewiswch enw'r golofn newydd rydych chi'n ei chreu, a'i symud i'r lleoliad sydd ei angen arnoch chi trwy glicio Symud i fyny botwm, yr enghraifft hon, byddaf yn ei symud o flaen y Pwnc colofn, gweler y screenshot:

doc dangos cyfeiriad e-bost 3

4. Ac yna, cliciwch OK botwm i gau'r ymgom hwn, nawr, bydd cyfeiriadau e-bost yr anfonwr yn cael eu harddangos yn y rhestr bostio fel y dangosir ar-lein:

doc dangos cyfeiriad e-bost 4

Offer Cynhyrchiant Swyddfa Gorau

Kutools ar gyfer Rhagolwg - Dros 100 o Nodweddion Pwerus i Werthu Eich Outlook

🤖 Cynorthwy-ydd Post AI: E-byst pro ar unwaith gyda hud AI - un clic i atebion athrylith, tôn berffaith, meistrolaeth amlieithog. Trawsnewid e-bostio yn ddiymdrech! ...

📧 E-bostio Automation: Allan o'r Swyddfa (Ar gael ar gyfer POP ac IMAP)  /  Amserlen Anfon E-byst  /  Auto CC/BCC gan Reolau Wrth Anfon E-bost  /  Awto Ymlaen (Rheolau Uwch)   /  Auto Ychwanegu Cyfarchiad   /  Rhannwch E-byst Aml-Dderbynnydd yn Negeseuon Unigol yn Awtomatig ...

📨 Rheoli E-bost: Dwyn i gof E-byst yn Hawdd  /  Rhwystro E-byst Sgam gan Bynciau ac Eraill  /  Dileu E-byst Dyblyg  /  Chwilio Manwl  /  Cydgrynhoi Ffolderi ...

📁 Ymlyniadau Pro: Arbed Swp  /  Swp Datgysylltu  /  Cywasgu Swp  /  Auto Achub   /  Datgysylltiad Auto  /  Cywasgiad Auto ...

🌟 Rhyngwyneb Hud: 😊Mwy o Emojis Pretty a Cŵl   /  Rhowch hwb i'ch Cynhyrchiant Outlook gyda Golygfeydd Tabbed  /  Lleihau Outlook Yn lle Cau ...

???? Rhyfeddodau un clic: Ateb Pawb ag Ymlyniadau Dod i Mewn  /   E-byst Gwrth-Gwe-rwydo  /  🕘Dangos Parth Amser yr Anfonwr ...

👩🏼‍🤝‍👩🏻 Cysylltiadau a Chalendr: Swp Ychwanegu Cysylltiadau O E-byst Dethol  /  Rhannwch Grŵp Cyswllt i Grwpiau Unigol  /  Dileu Atgoffa Pen-blwydd ...

Dros Nodweddion 100 Aros Eich Archwiliad! Cliciwch Yma i Ddarganfod Mwy.

 

 

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