locked
Outlook 2016 Add a column to display whether specific address is in TO, CC, BCC RRS feed

  • Question

  • Good afternoon,

    I'm typically in all the Excel forums and I'm well-versed there, but today brings an Outlook question.

    I am trying to create a column in my Outlook 2016 email list that displays YES or NO depending on whether a particular email address is within the TO, CC, or BCC fields of any given email in the list. This would be added to the main list view in Outlook and would display either a color and/or the words "Yes" or "No", or TRUE/FALSE, whatever I can get I'll take it.

    Ideally I can also sort and filter this field as well.

    Any suggestions? I am familiar with VBA in Excel, have written a few lines there but not much in Outlook. Willing to explore.

    Thanks,

    Michael R

    Monday, February 4, 2019 6:41 PM

Answers

  • Hi Michael,

    It is not feasible to add a single column in message list to display whether a certain email address is in the To, CC or BCC field. 

    But we can add columns separately for the three fields via View > Change View > Manage Views > Compact > Modify > Columns:

    Then you may use the conditional formatting to highlight the messages with the particular email address in the To, CC or BCC field:

    Hope this can be helpful.

    Regards,

    Yuki Sun


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    • Marked as answer by mikey38654 Tuesday, February 5, 2019 6:49 PM
    Tuesday, February 5, 2019 8:47 AM

All replies

  • Hi Michael,

    It is not feasible to add a single column in message list to display whether a certain email address is in the To, CC or BCC field. 

    But we can add columns separately for the three fields via View > Change View > Manage Views > Compact > Modify > Columns:

    Then you may use the conditional formatting to highlight the messages with the particular email address in the To, CC or BCC field:

    Hope this can be helpful.

    Regards,

    Yuki Sun


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    • Marked as answer by mikey38654 Tuesday, February 5, 2019 6:49 PM
    Tuesday, February 5, 2019 8:47 AM
  • This seems a reasonable solution for the challenge I'm facing. Thank you for responding, and quickly at that!
    Tuesday, February 5, 2019 6:51 PM
  • This seems a reasonable solution for the challenge I'm facing. Thank you for responding, and quickly at that!

    You're welcome :) 

    Regards,

    Yuki Sun


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Wednesday, February 6, 2019 1:58 AM