title: Formatting HTML within VBA
body: <p>I'm currently facing issues with putting HTML into VBA to send an e-mail. The formatting isn't coming out the way I want and I've been playing around with it.</p>
  
  <p>The first part of my question is to get the font size to show up Outlook to what the code states. If the font size is 22, the size is being displayed in Outlook as 16.5 (the first line). </p>
  
  <p>If the font size is supposed to be set to 11, the size is being displayed as 8.5.</p>
  
  <p>I have the following questions for the table: 
  The font is showing up as Times New Roman size 12 instead of Calibri size 11. Also, all of the "Column" and "Top Line" are not aligned to the top. </p>
  
  <p>Is the syntax wrong? </p>
  
  <pre><code>.HTMLBody = "&lt;html&gt;&lt;center&gt;&lt;p style='font-family:calibri;font-size:22'&gt;" &amp; "***&lt;u&gt;TEXT AT TOP&lt;/u&gt; ***" &amp; "&lt;/center&gt;&lt;/p&gt;" &amp; "&lt;br&gt;" &amp; "&lt;br&gt;" &amp; _
          "&lt;p style='font-family:calibri;font-size:11'&gt;" &amp; "Good afternoon," &amp; "&lt;/p&gt;" &amp; "&lt;br&gt;" &amp; _
          "&lt;p style='font-family:calibri;font-size:11'&gt;" &amp; "Attached please find your ... &lt;strong&gt; Please be advised.....&lt;/strong&gt;" &amp; "&lt;/p&gt;" &amp; _
           "&lt;table&gt;&lt;tr&gt;&lt;td style='font-family:Calibri:align = top:font-size:11'&gt;Column 1:&lt;/td&gt;&lt;td style='font-family:Calibri'&gt;Top Line&lt;/td&gt;&lt;/tr&gt;" &amp; "&lt;br&gt;" &amp; _
          "&lt;tr&gt;&lt;td style='font-family:Calibri:align = top:font-size:11'&gt;Column 2&lt;/td&gt;&lt;td style='font-family:Calibri:align = top:font-size:11'&gt;Top Line Row 2 &lt;br&gt; More text&lt;/tr&gt;&lt;/td&gt;" &amp; "&lt;br&gt;" &amp; _
          "&lt;tr&gt;&lt;td&gt;&lt;/td&gt;&lt;td style='font-family:Calibri:align = top:font-size:11'&gt;Top Line Row 3 &lt;br&gt; More text &lt;/tr&gt;&lt;/td&gt;" &amp; "&lt;br&gt;" &amp; _
          "&lt;tr&gt;&lt;td style='font-family:Calibri:align = top:font-size:11'&gt;Column 3&lt;/td&gt;&lt;td style='font-family:Calibri:align = top:font-size:11'&gt;Top Line Row 4:&lt;/tr&gt;&lt;/td&gt;&lt;/table&gt;" &amp; "&lt;br&gt;" &amp; _
          "&lt;p style='font-family:calibri:font-size:11'&gt;" &amp; "Should you have any questions, or require any additional information, please do not hesitate to contact me anytime.  Thank you!" &amp; "&lt;/p&gt;" &amp; "&lt;br&gt;" &amp; _
          "&lt;p style='font-family:calibri:font-size:11'&gt;" &amp; "Best regards," &amp; "&lt;/p&gt;" &amp; _
           "&lt;table&gt;&lt;tr&gt;&lt;td style='font-family:Calibri:font-size:12'&gt;&lt;strong&gt;Size 12 text&lt;/strong&gt; | text &lt;br&gt; text &lt;/tr&gt;&lt;/td&gt;" &amp; _
           "&lt;tr&gt;&lt;td style='font-family:Calibri:font-size:12&gt;&lt;strong&gt;Name&lt;/strong&gt;&lt;/tr&gt;&lt;/td&gt;&lt;table&gt;"                   .Display 
  </code></pre>
  
  <p>Thank you! </p>