Converting excel worksheet to html and into body of email

[Excelcraig]

Please help

I have looked around code on internet for this and the best ive found is from ron de bruin. (Mail one worksheet in the body of the mail)

I am using his code and all works apart for 1 thing

I have a number of cells merged and have text wrap on it

Issue is when i run code the code the text wrap does not seem to copy and only displays the 1st line of text when i have 10

Can anybody suggest what i can add so when it does the copy it keeps the formatting as per my excel sheet?

Thanks in Advance

Craig