title: Adding hyperlinks to excel email body text
body: <p>I am trying to generate emails from excel but want to add hyperlinks to the email body text. I want the hyperlinks to show as text and not the file paths. </p>
  
  <p>How would I go about doing this?</p>
  
  <p>I am using the below code. </p>
  
  <pre><code>    strBody = "Hello " &amp; Range("QuoteFirstName").Value &amp; "," &amp; _
         vbNewLine &amp; _
         vbNewLine &amp; _
             "It was good to speak with you earlier today/yesterday." &amp; _
         vbNewLine &amp; _
         vbNewLine &amp; _
             "[Any personal message]" &amp; _
         vbNewLine &amp; _
         vbNewLine
  
  
  On Error Resume Next
  With OutMail
      .To = StrTo
      .CC = ""
      .BCC = ""
      .Subject = StrSubject
      .Body = StrBody
      .Attachments.Add FileNamePDF
      If Send = True Then
          .Send
      Else
          .Display
      End If
  End With
  </code></pre>
  
  <p>Can I use <code>.Hyperlinks.Add</code>?</p>