Font Sizing in HTML

[DougRobertson]

Hello,

I am using HTML code within VBA to create the text within the Macro-generated emails.

Using Font Size 2 in HTML will give me a font size of 10 in my email.

Using Font Size 3 in HTML will give me a font size of 12 in my email.

Is there any way of over-riding this method, as I need to get an actual font size of 11 for the text in my email.

Many thanks in advance for any assistance on this!

~ DWR
​

 

[Norie]

Doug

How are you specifying the font size?

 

[DougRobertson]

<font size="2">

 

[Norie]

Try experimenting with using other units, e.g. px.

<font size='10px'>

 

[daverunt]

If you send an HTML mail and 'View Code' in the Sent Mail item you'll see Excel uses point sizes.
Not sure how it does conversions. 18px for example is converted to 13.5pt

< span style='font-size:8.0pt' >Text< /Span >

I found this, which seems to agree 13.5 *96/72 =18px
http://www.itjungles.com/point-to-pixel-conversion.html

 

[Norie]

daverunt

Forgot that you could use pt as a unit for font size, that's probably what the OP needs.

 

[daverunt]

Yep, I never use them though.
Found a converter calc above - useful for future

 

[DougRobertson]

Gentlemen! The span style code is EXACTLY what I've been looking for, for about 5 years now!

Thank you both very much, and blessings upon you.

 

[daverunt]

We're glad to help.
I calculated 8.25pt as 11px but found Excel rounded up to 8.5 in the mail.

 

[DougRobertson]

It is SO great to have complete control now over the look of all my company's Macro-generated emails - thanks again!

However, I've done some experimentation, and have found that at least with my system, all I have to do is use the code you suggested, with actual Outlook font sizes, and it always works. Am I missing something that could cause trouble down the line?

I declare the variable

iOutlookFONTSize11

to be the hard number 11, then use it in the following code:

'<span style='font-size:" & iOutlookFONTSize11 & "pt'>​

​

... and it works like a charm with numerous sizes.