Attaching and pasting excel sheet in to a new mail

Hi All,

I Required a macro to attach Sheet 1 from my workbook to outlook mail and sheet2 in to the body of the same mail and send to specified mail id.

kindly help to get VBA code for the same.

Regards,

Prabhu

Hi Prabhu,

Let's see how we can get do this yourself. What you basically are after can be split down to 3 steps. Export a worksheet as a workbook. Get the contents of a sheet. Put it to the body of the mail. Code for all of these are available on many forums, including this one. Please give it a go. Come back with what you've been able to put together. We will take it forward from there.

Hi Admin,

As advised, i have completed the step one i.e attaching the sheet in to mail. now i need to paste the summery sheet in to the mail.

Example If i attach Sheet "IJKL" in the mail, sheet "IJKSummary" to be pasted in the mail body with the existing note.

similarly for other sheet also.

Kindly do the needful.

Regards,

Prabhu