Send Email via Outlook

Hello,

I'm using some code to filter and copy data from Sheet1 to Sheet2.

I want to add a module to send email via Outlook.

As we see in the attachment (Sheet2). I want to copy this data into new workbook, from A1 cell to last data available in J column cell (data will vary - can be less or more).

In the attached the last data is till J16, this can be more or less.

Once the data is copied to new workbook, this should get attached to a new email into outlook.

(I've read, for sending emails through Outlook as attachment, first the attachment is saved to our system, then it is been killed and then it is attached to email)

Once the email is popped with the attachment, I'll manually add the recipients names into to, to whom I want to send the emails.

Please suggest.

Thanks !