Excel VBA to Copy Merged Range along with Normal Range and Export it to Outlook

Dear Experts,

I have come across a strange issue with Excel Merged cells and need your suggestions to fix this.
Attached is the sample file along with Macro in it, all i am trying to do is copy this data into new worksheet and export into an outlook email.

Since top header is merged range, the code line "rng.Copy" under "Function RangetoHTML(rng As Range)" just doesn't work.
Can anyone help me with VBA code to export this data into outlook.

Thanks a lot for your suggestions in advance.

Hi,

just unmerge …

Thats the final solution i am thinking off..Is there no way that merged cells can be exported into outlook email..?

Try with the width of the range as large as the merge cells …