Excel Send Email Using Lotus Notes 8

The code below sends out an e-mail through microsoft excel using lotus notes 8 but it does not keep the text formatted. For instance there are headings in the text that i want to be bold but it doesn't keep the bold formatting. I have tried a couple of things but it seems a lot of the things (like htmlbody instead of body) only seem to work with Lotus Notes 7 and not 8. Any help would be greatly appreciated. Or if there is another way to make a form in excel and then have it get sent out (in the correct format) through lotus notes 8, I would like to know.

Lots of googling has lead me to this site because I can't seem to figure it out and neither can anyone (it seems) at my company.

Thanks

Please Login or Register  to view this content.

Hey Sorry about that, first post in the forum. I will post on both forums that it is a duplicate. I am just trying to get this solved as soon as possible.

I apologize for the inconvinence.

The question is also on MrExcel:
http://www.mrexcel.com/forum/showthread.php?p=2386411

Question still hasn't been answered on either.

Anyone had to deal with this issue or can help?