View the BCC Addresses in an Outlook.com EAS Account

Last reviewed on September 5, 2014

Due to a bug, Outlook 2013 doesn't currently show the addresses in the BCC field in an Outlook.com (EAS) email account. The addresses are visible in Outlook.com, but not in Outlook and until this bug is fixed, you have a couple of options: log into Outlook.com to view the BCC recipients or view the BCC addresses by opening the message and looking at the Internet Header in the File, Properties dialog. (You can save a step by adding the Message Properties command the ribbon. It's under All Commands when you customize the ribbon.)

BCC addresses in the properties dialog

To make it easier to see the just recipients, use a macro to display the BCC addresses in a message box. Create a button on the ribbon to run the macro, then select a message and click the button to display a message box containing the BCC addresses.

Show BCC Addresses

If you need a copy of the BCC'd recipients, click on the message box and press Ctrl+C to copy.

Sub ViewBCCAddresses()
    Const PR_TRANSPORT_MESSAGE_HEADERS = "http://schemas.microsoft.com/mapi/proptag/0x007D001E"
    Dim olMail As Outlook.MailItem
    Dim Reg1 As Object
    Dim M1 As Object
    Dim M As Object
    Dim strHeader As String
    Dim strBCC As String
  
    Dim olkPA As Outlook.PropertyAccessor

    On Error Resume Next
    Set olMail = Application.ActiveExplorer.Selection.Item(1)
    Set olkPA = olMail.PropertyAccessor

    strHeader = olkPA.GetProperty(PR_TRANSPORT_MESSAGE_HEADERS)
     Debug.Print strHeader
     
   Set Reg1 = CreateObject("VBScript.RegExp")

    With Reg1
        .Pattern = "(BCC[:]\s(.*)\n)"
       .Global = False
    End With

    If Reg1.test(strHeader) Then
     
        Set M1 = Reg1.Execute(strHeader)
        For Each M In M1
             strBCC = M.SubMatches(1)
             
          MsgBox strBCC
            
        Next
    End If
         
     Set M = Nothing
     Set M1 = Nothing
     Set Reg1 = Nothing
    Set olMail = Nothing
End Sub

How to use the macro

First: You will need macro security set to low during testing.

To check your macro security in Outlook 2013, go to File, Options, Trust Center and open Trust Center Settings, and change the Macro Settings.

After you test the macro and see that it works, you can either leave macro security set to low or sign the macro.

Open the VBA Editor by pressing Alt+F11 on your keyboard.

To put the code in a module:

  1. Right click on Project1 and choose Insert > Module
  2. Copy and paste the macro into the new module.
  3. Go to File, Options, Customize Ribbon
  4. On the right, select Home then click New Group
  5. Select Macros from the Choose Commands From dropdown
  6. Select the ViewBCCAddresses and click Add to add it to the group.
  7. Click Rename to give the button a friendly name and select and icon.

More information as well as screenshots are at How to use the VBA Editor

Written by

Diane Poremsky
A Microsoft Outlook Most Valuable Professional (MVP) since 1999, Diane is the author of several books, including Outlook 2013 Absolute Beginners Book. She also created video training CDs and online training classes for Microsoft Outlook. You can find her helping people online in Outlook Forums as well as in the Microsoft Answers and TechNet forums.

Please post long or more complicated questions at Outlookforums.

Leave a Reply

If the Post Coment button disappears, press your Tab key.