Email signature

  • Thread starter Thread starter Chuck M
  • Start date Start date
C

Chuck M

Hi all,

I have code to automate sending emails from Access but I need to know the
code to include my auto signature in the email.

Can someone help?
 
One last e-mail on the subject.

As you can see by looking through various posts there is more than 1
solution/approach.

That said, I did a quick test and the following works.

When you automate Outlook, Display the message prior to specifying the body.
Something ike

With objOutlookMsg
' Add the To recipient(s) to the message.
Set objOutlookRecip = .Recipients.Add(strRecipient)
objOutlookRecip.Type = olTo

' Set the Subject, Body, and Importance of the message.
.Subject = strSubject
.Display
.Body = strBody & vbcrlf & vbcrlf & .Body
....

By displaying the message first it will populate the signature. Then
remember to include the .Body when attributing a value to the .Body. This
will basically add your body content while preserving the signature below it.
 
Back
Top