Excel to Lotus Notes Form

Sjh747

5 pts.

Tags:

Lotus Forms

Lotus Notes

Lotus Notes 7.x

Lotus Notes import/export

Microsoft Excel

Microsoft Excel import/export

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

Asked: November 14, 2008 2:14 AM Last updated: December 17, 2008 1:22 PM

Answer Wiki

Last updated: November 25, 2008 3:00 PM GMT

BruceWayne4,465 pts.
History
Contributors
- Ordered by most recent
- BruceWayne4,465 pts.

Thanks. We'll let you know when a new response is added.

The easier solution is “Edit -> Paste Special -> Text” !
Did you try it ?

Discuss This Question: 2 Replies

There was an error processing your information. Please try again later.

Thanks. We'll let you know when a new response is added.

Send me notifications when members answer or reply to this question.

Brooklynegg Nov 26, 2008 6:50 PM GMT

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

3,845 pointsBadges:

report
BruceWayne Dec 17, 2008 1:22 PM GMT

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...

4,465 pointsBadges:

report