1

I am looking for the possibility to copy all (backup) my address book entries into plain text, or CSV, or XLS from Lotus Notes mail client. My aim is to later copy these details into Outlook.

Is it possible. I haven't done lotus scripting before. But I am going through the reference links. If possible provide links or pointers for accomplishing this task.

I am using Lotus Notes 8.0.1.

Update: Is it possible to do this using VB or VB.NET? The language is not a constraint, as long as it is possible.

MPelletier
  • 16,256
  • 15
  • 86
  • 137
Guru
  • 2,331
  • 6
  • 31
  • 48

4 Answers4

3

No scripting needed.

If you are using Notes Mail via the client, your contacts are in a "Personal Address Book", not the mailfile itself. It is usually an icon on the notes workspace called "(yourname)'s address book on local". The filename is names.nsf.

Open this to the Contacts view. Do File>Export Contacts, and you can choose All/Selected contacts, All/Basic fields, file location, file name, and file type. You could even choose to export them as a vcard, which I believe would be easiest to import into Outlook's contacts.

  • I tried exporting. What I got is AreaCodeFromLoc: SavedUpdate: $AddressFormat: 1 $NameFormat: 1 $BusinessAddressFormat: 1 $PersonalAddressFormat: 1 $PersonalAddressFormat1: 1 $PreviewFormat: 1 $PreviewFormat1: 1 $BorderColor: 7F96A3 AltFullNameLanguage: FullNameInput: Abstract Confusions NameHelperInput: CompanyName: WordPress\r TITLE:WordPress Email Publishing. This is difficult for me copy into Outlook. :( – Guru Aug 19 '09 at 15:24
  • 1
    Use the option to export in vcard format. You can get one file with all the contacts as vcards. You can import the vcards file into outlook. –  Aug 19 '09 at 16:22
  • I agree with Maria the best option is to export in vcard format. – Carlos Aug 19 '09 at 20:01
  • That's the only way out I think. After all, all this while I am not able to get any scripting. :( Thanks Maria. – Guru Aug 20 '09 at 03:54
1

If you need to do this on a lot of databases, or allow end-users to backup their contacts, you could use an Export to Excel script I wrote years ago into the address book.

Another easy way to export information from Lotus Notes without any programming is to create or find a view that has what you need, then select all, and choose Edit > Copy Selected As Table. Then just paste into Excel. I'm not sure if the command has changed in version 7 or 8, but it worked great in the 6.x versions.

Ken Pespisa
  • 21,989
  • 3
  • 55
  • 63
  • It is copied in VCARD format. Is it possible to add this in Outlook? (I don't have Outlook yet in my system) Like thisBEGIN:VCARD X-LOTUS-CHARSET:windows-1252 VERSION:2.1 FN:Someone P N:P;Someone;;Mr.; EMAIL;WORK;PREF;X-LOTUS-NOTES:CN=Someone P/OU=DEL/O=ABC ORG:ABC X-LOTUS-ADDL-NDX-NAMES:Someone P/DEL/ABC REV:2006102 END:VCARD – Guru Aug 19 '09 at 15:21
0

I haven't use Notes since version 5, but couldn't you just create a view of the items you want, then export the view?

Crispy
  • 5,557
  • 3
  • 30
  • 35
  • Thanks Chris. I tried views as you suggested. Not able to select 'Contacts'. The views I can select are "All documents, Mail threads, Todays mail and things like that...". I am looking at the possibility to backup the contacts. – Guru Aug 19 '09 at 14:22
0

I am able to send mails from VB using Lotus Client. I used the reference here IBM - Send mail using VB. Now I need to loop through the contacts in the same place and back them up.

Guru
  • 2,331
  • 6
  • 31
  • 48