Attach & copy data from workbook to mail via VBA

HI All,

I have an excel file recorded with macro already.

Each and every time I run it, I will get a data like the excel file which i have attached.

I need a vba for copy pasting the data from a sheet call "pivot1" in the excel(attached) to the outlook body, also the entire excel workbook needed to be attached along with this email and sent to the respective recipient.

NOTE: Every time the macro runs i will get new data, so the file should not get saved.

Kindly refer the excel file attached.

Please help me with this.

Thanks in advance.