title: Add new lines in VBA email
body: <p>I'm trying to send an email automatically through Excel, but the new line commands aren't working! I've tried <code>&lt;br/&gt;</code>,  <code>vbCrLf</code> and <code>vbNewLine</code></p>
  
  <pre><code>.HTMLbody = "Hello" &amp; vbNewLine &amp; "Please find attached the above invoices and backup" &amp; vbNewLine &amp; _
              "Any queries please let me know" &amp; vbNewLine &amp; "Regards" &amp; vbNewLine &amp; Signature
  </code></pre>
  
  <p>It keeps just giving <code>Hello Please find attached the above invoices and backup Any queries please let me know Regards</code> as one line!</p>