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