Hi All,

I need a macro that will copy cells from a spreadsheet, locate a stationary email, or document within stationary (a template email) - it is on a specific mailbox database, which should be opened and then whatever range was copied from the spreadsheet to be pasted (as a bitmap) into the document body.

I have tried to amalgamate bits of code, but I have had no luck.

There is a specific address to the actual document and if I use the below script it brings it up fine! The problem I'm facing is I'm unable to paste the copied range.

Please Login or Register  to view this content.
That code brings up the actual document, but I cannot paste.

There is another piece of coding that I have found on the net.

As long as the document is visible it will copy and paste cells, but has issues and comes up with errors.

Please Login or Register  to view this content.
This however still brings up errors.

I know this second code, takes the range and pastes it into word and then pastes that back into the lotus notes document...

Can you please help?

Thank you