Wanted: VBA Script to use for Outlook signatures

I would include the template on a sheet in the workbook instead of a word document. Then you can use a function to convert the sheet to HTML and use it as the body of the email.

If you're talking about a Network group policy then it will depend on your schema but I would have to guess not without involving your server group.

So here's what I have (this is the "format" that they want to use. The top image has the embdedded url in it


2n22ooz.png

Then I have a separate excel spreadsheet with the information that is needed to fill in the information in the format above. The manager wants a script for everyone in the excel spreadsheet so all they have to do is click the vbs and it will insert the format for them.

ie: name John smith email J.smith@xx.com Address: 123 s 123 st,

I apologize about mentioning the policy (it was already suggested and not an option) wanted to clear that up before someone else mentioned it.


Thanks in advance

Hi JDLM

You don't really describe what you wish to do but from your Thread Title, here's a link to generic Code to insert an Outlook Signature into an Excel generated Outlook Email

http://www.rondebruin.nl/win/s1/outlook/signature.htm