View Single Post
  #2  
Old February 8th 08, 07:02 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default company wide signature



This approach should work: Create the signature once in Outlook and use the
files as templates. Outlook stores one file for every format in:

C:\Documents and Settings\[user]\Application Data\Microsoft\Signatures

You can open the files and replace the personal informatioin by
placeholders. Then store the files on a network drive to that every user
will have access.

In Outlook VBA, you could use the Application_Startup event to copy the
files when Outlook starts to the local folder for the signatures and fill
the placeholders with the personal information.

--
Best regards
Michael Bauer - MVP Outlook
Use Outlook Categories? This is Your Tool:
http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6

Am Thu, 7 Feb 2008 16:02:00 -0800 schrieb Chris:

our top management team wants to make a unified company wide signature as

an
option for people to choose, other than what they already have. This
signature will have user's name, title, office address, work phone number,
mobile phone number, fax number. Our HR maintains a SQL database which

has
all these information current. So, I guess the unified signature has to

be a
template. Once used it will pull the information from the database and

fill
it out. Is it possible? If so, how to do it? Also, you have to think the
format for different mail editor, HTML, Rich Text or Text or Word? Can
someone help?

Thanks in advance.

Ads