title: Send an Outlook email from Excel putting the last row range text in the body message
body: <p>I would like to send an email from my Excel spreadsheet  with a small message into the body containing the last row range from column A to column G.</p>
  
  <p>I've tried to add my last row range to the following code without success. </p>
  
  <p>Can you help? </p>
  
  <pre><code>Sub Mail_LastRowRange_Outlook()
  
  Dim OutApp As Object
  Dim OutMail As Object
  Dim strbody As String
  
  Set OutApp = CreateObject("Outlook.Application")
  Set OutMail = OutApp.CreateItem(0)
  
  strbody = "Thanks for your help" &amp; '**I Would like to insert_
             my last row range from column A to G in here**
  
  On Error Resume Next
  With OutMail
      .To = ""
      .CC = ""
      .BCC = ""
      .Subject = "Looking for a solution"
      .Body = strbody
      .Attachments.Add ("C:\test.txt")
      .Send   
  End With
  On Error GoTo 0
  
  Set OutMail = Nothing
  Set OutApp = Nothing
  End Sub
  </code></pre>