Attaching and pasting excel sheet in to a new mail

[Prabhu]

Hi Friends,

I tried to modified a existing macro to attach couple of sheets as a workbook and past the summary sheet in the same mail body.

but i have encounters an error, kindly help to modify the attached macro to run the same.

Regards,View attachment Test.xlsmView attachment Test.xlsm

Prabhu