OUTLOOK & VBA

[Joey]

We run Office 2003. We have the co name, reg no, directors, etc listed
in everyone's signature clause. Should a director leave, I have to
amend all the signature clauses and re-insert them at each workstation.
Is there a way that I can have this done automatically via vba in
Outlook or any other suggestions perhaps? Looked at forms but doesn't
think that that will work the way I want it to. It must be part of the
email message.

 

[Sue Mosher [MVP-Outlook]]

VBA is the wrong solution for this. Since the signatures are nothing more than .htm, .rtf, and .txt files stored in the user's Windows profile folders, a login script could either copy the updated signatures to the user's Signatures folder or search and replace text in the signature files.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Joey]

Thanx Sue, will look into this.