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.

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

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 [email protected] 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