I have a user who has over 100 names, addresses, phone numbers, etc in his contact database. His secretary needs to export them into either Excel or Access so she can do up mail merge letters in Word. None of the listed export methods seem to be sufficient. Asking if anyone out there has done this or has any good ideas on how to. TIA!Dean
Subject: Export Contacts
File - Export - export all records as a filetype of Lotus 1-2-3. Excel can open a .123 file and can then be (converted) saved as a .xls.
Subject: Not Office 2007
I just ran into an issue importing data. Office 2007 no longer supports the Lotus 1-2-3 file types.
Build a view with all of the necessary fields, then export that to a text format. Excel can handle the text format in most cases.
You might need to open the text file first and remove and commas.
Subject: Export Contacts
Thanks for the response but that did not work. When I exported to 1-2-3 format, it did not add any extension, so Excel would not open the file at all except with a bunch of strange characters and in no order whatsoever.
Dean
Subject: Copy selected as table
You may simply select all documents and go to Edit → Copy selected as table. Then you may paste into MS Excel directly.
Subject: Notes Contacts
Been there, done that. Does not copy all the fields - only name, e-mail, phone, company and date modified. Customer needs EVERY field to do a mail merge properly, like home addresses and company addresses - not just names. I think she may have found a 3d party software to do what they want, but it’s too bad LN can’t be more useful in this regard.
Subject: Extension - .wk4
Save the file with the wk4 extension. I have some code floating around to export the data if you like shoot me an email. gerritse AT optonline.net.
Subject: Lotus Notes / Domino Export Utility
If you’d like to consider a third-party solution we have an export utility for Lotus Notes / Domino which can export to Excel, MS-Access and many other formats.
More information can be found at:
Subject: Notes Reconn (Open Source)
Try this:Notes Reconn(Open Source) from openNTF: