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.
Refer this solution for pivot table in email body.
For hiding a sheet, you can use VBA code.