importing an excel table of contacts

[Guest]

I got this table of contacts (about 300) in an excel file from my cell phone
company off my old cell phone, and want to import them into Outlook 2000. I
thought it would be simple but have run into a problem. there may be 2, 3 ,
even 4 records for each contact. There are only three fields, the first
field is the name, the second field is the type (Mobile, Home, Work, etc),
and then the third field is the phone number. So there might be 3 records of
"John Doe", each with a different number. Is there a way to import this type
of list into Outlook? Is the some code or something that would combine them
together into one record per contact?
Many thanks,
CK

 

[Sue Mosher [MVP-Outlook]]

No, Outlook needs a highly structured list. It would probably be possible to write code to consolidate the information, but it would be specific to your particular list.

Another possible solution would be import what you have then use one of the duplicate checkers listed at http://www.slipstick.com/addins/contacts.htm to consolidate them.