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
​

 

[DougRobertson]

... okay, let's try that again.

[LEFT][COLOR=#222222][FONT=Verdana]< span style='font-size:" & iOutlookFONTSize11 & "pt' >[/FONT][/COLOR][/LEFT]

 

[daverunt]

Hi Doug,

never knew that existed. So thanks for that.
Just go to the Sent Mail folder and right-click - view code.
See how it converts that to font-size HTML in the mail.
It should all look compliant.

 

[DougRobertson]

Hi Dave,

It works just as advertised. Font size 11 comes out as size 11, size 20 comes out as size 20, and so on.

I've been stumped on this code for probably closer to 10 years now, with a few visits to Mr. Excel, but to no avail ... until now.

The more I learn about Excel, the more I realize that I DON'T know!

Again, many thanks! Now I'm off to re-code all my Macros ...