Hi,
I was doing some research how to send an automatic email from vba, but when I try to use the signature the format just goes bad, my name which supposedly is in Bold format goes to a standard format, the things I had smaller also go to the same format and my email goes HYPERLINK "mailto:dtrickster@hotmail.com"dtrickster@hotmail.com, is it possible that modifying the code can make the signature right??
I'll put it down so you can look at it
Dim OApp As Object, OMail As Object, signature As String
Set OApp = CreateObject("Outlook.Application")
Set OMail = OApp.CreateItem(0)
With OMail
.Display
End With
signature = OMail.body
With OMail
.to = N9 & N10 & N11 & N12 & N13 & N14 & N15 & N16
.CC = N17
.Subject = "FX Receipt"
.body = "Dear " & Contact _
& "" & vbCr & "Thank you" _
& vbNewLine & signature
.Attachments.Add ("V:\Receipt\Backup\" & n & ".pdf")
End With
Set OMail = Nothing
Set OApp = Nothing
Bookmarks