company wide signature

Chris · Joined: 12 Aug 2007 Posts: 18

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.

Archived from group: microsoft>public>outlook>program_vba

Michael Bauer [MVP - Outl · Joined: 12 Aug 2007 Posts: 92

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:

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.

Adding af signature file at the end of the body text Hi I tried to put in the signature after I have made a mailtext in VBA , but the text is replaced by the signature the code is like this v=" Myletter text" With OutMail .to = "yyy@xxx.com" .CC = "" .BCC = "" .Subject = "Subject text" .body = v & Chr(13)

Outlook 2007 Custom Form hell.... keeps going really wide? We just upgraded to office 2007, our custom form, which replaces the standard email one, and ads a text box to enter in a project number for filing, then does some vb work to modify the category of the email etc, seemed to work fine. However we can't forw

GROUP BY COMPANY? I would like to Group contacts by Company, but use the Address Card or Business Card views as opposed to the List form that is allowed. Is this possible?? OR, similar to in BCM I would like to be able to use a grouped contact. I assume tha

Why is the Company field blank? In Outlook 2007 and in All Contact Items window. I then do a search for a contact name or a company name. The results do appear but the column "Company" does not have any content despite this field being filled in each contact. Is this a known bug? Is

geting a report to include company How do i get a report to include the company instead of the name first.