title: How can I convert a range to a string (VBA)?
body: <p>What is the best way to convert a range of cells to a string?
  I have a function that only takes a string as input so I need to convert the range to a string, while retaining as much of the formatting as possible (i.e. it needs to look like a table or list, not just a string of characters).
  I've tried working with CStr(), as well as converting from a range to an array and then to a string, but I just get errors.</p>
  
  <p>Edit: Code attempt</p>
  
  <pre><code>Dim email_answer As Integer
  email_answer = MsgBox("Do you want to be emailled a copy of this schedule?", vbYesNo)
  If email_answer = vbYes Then
  
      Dim wb As Workbook
      Dim to_send As Range
      to_send = Range("D3", "D10")
  
      If Val(Application.Version) &lt; 14 Then Exit Sub
  
      Set wb = ActiveWorkbook
      With wb
          MailFromMacWithMail body content:=CStr(to_send), _
                      mailsubject:="Schedule", _
                      toaddress:="email address", _
                      ccaddress:="", _
                      bccaddress:="", _
                      attachment:=.FullName, _
                      displaymail:=False
      End With
      Set wb = Nothing
  End If
  </code></pre>