Copy Range of cells and paste into email

[Shama]

Hi:

I have a table in excel that I would like to copy into an email and send to my co-workers on a regular basis.

Somewhere on the net I have find a piece of code (I've omitted a bunch of stuff here):

Set otlApp = CreateObject("Outlook.Application")
Set otlNewMail = otlApp.CreateItem(olMailItem)

With otlNewMail
.To = "email@address.com"
.CC = ""
.Subject = “Subject”
.Body = "Today's report"
.Display
end with

I wanted to know what code to use in the Body so that I can paste range of cells (the table).
Right now I get an "Array lower bound must be zero" error if I just put in the range.



Many thanks,
Shama