View Single Post
  #4  
Old November 7th 06, 08:54 PM posted to microsoft.public.outlook.program_vba
Eric Legault [MVP - Outlook]
external usenet poster
 
Posts: 830
Default standard signature

Yes, that's certainly possible. I can see some code converting the plain
text a user enters into a User Form text box into the appropriate HTML that
conforms to your company's style guidelines, and then using a TextStream
object from the Microsoft Scripting Runtime Library to edit the .htm file in
the user's Signatures folder.

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Melisande" wrote:

hi,

sorry for the late response...

Basically, what it comes down to is that 90% of our users are barely able to
write an e-mail, so we really can forget about them copying and editing an
existing signature.

What'd be really really useful is a macro that would use the information the
user types into a userform, so the user would just have to click the OK
button and the macro would take care of starting the signature-editor,
putting in the right colours and setting this signature for sending and
replying to messages...
is that at all possible???

thanks :-)



"Eric Legault [MVP - Outlook]" wrote:

Do you want to customize the stationery so you have custom formatting for the
entire e-mail, or just the signature part?

I'm assuming you want a template style feature to assist users in creating
your signature. You can create an .htm file as a base template and have
users copy it to their C:\Documents and Settings\users\Application
Data\Microsoft\Signatures and then they can edit it to their liking (either
within the Outlook signature editor or in Notepad or a web page editor). The
file names in that folder correspond to the names of the signatures they have
defined in Outlook.

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Melisande" wrote:

Hi,

Our company wants all of our emailing employees to have the same colours in
their signature. Is there a way to create a form in which the users would
simply fill in their name and other info so that a simple click on the OK
button would create their signature, with all the right colours???

Thanks in advance

Melisande

Ads