Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   standard signature (http://www.outlookbanter.com/outlook-vba/31640-standard-signature.html)

Melisande November 1st 06 10:27 AM

standard signature
 
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

Eric Legault [MVP - Outlook] November 1st 06 05:36 PM

standard signature
 
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


Melisande November 7th 06 11:49 AM

standard signature
 
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


Eric Legault [MVP - Outlook] November 7th 06 08:54 PM

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


Melisande November 7th 06 10:36 PM

standard signature
 
sounds good!
could you please explain to me how to do this? I'm quite capable with vba in
word, but have never worked with it in outlook...



"Eric Legault [MVP - Outlook]" wrote:

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



All times are GMT +1. The time now is 12:16 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com