Pasting range of cells into Lotus Notes Email

[just_some_guy]

Good morning,

I have the following code to send an email from Lotus Notes which works great.

Please Login or Register  to view this content.

It's slightly modified from another set of code I was using to email a copy of the workbook as an attachment.

What I need to do now is to copy the range of cells A1:E40, and paste it into the body of the email. I imagine it would take the place of ".body = "test"", but through various trials and what nots, I have not been able to figure out how to make this do what I want.

So, any ideas on how I would edit this code to paste in the cell range?

Thanks!

[Chippy]

Here's one way, which has the advantage of preserving the Excel column alignment and cell formats (colours, borders, fonts, etc.) in the sent email. Note that the Lotus Notes client GUI and the Mail tab (database) must be open.

Please Login or Register  to view this content.