Setting 11 pt font size in outlook email using excel vba

**drajanm** · 01-10-2013, 03:38 AM

Hi,

I need help in setting a font size of 11 in an outlook email using a vb code.

I am currently using

Please Login or Register  to view this content.

The above code generates a font size of 12 in outlook. Minute decrements in the size from 3 generates a font size of 10 in outlook - the size 11 does not arrive at all.

Is there any way to obtain this font size?

**JieJenn** · 01-10-2013, 03:49 AM

This is what I use. Give it a try.

.HTMLBody = "Font Size Test"

**drajanm** · 01-10-2013, 05:01 AM

Hi Jie,

Thanks for the help! The font size is set now, but I am unable to set the font color to blue, even if I add
font-color:blue
to the above stretch of code. The default black color is used.

How do I get the blue color?

**JieJenn** · 01-10-2013, 05:09 AM

.HTMLBody = "Font Size Test"
OR
.HTMLBody = "Font Size Test"

**drajanm** · 01-10-2013, 05:26 AM

Works like a dream!

Thanks a ton.

**canetta** · 09-25-2017, 05:33 PM

How do I add this to a macro?

**FDibbins** · 09-26-2017, 12:53 AM

canetta welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

**khanhduy1995** · 05-09-2019, 12:18 PM

Hi,

Thanks for your help. Btw when I try to add automatic email signature by using & .HTMLBody, the size turns back to be default setting (10pt)

.HTMLBody = "Font Size Test" & .HTMLBody

I would appreciate if you could help me fix this issue. Thanks