Email signature

[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?

 

[Daniel Pineault]

Take a look at

http://groups.google.ca/group/micro...read/thread/ce841cf30c0f8cfe/32f4f77b13097d0f

 

[Daniel Pineault]

Here another one worth readin
http://groups.google.ca/group/micro...read/thread/a9c89bd2f337e591/d6ee96fc1ae340a1

 

[Daniel Pineault]

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.

 

[Chuck M]

Daniel,

Thanks for all the info. This is just what I needed!

Happy Holidays.