Excel VBA sending Outlook email - Problem with *some* users' font sizes

[Elyss]

Hi Hope someone can help before I go bald!

I have an application written mostly in Excel 2010 VBA and used by upwards of 500 users. On clicking certain buttons, emails are generated and sent via Outlook to other users on the same Exchange network.

The VBA sets the body format to html (oItem.BodyFormat = olFormatHTML) and the body text is built using HTML tags.

99% of the time this works exactly as it should.

The other 1% of the time, Excel or Outlook or a little green alien is sending/delivering these emails with the body font size set to 1681pt instead of the rather more normal 12pt. Yes - I did say 1681. This is from the same code that generates the 99% correct emails. There are no formatting variables. I'm sure it can't be the code: it would do that every time if it were, right?

I've been unable to pin it down to a single sender or recipient (that doesn't necessarily mean there isn't one though). The worst part of all is that I have an overwhelming sense of deja vu about this...I'm *sure* I've seen it before somewhere in some other life.

Does anyone have any suggestions about where I should be looking? ------Thank you!------

 

[healey21]

Welcome to the Forum, what does the HTML code state for the Font size?

!font size="3"?Type me as example text!/font?

In my example to show the tags please replace the ! with a < and the ? with >

 

[Elyss]

Welcome to the Forum,

Thank you!


!font size=12pt?Type me as example text!/font?..................Replacing the !and ? produces (here, anyway!).......

[SIZE=12pt]Type me as example text[/SIZE]

This forum doesn't seem to like 12pt, it just goes for size 12. The emails from my application look quite normal, and I've tried changing the font size just to make sure that it's 'taking'. It is.

 

[Elyss]

When I 'previewed' the above message your text appeared formatted, hence the followup comment, but it clearly hasn't in the actual post.

[FONT=&quot][/FONT]​

<textarea style="height: 80px; width: 444px; border: 1px solid grey; padding: 2px;"></textarea><select><option value="af">Afrikaans</option><option value="sq">Albanian</option><option value="ar">Arabic</option><option value="hy">Armenian</option><option value="az">Azerbaijani</option><option value="eu">Basque</option><option value="be">Belarusian</option><option value="bg">Bulgarian</option><option value="ca">Catalan</option><option value="zh-CN">Chinese (Simplified)</option><option value="zh-TW">Chinese (Traditional)</option><option value="hr">Croatian</option><option value="cs">Czech</option><option value="da">Danish</option><option value="auto" selected="selected">Detect language</option><option value="nl">Dutch</option><option value="en">English</option><option value="et">Estonian</option><option value="tl">Filipino</option><option value="fi">Finnish</option><option value="fr">French</option><option value="gl">Galician</option><option value="ka">Georgian</option><option value="de">German</option><option value="el">Greek</option><option value="ht">Haitian Creole</option><option value="iw">Hebrew</option><option value="hi">Hindi</option><option value="hu">Hungarian</option><option value="is">Icelandic</option><option value="id">Indonesian</option><option value="ga">Irish</option><option value="it">Italian</option><option value="ja">Japanese</option><option value="ko">Korean</option><option value="la">Latin</option><option value="lv">Latvian</option><option value="lt">Lithuanian</option><option value="mk">Macedonian</option><option value="ms">Malay</option><option value="mt">Maltese</option><option value="no">Norwegian</option><option value="fa">Persian</option><option value="pl">Polish</option><option value="pt">Portuguese</option><option value="ro">Romanian</option><option value="ru">Russian</option><option value="sr">Serbian</option><option value="sk">Slovak</option><option value="sl">Slovenian</option><option value="es">Spanish</option><option value="sw">Swahili</option><option value="sv">Swedish</option><option value="th">Thai</option><option value="tr">Turkish</option><option value="uk">Ukrainian</option><option value="ur">Urdu</option><option value="vi">Vietnamese</option><option value="cy">Welsh</option><option value="yi">Yiddish</option></select>⇄<select><option value="af">Afrikaans</option><option value="sq">Albanian</option><option value="ar">Arabic</option><option value="hy">Armenian</option><option value="az">Azerbaijani</option><option value="eu">Basque</option><option value="be">Belarusian</option><option value="bg">Bulgarian</option><option value="ca">Catalan</option><option value="zh-CN">Chinese (Simplified)</option><option value="zh-TW">Chinese (Traditional)</option><option value="hr">Croatian</option><option value="cs">Czech</option><option value="da">Danish</option><option value="nl">Dutch</option><option value="en" selected="selected">English</option><option value="et">Estonian</option><option value="tl">Filipino</option><option value="fi">Finnish</option><option value="fr">French</option><option value="gl">Galician</option><option value="ka">Georgian</option><option value="de">German</option><option value="el">Greek</option><option value="ht">Haitian Creole</option><option value="iw">Hebrew</option><option value="hi">Hindi</option><option value="hu">Hungarian</option><option value="is">Icelandic</option><option value="id">Indonesian</option><option value="ga">Irish</option><option value="it">Italian</option><option value="ja">Japanese</option><option value="ko">Korean</option><option value="la">Latin</option><option value="lv">Latvian</option><option value="lt">Lithuanian</option><option value="mk">Macedonian</option><option value="ms">Malay</option><option value="mt">Maltese</option><option value="no">Norwegian</option><option value="fa">Persian</option><option value="pl">Polish</option><option value="pt">Portuguese</option><option value="ro">Romanian</option><option value="ru">Russian</option><option value="sr">Serbian</option><option value="sk">Slovak</option><option value="sl">Slovenian</option><option value="es">Spanish</option><option value="sw">Swahili</option><option value="sv">Swedish</option><option value="th">Thai</option><option value="tr">Turkish</option><option value="uk">Ukrainian</option><option value="ur">Urdu</option><option value="vi">Vietnamese</option><option value="cy">Welsh</option><option value="yi">Yiddish</option></select>

English (auto-detected) » English​

​