VB for sending embedded excel sheet

[Guest]

In Excel 2000 you can email the entire sheet not as an attachment but the sheet contents gets embedded into the email body.
How do you write VBA code to do this. The most I can get is one cell only using the following code.

MailMessageText = Sheets(“Mail”).Cells(2, 3)
NewMail.body = MailMessageText

How can I define the entire range. I have tried several traditional excel methods of defining the range such as Range("a1:z100") but they don't seem to work.

Thanks
John
John@liteweb.com