Send the content of a worksheet by email

Hi,

I am currently using a macro that attaches the active workbook to an email and then sends it to a mailing list.

I would like to know how I could copy and paste the content of a workbook in an email and simply send this email without attaching the workbook.

I would be very grateful if you could suggest a solution. I thank you in advance for your help.

Alain