Home > IT Answers > Microsoft Windows > Excel to Lotus Notes Form
Sjh747
5 pts.
 Excel to Lotus Notes Form
Excel import/export, Lotus Forms, Lotus Notes, Lotus Notes 7.x, Lotus Notes import/export, Microsoft Excel
I have a Excel workbook with alpha numeric text in a group of cells. I try and copy the text from those cells directly from Excel into a Lotus Notes 7 form and find that I cannot because Notes is treating the paste as being an object and not text. The cells in Excel are text formatted.... How do I copy text directly from Excel into a Lotus Notes form without using some 3rd party addon etc. Please advise Steve

Software/Hardware used:
ASKED: November 14, 2008  2:14 AM
UPDATED: December 17, 2008  1:22 PM
RELATED QUESTIONS
Answer Wiki:
Hi The easier solution is "Edit -> Paste Special -> Text" ! Did you try it ?
Last Wiki Answer Submitted:  November 25, 2008  3:00 pm  by  BruceWayne   4,075 pts.
All Answer Wiki Contributors:  BruceWayne   4,075 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Edit > Paste Special > Rich Text is the correct option if you want to retain the table formatting, etc.

Brooklynegg
 3,845 pts.
 

This link might be useful : you can use ClipBoard Windows API from within Lotus Notes
http://www.breakingpar.com/bkp/home.nsf/0/87256B280015193F87256CFA00581AB2

I use it – it works…

BruceWayne
 4,075 pts.