Adding Range to Mail Body

[MMaghawry]

Hi Guys,
I'm absolutely new to VBA and looked around for the attached code to get what i needed which does exactly what i need, it has a section to copy a range,but it doesn't keep format(it's a pivot table). I need help as to how to make it keep the format.

--Had to attach it cause i'm a new member
2670626707

[gmayor]

Without the materials to test, it appears that you are converting the worksheet data to text (strPaste). Instead of doing that copy the Excel range to the clipboard and paste that into the message range (oRng)