Ir para o conteúdo principal

 Como sempre mostrar o endereço de e-mail completo na lista de mala direta?

Normalmente, o nome do remetente é exibido na lista de discussão da pasta Caixa de entrada, mas às vezes, você pode querer que o endereço de e-mail completo do remetente seja exibido conforme a captura de tela a seguir. Como você poderia mostrar o endereço de e-mail de um remetente na caixa de entrada do Outlook?

doc mostrar endereço de e-mail 4

Sempre mostrar o endereço de e-mail completo na lista de distribuição do Outlook

Sempre mostrar o endereço de e-mail completo na lista de distribuição do Outlook

As etapas a seguir podem ajudá-lo a exibir o endereço de e-mail do remetente na lista de distribuição do Caixa de entrada pasta, faça o seguinte:

1. Clique Veja > Adicionar Colunas, veja a captura de tela:

doc mostrar endereço de e-mail 1

2. No Mostrar colunas caixa de diálogo, execute as seguintes operações:

(1.) Clique Nova Coluna botão para ir ao Nova Coluna caixa de diálogo;

(2.) No Nova Coluna caixa de diálogo, especifique um nome para esta nova coluna;

(3.) Em seguida, escolha Fórmula do Tipo lista suspensa;

(4.) E, em seguida, cole esta fórmula no Fórmula caixa: IIf (InStr ([SearchFromEmail], "@") = 0, "", Left ([SearchFromEmail], InStr ([SearchFromEmail], "@") - 1) + "@" + Mid ([SearchFromEmail], InStr ( [SearchFromEmail], "@") + 1)).

doc mostrar endereço de e-mail 2

3. Então clique OK para retornar ao Mostrar colunas caixa de diálogo e, a seguir, selecione o novo nome da coluna que você criou e mova-o para o local desejado clicando em Mover para cima botão, neste exemplo, vou movê-lo na frente do Assunto coluna, veja a captura de tela:

doc mostrar endereço de e-mail 3

4. E então, clique OK para fechar esta caixa de diálogo, agora, os endereços de e-mail do remetente serão exibidos na lista de e-mails conforme a seguinte captura de tela:

doc mostrar endereço de e-mail 4

Melhores ferramentas de produtividade de escritório

Kutools for Outlook - Mais de 100 recursos poderosos para turbinar seu Outlook

📧 Automação de e-mail: Fora do escritório (disponível para POP e IMAP)  /  Agendar envio de e-mails  /  CC/BCC automático por regras ao enviar e-mail  /  Encaminhamento automático (regras avançadas)   /  Adicionar saudação automaticamente   /  Divida automaticamente e-mails de vários destinatários em mensagens individuais ...

📨 Gestão de E-mail: Lembre-se facilmente de e-mails  /  Bloquear e-mails fraudulentos por assuntos e outros  /  Apagar Emails Duplicados  /  Pesquisa Avançada  /  Consolidar pastas ...

📁 Anexos Pró: Salvar em lote  /  Desanexar lote  /  Comprimir em Lote  /  Salvamento automático   /  Desanexação Automática  /  Compressão automática ...

???? Interface Mágica: 😊Mais emojis bonitos e legais   /  Aumente a produtividade do seu Outlook com visualizações com guias  /  Minimize o Outlook em vez de fechar ...

???? Maravilhas com um clique: Responder a todos com anexos recebidos  /   E-mails antiphishing  /  🕘Mostrar fuso horário do remetente ...

👩🏼‍🤝‍👩🏻 Contatos e calendário: Adicionar contatos em lote de e-mails selecionados  /  Dividir um grupo de contatos em grupos individuais  /  Remover lembretes de aniversário ...

Sobre Características 100 Aguarde sua exploração! Clique aqui para descobrir mais.

 

 

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