Paste cells into Lotus Notes e-mail body

[mcelligott]

I have been searching the forums and internet for a way to copy a specific range of cells and paste them into the body of an e-mail using Lotus Notes. I have the following code which appears to do everything (including the copy) but will not paste the cells into the body.

Range("A1:L45").Select
Worksheets("Sheet1").Range("A1:L45").Copy
ActiveWorkbook.SendMail Recipients:="Robert McElligott", _
Subject:="End of Shift Report for 1st Platoon"
Application.SendKeys "^v", True

It does attach the workbook as an attachment but also need to send these cells in the body of the e-mail.

Can anyone assist with figuring this out?

Thanks in advance for any assistance.

Bob