Hi,

I have written a lot of VBA code in Excel and make use of Office Automation
to create and send mails from Excel (Excel & Outlook 2003). All is working
fine, except from 2 things that I would like to improve.

- How can I change the font of the mail body with VBA?
- How can I include a signature to the body with VBA?

Pretty sure that this must be possible. I would be grateful if someone could
help me on this.

Wkr,

JP

1) That's possible if the email is in html format. Look for an html help,
which explains how to change font size, name, etc. You can use either html
tags for that or css.

2) By default, all the signature files are stored he
C:\Documents and Settings\[user]\Application Data\Microsoft\Signatures

You can read a file, for instance with the Scripting Library (add a
reference to it via Tools/References), and insert the stuff it into the
email.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Sun, 18 Oct 2009 16:08:38 +0200 schrieb JP Ronse:

Hi,

I have written a lot of VBA code in Excel and make use of Office
Automation
to create and send mails from Excel (Excel & Outlook 2003). All is working
fine, except from 2 things that I would like to improve.

- How can I change the font of the mail body with VBA?
- How can I include a signature to the body with VBA?

Pretty sure that this must be possible. I would be grateful if someone
could
help me on this.

Wkr,

JP

Hi Michael,

Thanks for the reply, I'll give it a try.

Wkr,

JP


"Michael Bauer [MVP - Outlook]" wrote in message
...


1) That's possible if the email is in html format. Look for an html help,
which explains how to change font size, name, etc. You can use either html
tags for that or css.

2) By default, all the signature files are stored he
C:\Documents and Settings\[user]\Application Data\Microsoft\Signatures

You can read a file, for instance with the Scripting Library (add a
reference to it via Tools/References), and insert the stuff it into the
email.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Sun, 18 Oct 2009 16:08:38 +0200 schrieb JP Ronse:

Hi,

I have written a lot of VBA code in Excel and make use of Office
Automation
to create and send mails from Excel (Excel & Outlook 2003). All is
working
fine, except from 2 things that I would like to improve.

- How can I change the font of the mail body with VBA?
- How can I include a signature to the body with VBA?

Pretty sure that this must be possible. I would be grateful if someone
could
help me on this.

Wkr,

JP