Add Signature to email with VBA code

**slmi1313** · 03-07-2012, 10:30 AM

Hope someone can help. I use the below code to email through outlook using VBA.

Please Login or Register  to view this content.

I want to add a signature with Ron de Bruins code below, but I cant seem to get it to work

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Can someone let me know where and how I need to place the above code in my code to get the signature to work?

**jaslake** · 03-10-2012, 05:32 PM

Hi slmi1313

Please Login or Register  to view this content.

If your using XP it can be found in C:\Documents and Settings\(your username)\Application Data\Microsoft\Signatures

Click on My Computer
Click on Local Disk C (or whatever your Local Drive Letter is)
Click on Documents and Settings
Click on your User Name (in my case, it's Administrator...your's is what it is)
Click on Application Data
Click on Microsoft
Click on Signatures
Find your signature name
Replace Mysig.htm with your signature name.

Should work...used this same code numerous times.