Email using Excel VBA and Keeping Outlook Signature on the Email

[Shama]

I'm creating an excel file that can email itself inside the body of a HTML in Outlook.

I have found some code from the web and have re-fitted it so that I may use it for my purpose.

My main issue is this: I cannot keep my default Outlook signature on the email when it gets sent.

How can I achieve this?

Please Login or Register  to view this content.

Many thanks~



Shama
090205

[broro183]

hi Sharma,

You may find some useful code on Ron's site:
http://www.rondebruin.nl/sendmail.htm
esp this page:
http://www.rondebruin.nl/mail/folder3/signature.htm

hth
Rob

[Shama]

Thanks, but I don't know how I can apply that code into the current one that I use.

[Shama]

Oops.
Nevermind, I just forgot to uncheck the "Use MS Word to edit e-mail messages" in Outllook's Tools --> Options