title: Email Signatures with Outlook Formatting
body: <p>Ok, so I have the following code on a button on a form in access.</p>
  
  <pre><code>Private Sub Request_FTP_Click()
  
      Dim olApp As Object
      Dim objMail As Object
  
      On Error Resume Next 'Keep going if there is an error
          Set olApp = GetObject(, "Outlook.Application") 'See if Outlook is open
  
          If Err Then 'Outlook is not open
              Set olApp = CreateObject("Outlook.Application") 'Create a new instance
          End If
  
      Set objMail = olApp.CreateItem(olMailItem)
  
      With objMail
      .display
      End With
      signature = objMail.Body
      With objMail
          .To = "kristian@hebsdigital.com"
          .Cc = ""
          .Subject = "Please create FTP for " + Property_Name.Value
          .Body = "Hi Ilya, " &amp; vbNewLine &amp; vbNewLine &amp; "Could you please create an FTP for " &amp; Property_Name &amp; vbNewLine &amp; vbNewLine &amp; "Thank you," &amp; signature
  
          .send
      End With
  
  End Sub
  </code></pre>
  
  <p>The problem is that I want the signature to be with outlook formatting. (colors, font, etc.) Right now it loads like this:</p>
  
  <pre><code>Name
  Last Name
  HYPERLINK "http://www.hebsdigital.com/"Web • HYPERLINK "http://hebsdigital.com/blog/"Blog  
  </code></pre>
  
  <p>Does anyone have a solution?</p>