[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2666
  • Last Modified:

import excel data into contacts

I am using Windos XP PRO and I have MS Office XP 2003. I also have Lotus Notes 6.0.  

My Question is:

I have an Excel sheet with contact info such as, Name, Address, Phone, City,State, email, etc.

I want to create a file format that I can import into Lotus Notes.  Lotus notes will only take .VCF format. Is there another way?  Is there a way to save to outlook from excel and then export as vcf from excel to Lotus Notes?

Thanks
0
erodcpu
Asked:
erodcpu
  • 2
  • 2
1 Solution
 
HemanthaKumarCommented:
here is a script which can do export.. reverse it and you have import feature,
http://www-10.lotus.com/ldd/46dom.nsf/8fcda5a283f280b2852565590071d8af/98495d9bc7f95e2885256936004e7f90?OpenDocument

~Hemanth
0
 
Sjef BosmanGroupware ConsultantCommented:
Best approach (ahem):
- inspect a contact document, figure out what fieldnames are used
- add a column Form with content "Person" on every row
- the first row should contain the names of the fields where the contact information should be stored
- most important part: save the Excel-file as a .wk4 file
- open your address book
- File/Import, select Lotus 1-2-3, select the file and click Import

No tools or programming required...
0
 
p_parthaCommented:
hey
thanks for the points

partha
0
 
Sjef BosmanGroupware ConsultantCommented:
Hey bro, your's seems to be better still... ;)
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now