Attach & copy data from workbook to mail via VBA

[Venkatesh.S]

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.

[Logit]

.
.

Please Login or Register  to view this content.

[Venkatesh.S]

HI Logit,

Thanks for your script,

Your scripts is working fine without my macro,

But when I run along with my macro it is not working fine,

It sends mail with attachment, but when I open the atatchment the atachment is Empty.

Also generates two mail for the same.

Herewith I have atatched my complete VBA,

Kindly modify the script.

Thanks In advance

[Logit]

I don't understand.

The project copies and pastes sheet PIVOT1 to the body of the email and also attaches the workbook to the email.

What other action / s are you needing the code to do ?