Report PASTED into E-Mail body as RTF Version

Greetings, I have a report that I would like to paste (as an RTF format) into the body of an e-mail (NOT as an attachment, but into the body). I am not sure how I can copy the report to the clipoard, and then paste into the body all in one motion, but I am hoping someone here can!!

The best thoughts I have, would be to save the report as RTF, then open the file, read the results and copy/paste it into the body of the e-mail, but I am way out of my league to do this.

I dont have any pictures, but I am using a pretty complex report with tables built in and sub-reports being used.

Creating the RTF file works perfectly, I just need to be able to copy the same file into an e-mail body...

Thanks!


I have this:

With objMail
     .To = "Report Distro"
     .Subject = "REPORT" & Format(Date, "dd-mmm-yyyy")
     .Body = THIS IS WHERE THE REPORT NEEDS TO BE PASTED
     .Display
End With