title: Paste Copied Cells into Email Body
body: <p>How can I changed my email body with copy of selection of cells (A1:H59) without loosing their formats. </p>
  
  <p>The below code works good for rest of the email just not the email body part. I just need to include Range A1 to H59 from the <code>Activesheet</code> into the email body.</p>
  
  <pre><code>With obMail
      .To = Range("B14").Value
      .Subject = "Outstanding Balance"
       Range("A1:H59").Select
       Selection.Copy
      .HTMLBody = Selection.PasteSpecial
      .SentOnBehalfOfName = "myemail@company.com"
      .Send
  End With
  </code></pre>