Pivot tables in mail body

Hi
I have converted sheet1 data into 3 pivot tables now I need to paste the pivot sheet data in the mail body (3 pivot tables in mail body).also I need to hide the sheet1 while sending attachment.

@kavitimoulika135,

Refer this solution for pivot table in email body.

For hiding a sheet, you can use VBA code.