title: Office 2013 - VBA Email does not display To/CC/BCC variables
body: <p>I am creating emails from Excel via the VBA Outlook.Application Reference. Each email is populated with data from my excel sheet and then placed into the To/CC/BCC/Subject/Body fields.</p>
  
  <p>Now, when running this code in Office 2010 it works without a hitch, but in Office 2013 the variables containing the To/CC/BCC/etc. data does not show up in the actual email when displayed.</p>
  
  <p>Did this reference change in Office 2013?</p>
  
  <pre><code>    Sub MailSheet()
  
      Dim OutApp As Object
      Dim outMail As Object
      Dim rng As Range
  
      ' set required variables
      Set Sourcewb = ActiveWorkbook
      Set Property = ActiveWorkbook.Sheets("Settings").Range("B4")
      Set Holidex = ActiveWorkbook.Sheets("Settings").Range("B5")
      Set SendTo = ActiveWorkbook.Sheets("Settings").Range("B29")
      Set SendCC = ActiveWorkbook.Sheets("Settings").Range("B30")
      Set rng = Sheets("Mail").Range("A1:F80")
  
      ' set email variables
      Set OutApp = CreateObject("Outlook.Application")
      Set outMail = OutApp.CreateItem(0)
  
  ' some code
  
          ' get ready to mail
          With outMail
              .To = SendTo
              .ReplyRecipients.Add ""
              .CC = SendCC
              .BCC = ""
              .Subject = Holidex &amp; " - Daily Email"
              .HTMLBody = RangetoHTML(rng)
  
              ' display email before sending
              .Display   '.Send or use .Display
          End With
  
  ' some code
  
      ' Clean up
      Set outMail = Nothing
      Set OutApp = Nothing
  
  end Sub
  </code></pre>