Hi I am trying to include in the VB code also the signature :
Here is my code:
Code:
Private Sub Create_Outlook_email()
Const ForReading = 1, ForWriting = 2, ForAppending = 3
Dim db As DAO.Database
Dim fs, f
Dim RTFBody, strTo
Dim objOutlookRecip As Outlook.RECIPIENT
Dim MyOutlook As Outlook.Application
Dim MyItem As Outlook.MailItem
Dim SigString As String
Dim Signature As String
Set MyOutlook = CreateObject("Outlook.Application")
Set MyItem = MyOutlook.CreateItem(olMailItem)
With MyItem
.To = tmpCustEmail
.SUBJECT = "Hello Dear customer "
.HTMLBody = RTFBody & vbCrLf & vbCrLf & Signature
End With
MyItem.Display
but my signature does not appear
It is saved as a default.htm
and I am working on a multiuser platform.
Anybody has overcomed this issue?
Any help?
Thanks