title: Adding TAB to the beginning of a text string in Excel VBA
body: <p>I've assembled the following code that creates the following text in the body of an Outlook email when run.</p>
  
  <pre><code>Sub InitialEvaluationWalkThru()
      Dim OutApp As Object
      Dim OutMail As Object
      Dim strto As String, strcc As String, strbcc As String
      Dim strsub As String, strbody As String
  
      Set OutApp = CreateObject("Outlook.Application")
      Set OutMail = OutApp.CreateItem(0)
  
      strto = "first.last@me.com"
      strcc = ""
      strbcc = ""
      strsub = [$C$8] &amp; " Update"
      strbody = "&lt;H5&gt;Hello Everyone,&lt;/H5&gt;" &amp; _
                "&lt;H5&gt;The Template conference rooms " &amp; Cells(FormulaCell.Row, "C").Value &amp; " phase is now complete!&lt;/H5&gt;" &amp; _
                "&lt;H4&gt;The overall room deployment is " &amp; [$E$8] &amp; "% Complete!&lt;/H4&gt;" &amp; _
                "&lt;H5&gt;Let me know if you have any questions,&lt;/H5&gt;"
  
      With OutMail
          .Display
          .To = strto
          .CC = strcc
          .BCC = strbcc
          .Subject = strsub
          ' .Body = strbody
          .HTMLBody = strbody &amp; .HTMLBody
          'You can add a file to the mail like this
          '.Attachments.Add ("C:\test.txt")
          .Send 'or use .Send
      End With
  
      Set OutMail = Nothing
      Set OutApp = Nothing
  End Sub
  </code></pre>
  
  <p><strong>Outlook Email</strong></p>
  
  <blockquote>
    <p>Hello Everyone,</p>
    
    <p>The Template conference rooms Initial Evaluation Walk-Thru phase is
    now complete!</p>
    
    <p>The overall room deployment is 0.125% Complete!</p>
    
    <p>Let me know if you have any questions,</p>
  </blockquote>
  
  <p><strong>Question</strong></p>
  
  <p>I am trying to indent the third line and have tried many different combos with no luck. I've also tried to have the cell value percentage from my sheet as 13% not 0.125%, also with no luck.</p>
  
  <p>Any help would be greatly appreciated.</p>
  
  <p>Thank You</p>