mcelligott
Programmer
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
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
