Vai al contenuto principale

 Come mostrare sempre l'indirizzo e-mail completo nella mailing list?

Normalmente, il nome del mittente viene visualizzato nella mailing list della cartella Posta in arrivo, ma a volte potresti volere che l'indirizzo email completo del mittente venga visualizzato come mostrato nella seguente schermata. Come potresti mostrare l'indirizzo email di un mittente nella Posta in arrivo di Outlook?

doc mostra indirizzo email 4

Mostra sempre l'indirizzo email completo nella mailing list in Outlook

Mostra sempre l'indirizzo email completo nella mailing list in Outlook

I seguenti passaggi possono aiutarti a visualizzare l'indirizzo email del mittente nella mailing list di Posta in arrivo cartella, per favore fai come segue:

1. Clic Visualizza > Aggiungere colonne, vedi screenshot:

doc mostra indirizzo email 1

2. Nel Mostra colonne finestra di dialogo, eseguire le seguenti operazioni:

(1.) Fare clic su Nuova colonna pulsante per andare al Nuova colonna la finestra di dialogo;

(2.) Nella Nuova colonna finestra di dialogo, specificare un nome per questa nuova colonna;

(3.) Quindi scegli Formula dal Tipologia menu `A tendina;

(4.) E poi, incolla questa formula nel file Formula box: IIf (InStr ([SearchFromEmail], "@") = 0, "", Left ([SearchFromEmail], InStr ([SearchFromEmail], "@") - 1) + "@" + Mid ([SearchFromEmail], InStr ( [SearchFromEmail], "@") + 1)).

doc mostra indirizzo email 2

3. Quindi, fare clic OK per tornare al Mostra colonne finestra di dialogo, quindi selezionare il nuovo nome di colonna che si è creato e spostarlo nella posizione desiderata facendo clic Move Up pulsante, in questo esempio, lo sposterò davanti al Oggetto colonna, vedi screenshot:

doc mostra indirizzo email 3

4. Quindi fare clic su OK pulsante per chiudere questa finestra di dialogo, ora, gli indirizzi e-mail del mittente verranno visualizzati nella mailing list come mostrato nella seguente schermata:

doc mostra indirizzo email 4

I migliori strumenti per la produttività in ufficio

Kutools for Outlook - Oltre 100 potenti funzionalità per potenziare il tuo Outlook

🤖 Assistente di posta AI: E-mail istantanee professionali con la magia dell'intelligenza artificiale: risposte geniali con un solo clic, tono perfetto, padronanza multilingue. Trasforma l'e-mail senza sforzo! ...

???? Automazione di posta elettronica: Fuori sede (disponibile per POP e IMAP)  /  Pianifica l'invio di e-mail  /  CC/BCC automatico in base alle regole durante l'invio di e-mail  /  Inoltro automatico (regole avanzate)   /  Aggiunta automatica di saluto   /  Suddividi automaticamente le email con più destinatari in singoli messaggi ...

📨 gestione e-mail: Richiama facilmente le email  /  Blocca le email truffe per soggetto e altri  /  Elimina email duplicate  /  Ricerca avanzata  /  Consolidare cartelle ...

📁 Allegati Pro: Salvataggio in batch  /  Stacca batch  /  Comprimi in lotti  /  Salvataggio automatico   /  Scollegamento automatico  /  Comprimi automaticamente ...

🌟 Magia dell'interfaccia: 😊Più emoji carini e fantastici   /  Aumenta la tua produttività in Outlook con le visualizzazioni a schede  /  Riduci a icona Outlook invece di chiuderlo ...

👍 Meraviglie con un clic: Rispondi a tutti con gli allegati in arrivo  /   E-mail anti-phishing  /  🕘Mostra il fuso orario del mittente ...

👩🏼‍🤝‍👩🏻 Contatti e calendario: Aggiungi in batch contatti dalle email selezionate  /  Dividere un gruppo di contatti in singoli gruppi  /  Rimuovi promemoria compleanno ...

Al di sopra Caratteristiche 100 Attendi la tua esplorazione! Clicca qui per scoprire di più.

 

 

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