Import ALL Excel Info Into Outlook Contacts

[RickySRicardo]

I'm importing into Outlook ('98) Contacts from Excel ('97). After many hours of work, I got it to work, partially - only got Name and Company to import. Then, with changing names of column headers in Excel to match Outlook, I got E-mail (address), Job title and Categories to come over. Problem is, I can't get anything else, no phone #'s, no address, etc. What do I need to do? Also, what is the field name of the big white area on the bottom half of the Contact sheet? I thought it was called Notes, but that didn't seem to work.

So what do I do to get all of the info imported?

 

[dgh2000]

I would suggest you do the reverse. Create a contact in Outlook, fill in all the fields then do an export to a csv or an Excel file and see what you get.

Dave

 

[RickySRicardo]

I thought of that, too. I tried it, and even though I created a new .xls file called "Test" in a separate folder, and sent a totally different set of Contacts to it, it took on the characteristics of the original Excel file that was sent to me, with the same column header titles, etc., and filling in only the information from Outlook onto Excel that I am able currently to import from Excel to Outlook.

Back to the drawing board?

 

[Guest_imported]

Any luck with getting all the fields? I am having the same problem. I've found "where" the problem occurs, but can't figure out how to fix it.

After choosing the .csv file from the "browse" option and then specifying where to put these imported items, the next dialogue box says, "the following items will be performed" and it automatically chooses "Import file into the Contacts folder" and only gives you one option to the right which is "change destination". However, directions I have been able to find for Outlook 2000 say that there should be another choice in that dialogue box to the right that says "Map Custom Fields". There isn't. It tells me that if that option isn't given, then "you have chosen a non-contact type folder to import into. Go back and choose the correct Contact folder".

I do all of that and I still don't get that option. I believe that is where the problem is occuring and if I had that option, it would allow the other fields to be populated. Any thoughts?