Emailing Excel Sheet

[ExcelNut]

Hello,

I am looking to copy and paste a sheet into an email body and send it to a list of recipients. This list will be saved in the same workbook on a different sheet. I know there must be a thread already dedicated to this and was hoping someone could point me in the right direction.

Thank you for your help.

[arthurbr]

We do have an efficient search menu on the forum...
Have a look here

[ExcelNut]

Hello Arthurbr,

Thanks for the reply. I had been looking for that serch and for some reason couldn't find it until right after I had made the post. Thanks for the link. I had found that earlier and have been playing with the code. I cant get any of them to work.

Is there a way to generate an email in VBA without an attachment. I only want a Subject and A Body sent to a list of recipients.

Any Ideas?