Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Set up Signatures, Font & Size Programmatically (http://www.outlookbanter.com/outlook-vba/36328-set-up-signatures-font-size.html)

JohnUK December 28th 06 10:52 AM

Set up Signatures, Font & Size Programmatically
 
Hi.
Having some basic programming skills (Mainly Excel) I need some help with a
new project my boss has put me on.
20 of our staff need to have their laptops configured with Signatures, Font
and size set up so that they are all in uniform.
I have managed to do the Setup of Signatures so that a word document can be
saved into the Signatures Folder (as an HTML document) ready for importing
into outlook. The problem I now have is, I need code to then draw the HTML
doc into Outlook, set up the Font and Size.
I tried simple macro recording with no success.
Can anyone help or at least set me up.
Many thanks
John


Ken Slovak - [MVP - Outlook] December 28th 06 03:41 PM

Set up Signatures, Font & Size Programmatically
 
There is no macro recorder in Outlook.

All you can do is set up the formatting using correct HTML syntax and save
the signature file. You also need to create equivalent files for plain text
and Rich Text formats. The appropriate signature will be loaded based on the
email format.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"JohnUK" wrote in message
...
Hi.
Having some basic programming skills (Mainly Excel) I need some help with
a
new project my boss has put me on.
20 of our staff need to have their laptops configured with Signatures,
Font
and size set up so that they are all in uniform.
I have managed to do the Setup of Signatures so that a word document can
be
saved into the Signatures Folder (as an HTML document) ready for importing
into outlook. The problem I now have is, I need code to then draw the HTML
doc into Outlook, set up the Font and Size.
I tried simple macro recording with no success.
Can anyone help or at least set me up.
Many thanks
John



JohnUK December 28th 06 04:34 PM

Set up Signatures, Font & Size Programmatically
 
Many thanks Ken.

"Ken Slovak - [MVP - Outlook]" wrote:

There is no macro recorder in Outlook.

All you can do is set up the formatting using correct HTML syntax and save
the signature file. You also need to create equivalent files for plain text
and Rich Text formats. The appropriate signature will be loaded based on the
email format.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"JohnUK" wrote in message
...
Hi.
Having some basic programming skills (Mainly Excel) I need some help with
a
new project my boss has put me on.
20 of our staff need to have their laptops configured with Signatures,
Font
and size set up so that they are all in uniform.
I have managed to do the Setup of Signatures so that a word document can
be
saved into the Signatures Folder (as an HTML document) ready for importing
into outlook. The problem I now have is, I need code to then draw the HTML
doc into Outlook, set up the Font and Size.
I tried simple macro recording with no success.
Can anyone help or at least set me up.
Many thanks
John




Sue Mosher [MVP-Outlook] December 30th 06 04:13 PM

Set up Signatures, Font & Size Programmatically
 
As an alternative to what Ken suggests, you can use Word objects to set up the signature. See http://groups.google.com/group/micro...c02df6e6bd3912

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"JohnUK" wrote in message ...
Many thanks Ken.

"Ken Slovak - [MVP - Outlook]" wrote:

There is no macro recorder in Outlook.

All you can do is set up the formatting using correct HTML syntax and save
the signature file. You also need to create equivalent files for plain text
and Rich Text formats. The appropriate signature will be loaded based on the
email format.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"JohnUK" wrote in message
...
Hi.
Having some basic programming skills (Mainly Excel) I need some help with
a
new project my boss has put me on.
20 of our staff need to have their laptops configured with Signatures,
Font
and size set up so that they are all in uniform.
I have managed to do the Setup of Signatures so that a word document can
be
saved into the Signatures Folder (as an HTML document) ready for importing
into outlook. The problem I now have is, I need code to then draw the HTML
doc into Outlook, set up the Font and Size.
I tried simple macro recording with no success.
Can anyone help or at least set me up.
Many thanks
John





All times are GMT +1. The time now is 09:28 AM.

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