Note: The other languages of the website are Google-translated. Back to English
Logga in  \/ 
x
or
x
Registrera  \/ 
x

or

Hur visar avsändarens domän i e-postlistan i Outlook?

Har du till och med fått några e-postmeddelanden från konstiga avsändare i Outlook med bara att visa avsändarnas namn i e-postlistan? Se följande skärmdump. Vissa Outlook-användare kanske tror att det blir säkrare att få avsändarnas e-postdomän innan de öppnar sina e-postmeddelanden. I den här artikeln visar jag dig hur du visar eller visar avsändarnas e-postdomäner i e-postlistan i Microsoft Outlook.

Fliken Office - Aktivera redigering och surfning på flikar i Office, och gör arbetet mycket enklare ...
Kutools for Outlook - ger 100 kraftfulla avancerade funktioner till Microsoft Outlook
  • Auto CC / BCC enligt regler när du skickar e-post; Automatisk vidarebefordran Flera e-postmeddelanden efter regler; Auto-svar utan växelserver och mer automatiska funktioner ...
  • BCC-varning - visa meddelande när du försöker svara alla om din e-postadress finns i BCC-listan; Påminn när du saknar bilagor, och mer påminna om funktioner ...
  • Svara (alla) med alla bilagor i e-postkonversationen; Svara många e-postmeddelanden på en gång; Lägg automatiskt till hälsning när svar Lägg automatiskt till datum och tid i ämne ...
  • Tillbehörsverktyg: Auto Lossa, Komprimera alla, Byt namn på alla, Spara alla automatiskt ... Snabbrapport, Räkna utvalda e-postmeddelanden, Ta bort duplicerade e-postmeddelanden och kontakter ...
  • Mer än 100 avancerade funktioner kommer lösa de flesta av dina problem i Outlook 2010-2019 och 365. Fullständiga funktioner 60-dagars gratis provperiod.

Om du vill visa eller visa avsändarnas e-postdomäner i e-postlistan i Microsoft Outlook kan du följa dessa sätt för att få den.

Steg 1: Öppna e-postmappen där du visar eller visar avsändarnas e-postdomäner.

Steg 2: Klicka på Lägg kolumner knappen på utsikt fliken.

Anmärkningar: I Outlook 2007 kan du klicka på utsikt > Nuvarande åsikt > Anpassa aktuell vy, och klicka sedan på Fält -knappen i popup-fönstret Anpassa vy: Kompakt dialogruta.

Steg 3: Klicka i dialogrutan Visa kolumner (eller Visa fält) Ny kolumn knapp (eller Nytt fält knapp).

Steg 3: Nu kommer du in i dialogrutan Ny kolumn (eller nytt fält) och:

(1) I Namn rutan, ange ett nytt namn för denna skapande kolumn.

(2) Klicka på Typ och välj Formel från rullgardinslistan.

(3) Klicka på Redigera och ange sedan följande text i Formel dialogruta. Se skärmdump nedan:

höger ([SearchFromEmail], len ([SearchFromEmail]) - InStr (1, [SearchFromEmail], "@"))

(4) Klicka på båda OK för att stänga två dialogrutor.

Steg 4: Nu kommer du tillbaka till dialogrutan Visa kolumner (eller Visa fält), välj den nyskapade kolumnen i Visa dessa kolumner i den här ordningen och flytta den nedan Från. Se skärmdump nedan:

Steg 5: Klicka på OK knapp (er).

Nu kommer du att se varje avsändares e-postdomän läggs till och visas under avsändarens visningsnamn. Se följande skärmdump:

Klicka på för att få en metod för att spara den här anpassade vyn i Outlook Hur sparar jag och kopierar visningsinställningar till andra mappar i Outlook?


pil blå höger bubblaRelaterad artikel

Hur sorterar och grupperar man efter avsändardomän i Outlook?


Kutools for Outlook - ger 100 avancerade funktioner till Outlook och gör arbetet mycket enklare!

  • Auto CC / BCC enligt regler när du skickar e-post; Automatisk vidarebefordran Flera e-postmeddelanden efter anpassning; Auto-svar utan växelserver och mer automatiska funktioner ...
  • BCC-varning - visa meddelande när du försöker svara på alla om din e-postadress finns i BCC-listan; Påminn när du saknar bilagor, och mer påminna om funktioner ...
  • Svara (alla) med alla bilagor i e-postkonversationen; Svara många e-postmeddelanden inom sekunder; Lägg automatiskt till hälsning när svar Lägg till datum i ämnet ...
  • Bilagverktyg: Hantera alla bilagor i alla e-postmeddelanden, Auto Lossa, Komprimera alla, Byt namn på alla, Spara alla ... Snabbrapport, Räkna valda mejl...
  • Kraftfulla skräppost efter anpassning; Ta bort duplicerade e-postmeddelanden och kontakter... Gör det möjligt för dig att göra smartare, snabbare och bättre i Outlook.
shot kutools outlook kutools flik 1180x121
shot kutools outlook kutools plus flik 1180x121
 
Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    IanHolly · 1 years ago
    I agree with Matt. The string from themoonandthelily, "right(([SearchFromEmail],[SearchFromEmail]),InStr(1,[SearchFromEmail],"@"))", causes Outlook to crash, closing it immediately when selecting an email.

    Too bad, because it was a very welcome addition.
  • To post as a guest, your comment is unpublished.
    Tim · 1 years ago
    Why does SearchToEmail not work? All the solutions are for the From column only.
  • To post as a guest, your comment is unpublished.
    Matt · 2 years ago
    I really loved this solution. However, my outlook keeps on crashing with the addition of this new column. I spent hours on with Microsoft tech support and they said to delete this column and that it seems to be an issue with Outlook. Really would love another solution to put senders address into the message preview. Disappointed that Microsoft support couldn't offer me any solutions to the crashing except for running Outlook in "cleanviews" :(
  • To post as a guest, your comment is unpublished.
    Net_Master · 2 years ago
    Anyone can provide a formula edit which show sender's domain or e-mail address, BUT from headers of e-mail - from Received: field. That would be useful for determine if the e-mail is spoofed or it's real!
    • To post as a guest, your comment is unpublished.
      Ricardo · 2 years ago
      Yes this is what I would prefer as well. Have you come across something like this yet?
  • To post as a guest, your comment is unpublished.
    corvety@gmail.com · 3 years ago
    Muy bueno..Thanks :)
  • To post as a guest, your comment is unpublished.
    mark · 3 years ago
    Is there anyway this can be deployed using group policy or via registry changes ?
  • To post as a guest, your comment is unpublished.
    AHalfwood · 3 years ago
    Brilliant! SOOO easy. These days it is so easy to 'mask' your email from others and send junk... This stops you opening and saves heaps of time and worry. Why Microsoft doesn't have this column is beyond me. Thanks for this, it is very helpful.
  • To post as a guest, your comment is unpublished.
    themoonandthelily · 3 years ago
    To view the full email address, do the same steps as above, but change formula to:

    right(([SearchFromEmail],[SearchFromEmail]),InStr(1,[SearchFromEmail],"@"))
    • To post as a guest, your comment is unpublished.
      Dru · 2 years ago
      Thanks so much!
  • To post as a guest, your comment is unpublished.
    Kajal · 3 years ago
    So helpful, Much Thankyou to the uploader
  • To post as a guest, your comment is unpublished.
    Lubomir · 3 years ago
    Nice idea and work! Thank you :-)
  • To post as a guest, your comment is unpublished.
    Nicholas · 3 years ago
    Thank you so much! This has saved me as I wanted the full email address and not just the domain.

    Next though, how do I do this for the Sent Items? I can only see the names of the people and I need to see their full email addresses as a column.
    • To post as a guest, your comment is unpublished.
      Steven · 3 years ago
      I have the same question. I tried changing the field to "SearchToEmail", but that didn't work :).
      • To post as a guest, your comment is unpublished.
        Laxman · 3 years ago
        Please reply on this how to get domain name of sent items.
  • To post as a guest, your comment is unpublished.
    Graham Gibby · 4 years ago
    How would I modify the formula to show the full sending address?
    • To post as a guest, your comment is unpublished.
      dave · 3 years ago
      delete everything after the (-) symbol and replace it with a closing parentheses.
      • To post as a guest, your comment is unpublished.
        Ceece · 3 years ago
        This works perfectly EXCEPT MSO will not allow SORTing on this field. How to 'make it so'?
  • To post as a guest, your comment is unpublished.
    Steve · 4 years ago
    Try this improved forumla to elimate the problem with internal exchange addresses:
    IIf(InStr([SearchFromEmail], "@") = 0, "", Mid([SearchFromEmail], InStr([SearchFromEmail], "@") + 1))
    • To post as a guest, your comment is unpublished.
      Ceece · 3 years ago
      See the instruction from 'dave' above regarding showing the full sending address. Can you modify your instruction to include this feature? Please and thank you.
      • To post as a guest, your comment is unpublished.
        Chris Carpenter · 3 years ago
        To show the full email address from external senders while leaving internal users blank:
        IIf(InStr([SearchFromEmail], "@") = 0, "", right([SearchFromEmail],len([SearchFromEmail])))
        • To post as a guest, your comment is unpublished.
          Christian · 1 years ago
          this formula works great, do you know one to for the receiving email?

        • To post as a guest, your comment is unpublished.
          René Thor · 2 years ago
          Thank you! I tried to find a way to show the first receiving mailserver (name/ip). In some cases the mail is sent over open relays and the FromEmail looks safe, but the sending server is not trustable.