4

Bit surprised I couldn't find this question on SU already. Please point me to it if I've missed it.

How can I display the email address of a sender in my inbox in Outlook 2010?

enter image description here

I've tried right-clicking the column headers and using the field chooser but the 'Email' listed within 'All Contact Fields' gives me blanks.

Rationale: I get emails from various areas within my company that use various domain names for different parts of the business. It would be helpful to quickly distinguish between different 'types' of sender (including external senders as well).

I'm sure there must be a simple way of doing this!


EDIT: It seems this is surprisingly difficult. Thims' useful suggestion of using CFG files gets me half-way to an answer but this only works for external email addresses. Unfortunately, for internal emails, the sender is displayed like this:

/O=XXXXX/OU=EXCHANGE ADMINSTRATIVE GROUP (FYDIBOHF23SPDLT)/CN=RECIPIENTS/CN=A9AE8D41-75001D8E-80257328-52793F

Is there any way I can use a CFG to pull out the primary SMTP address associated with an internal user?

Or some other way?

3 Answers 3

5

See my similar question and answer here: https://stackoverflow.com/questions/43849213/can-i-add-a-custom-email-domain-column-in-outlook/43889643#43889643

Use the formula:

IIf(InStr([SearchFromEmail], "@") = 0, "", Mid([SearchFromEmail], InStr([SearchFromEmail], "@") + 1))
1
  • 1
    Well you wait 3 years and then some legend called Steve turns up and gives you what you've always wanted. Thanks! Exactly what I needed - for my purposes I've tweaked it so that internal email addresses show mydomain.com by default rather than just being left blank: IIf(InStr([SearchFromEmail], "@") = 0, "mydomain.com", Mid([SearchFromEmail], InStr([SearchFromEmail], "@") + 1)). Thanks :)
    – Andi Mohr
    May 10, 2017 at 14:35
1

There is no simple way of doing this. But you can achieve the desired result by using CFG files. A complete guide is available at SlipStick.

1
  • Thanks - this gets me part of the way there... I can see email addresses from external senders. However internal people appear like this: /O=XXXX/OU=EXCHANGE ADMINSTRATIVE GROUP (FYDIBOHF23SPDLT)/CN=RECIPIENTS/CN=A9AE8D41-75001D8E-80257328-52793F
    – Andi Mohr
    Jan 17, 2014 at 13:15
0

Try this: https://www.extendoffice.com/documents/outlook/2190-outlook-view-sender-domain.html

But use this formula instead

IIf(InStr([SearchFromEmail], "@") = 0, "", Left([SearchFromEmail], InStr([SearchFromEmail], "@") - 1)+"@"+Mid([SearchFromEmail],InStr([SearchFromEmail],"@")+1))

It worked for me.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .