VBA excel to outlook but keep default signature

[Gazmoz147]

Hi,

I've read up and sampled a few scripts but struggling. Want the below script to pop up as new email including default signature.




Many Thanks
Gareth

[TMS]

See Ron de Bruin's site: https://www.rondebruin.nl/win/s1/outlook/signature.htm

[ByteMarks]

You can use the default signature if you use htmlBody
Put .display first which presents a blank email that includes the signature only.
Assign that to the variable Signature
Then append that to sBody which is the text of the email formatted as html.

Note that you need to replace + with < in the red line. Had to change to be able to post.

Please Login or Register  to view this content.

Pretty much Ron De Bruin's method except that I've found ".HTMLBody = strbody & "<br>" & .HTMLBody" doesn't always work.

[Gazmoz147]

Hi,

Thought i had replied to this yesterday thanking you guys...but obvs its not posted. Thanks for your help it works great .



Many Thanks
Gareth

[Gazmoz147]

Hi,

The only prob now is the sent from is no longer working its gone back to my default email address for some reason?

Thanks
Gareth

[ByteMarks]

Hi,
Please put the SentOnBehalfOfName line before the Display.

[Gazmoz147]

Argh cool I put it before the TO line

Thanks