Copying Excel worksheet in Outlook email body

Hi everyone,

I'm looking for a script that can copy My workbook "sheet1" and copy the whole thing in a outlook email body section.

I used to have a script that attach the document, but now my managers wants the data straight into the email body.

I know its not a simple thing to do, i want excel to act as if i would CTRL+A the sheet and CTRL+V it in a email body, it can easily be done manually, but i need an automated script.

Any assistance?

IF you need data the email will need to be sent to "[email protected]"
with subject " Messaging rotation - Monday AM, please advise when updated"
and body will be the "sheet1" of my document who is called messagingrotation.xls located on my desktop

Thanks