Excel Macro to Outlook (With bunch of text formatting)

hey guys. I have a word template I'm trying to follow closely and hoping my excel macro can generate it format for format on Outlook. Couldn't put my current code here as it has the GREATER THAN sign that apparently triggers the security

I have attached what it looks like in Word and the Excel file with the code and what it looks like in Outlook. I have also circled the differences currently.

besides those above, two other minor problems I have trouble understanding is:
- why do i have to put font size as 13 for Outlook to show it in 11 (i did trial and error and ended up with 13 for it to show as 11)?

Please Login or Register  to view this content.

- the body message has 2 paragraph spacing from the signature. not sure why too.
These 2 are smaller problems I can still be ok with.

thanks in advance!

*bump*
seems like Excel to other applications (Outlook, PowerPoint, Word) are pretty hard to find. Tried to buy a book but doesn't really cover what I want.

Thank you, ByteMarks! this is almost accurate. I noticed you input a font size of 12 but it ends up as 11 too. And no matter what size I changed it to, it doesn't work

instead of using "b" for bold, you used "strong", which I'm guessing is due to the "!DOCTYPE html" you used.

the 2nd timing (4pm to 6:30 PM) not aligned to the 1st timing, but I'm willing to settle for this if there are no solutions.

thank you once again

I'm not an expert but I think this comes close.

Due to firewall put the code in a textfile.

thanks, bakerman2! it has different pros and cons vs ByteMark's solution.
pros:
the font size of the texts are now mostly Arial 10 (except for the opening hours)

cons:
the opening hours have unwanted paragraphing

i'm wondering if it's a limitation or is there some solution out there

Q: Does your output change when you decide to include or exclude signature?

Played around some more.
benishiryo.PNG

@humdingaling:
no, the output doesn't change when i include signature. it will just be whatever the format i requested with a signature below. it always have additional carriage return though, but that's a side issue.

@aarona: the line of code you suggested actually made all the font size different. but it made me look at ByteMark's solution where he used:

Please Login or Register  to view this content.

instead of ":=" and "px", i tried:

Please Login or Register  to view this content.

i somehow have to make it font size 13.5 for Outlook to present it as font size 10. weird, but it works!

now only if the timings are in line and we can call it a day. i tried removing the nbsp but they will never be aligned.
Outlook format.PNG

very strange, @bakerman2. i used your file but it doesn't show me the same. font size is 12 and timing not aligned.

Outlook format bakerman2.PNG

Remove some of the   on the line with 4pm to 6:30pm until it aligns correctly.

@bakerman2: oh yeah i did mentioned trying to remove the &nbsp. but it didn't seem to work. i wonder what different computer settings we have that causes this. ByteMarks said his worked in his computer too.

When I used this

Please Login or Register  to view this content.

instead of this

Please Login or Register  to view this content.

and removed some of the   to this

Please Login or Register  to view this content.

nothing changed.
But when using this

Please Login or Register  to view this content.

and this

Please Login or Register  to view this content.

This is what I got.
benishiryo.PNG
So following the logic this should aline properly for you.