Font setting of mail

Status
Not open for further replies.
J

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
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
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 here:

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

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
 
J

JP Ronse

Hi Michael,

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

Wkr,

JP

"Michael Bauer " <mb@mvps.org> wrote in message

news:na3tagt977jg$.5v26yue70ms0$.dlg@40tude.net...

> 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 here:
> 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

> >

> 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
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
R Setting font and color used when replying to an email Outlook VBA and Custom Forms 3
O Outlook - How to embed font ? (If at all possible) Using Outlook 2
P default font when sending email from browser Using Outlook 1
e_a_g_l_e_p_i Adjusting font size in folders Using Outlook 1
S New Outlook Appointment - Select All Body Text and Change Font and Size Outlook VBA and Custom Forms 1
K Font Sizing in Custom Form Regions for Contacts Outlook VBA and Custom Forms 1
N Help creating a VBA macro with conditional formatting to change the font color of all external emails to red Outlook VBA and Custom Forms 5
P Changing the font that the task view shows Using Outlook 5
S Customize the autocolor font choices for replying/forwarding messages Outlook VBA and Custom Forms 2
e_a_g_l_e_p_i Outlook 2010 How can I change the font size on right side appointment pane Using Outlook 12
B Change Font and Font size using VBA Outlook VBA and Custom Forms 9
T Outlook Contacts ... Changing Font Size, Style, Bold, etc. Using Outlook 2
F Default font for notes in contacts Using Outlook 1
Marc2019 Outlook 2016 Font Problem Using Outlook 5
S Outlook 2010 unable to change default font Using Outlook 7
M Message list font changed after update Using Outlook 2
P Message List Font Changed Using Outlook 6
B Change font of reminder of an email header Outlook VBA and Custom Forms 3
CWM030 Call me old if you want. OL 2016 font size out of the box. Using Outlook 3
M Outlook 2016: Changing default font for Notes and Reading Pane Using Outlook 4
D font control by keyboard Using Outlook 2
M font format discrepancies with Quick Parts Using Outlook 1
Steven 2007 New PC vs Old PC - Micro Font on Inbound Emails :( Using Outlook 4
D Font in Reply is much larger than normal, how to reset ...? Using Outlook 4
Rupert Dragwater Can't change font size Using Outlook 5
O How to paste website content using a specific font and removing URLs Using Outlook 2
T "From" field font size in table list of emails Using Outlook 0
K Paste from Windows Clipboard then change font without losing formatting Outlook VBA and Custom Forms 1
S Default Font in body of Task Using Outlook 0
O VBA to Run Font Change on Outlook Startup Outlook VBA and Custom Forms 4
Diane Poremsky How to Change the Font used for Outlook's RSS Feeds Using Outlook 0
S Outlook 2007, windows 10 Font size Using Outlook 1
L Outlook 2007 Font Using Outlook 3
J Increase font size of message body Using Outlook 5
D Outlook 2007 e-mail header- How to set font & font size in received message headers ? Using Outlook 2
J Font size changed in new mail messages Using Outlook 5
Rupert Dragwater unable to change font sizes in some replies Using Outlook 3
D Conditional formatting - font sizes Using Outlook 3
O How to increase Font size in Outlook 2013 Using Outlook 1
Fozzie Bear Change the colour or font of individual email accounts in outlook 2010/13 Using Outlook 1
K Untitled Appointment Font Using Outlook 1
J Change Default View - Color and font Using Outlook 3
J Changing Contact Notes Font Outlook VBA and Custom Forms 9
R Can't modify Outlook view font with IE anymore (even though IE still affects print font) Using Outlook 5
B Outlook 2007 Save Current View,Font,Toolbar Settings Using Outlook 6
O Copy email content and paste into new Word Document using a different font Using Outlook 1
P Outlook 2010 custom form olk control font size increases everytime form is published Outlook VBA and Custom Forms 1
M Default font Using Outlook 2
L Font Type and Space Using Outlook 7
D Default Font in Outlook 2013 Using Outlook 3

Similar threads

Top