title: How to send multiple ranges in the body of an email through Excel?
body: <p>I want to create a macro to generate an email to send out by sending two separate ranges from an xlsm file. I've used Ron De Bruin's code from here :
  <a href="https://msdn.microsoft.com/en-us/library/ff519602(v=office.11).aspx" rel="nofollow noreferrer">https://msdn.microsoft.com/en-us/library/ff519602(v=office.11).aspx</a></p>
  
  <p>Specifically the range to html function and the mail selection range outlook body macro. However, I am very new to Excel vba and programming in general, and so I don't know how to modify this code in order to paste two selections of cells rather than just one. The format I would like for the email is:
  Good morning, </p>
  
  <p>Text 1</p>
  
  <p>Range 1</p>
  
  <p>Text 2</p>
  
  <p>Range 2</p>
  
  <p>Thanks. </p>
  
  <p>Can any of you please help me with this? Thank you. </p>