Formatting Text Signature in Mail Template

[dieseldogpi]

Hey everyone, I've been messing with Ron's Outlook Mail Worksheet Template for Excel 2007-2010 in order to mail out some monthly items from excel. I needed to add the company signature which is in rich text format. I don't want the email itself to be in html. When I added the signature code for outlooks .txt signature, it works, but the signature is not formatted correctly (correct font and size). Is there an easy way to format the font and size of the signature after excel pulls the .txt file? Here is the section of the code with the sig attachment:

Please Login or Register  to view this content.

I am probably missing something real easy. I did search and couldn't find anything specific. Thanks again guys.

[dieseldogpi]

OK, if no one has an answer for this, how can I get my signature in the right format to show up in Ron's email template? Should I try to email Ron directly? Thanks again guys.

[Steffen Thomsen]

Hi.

Try the following, save your signatur as .xml
And copy the html coding for the signature.

Then instead of & Signature

add the following:


& .HTMLBody = Your html here

Steffen Thomsen

[dieseldogpi]

That did not help, that actually killed the body of the email, which was designated by a particular cell in excel. Not sure where to go from here, without the signature on the email looking the way it should, I can't use this template....really sucks. I couldn't post the code, toom any characters. Any ideas would be greatly appreciated. Thanks again.

[dieseldogpi]

Any ideas? Any direction will be greatly appreciated. Can I incorporate an html signature into a non-html email? Is there an excel template that can email all html while retaining all the functions of the other one (worksheets as attachments etc.)?