Some data from Contacts not exported into Excel (OL 2010)

  • Thread starter Thread starter AD
  • Start date Start date
A

AD

Hi,

I'm trying to export all of my Outlook contacts into Excel 97-2003
format. The resulting file which I open in Excel 2010 contains all
records, however the data appears only in this fields: Title, Company,
Anniversary, Birthday, Categories, Notes, Priority, Private,
Sensitivity - that is all field name consisting of one word. There is
no data in two-word fields' names: FirstName, LastName, etc. Field
mapping is set to default.

How do I fix this and export all of my data into all fields?

Thank you!
 
I'm trying to export all of my Outlook contacts into Excel 97-2003
format. The resulting file which I open in Excel 2010 contains all
records, however the data appears only in this fields: Title, Company,
Anniversary, Birthday, Categories, Notes, Priority, Private,
Sensitivity - that is all field name consisting of one word. There is
no data in two-word fields' names: FirstName, LastName, etc. Field
mapping is set to default.

How do I fix this and export all of my data into all fields?
Click to expand...

Open one of those contacts in Outlook then click the Full Name button. Are
the parts of the name correctly distributed in the various fields?
 
Hi Brian,

I was just checking the names and figured it out! Names were
distributed correctly, but field mapping was screwed for reasons
unknown. Just needed to set default field mapping before exporting and
everything worked fine.

Thanks for your help!
 
Back
Top