A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

standard signature



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old November 1st 06, 10:27 AM posted to microsoft.public.outlook.program_vba
Melisande
external usenet poster
 
Posts: 3
Default 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
Ads
  #2  
Old November 1st 06, 05:36 PM posted to microsoft.public.outlook.program_vba
Eric Legault [MVP - Outlook]
external usenet poster
 
Posts: 830
Default 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

  #3  
Old November 7th 06, 11:49 AM posted to microsoft.public.outlook.program_vba
Melisande
external usenet poster
 
Posts: 3
Default 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

  #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

  #5  
Old November 7th 06, 10:36 PM posted to microsoft.public.outlook.program_vba
Melisande
external usenet poster
 
Posts: 3
Default 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

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SP3 for Office Xp Standard grooth Outlook - Installation 0 August 7th 06 04:45 PM
Just so you know!! Those that don't have all Standard Forms... [email protected] Outlook - Using Forms 0 July 20th 06 10:01 PM
Standard reply Myint Su Outlook and VBA 1 June 20th 06 06:23 AM
Renaming standard Views glen Outlook - Calandaring 1 February 16th 06 08:08 PM
Reverting To Standard Forms Jonathan Wareham Outlook - Using Forms 0 February 8th 06 10:30 AM


All times are GMT +1. The time now is 03:34 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-2025 Outlook Banter.
The comments are property of their posters.