I am able to open the attached excel sheet from Lotus Notes document, but when I select all the contents and paste it in a new word document. The contents are pasted except the attachments are just image icons. Is there anyway so that I can open the excel attachment from the word document. Seems weird!! but this is a requirement!!
Subject: RE: Copy the document content to word
I don’t know that Word supports file attachments. You might have to consult some MS Word experts – not here.
Subject: RE: Copy the document content to word
It does, but they have to be created in word as a file-object. I don’t think you can just paste a file into a word document.
Notes uses two clipboards - the Windows (OS) one and an internal one. I would guess when you copy rich-text that has a file in it, only the icon is put on the OS clipboard, and that’s why you are seeing the results you are.
You may be able to use the VBA methods to automate the attaching. Manually, it’s Insert / Object … / Create from file / Display as Icon.