missing fields when importing contacts from excel 2003 to outlook

  • Thread starter Thread starter lttlemisslovely1973
  • Start date Start date
L

lttlemisslovely1973

Hi folks. I have a list of contacts that I wish to import into outlook 2007.
I have saved it as an excel 2003 document but when I go to import it, I only
see 10 out of 12 column headers. The result of which is that the email
address and notes do not get imported. I looked through this list to see if
I could see any answers and have looked at my named range to ensure it
encompasses all my columns and it does, so can anyone shed any light on this?

Thanks.

Kerry
 
What happens if you export some of your existing contacts to Excel and
compare the output to your Excel list?

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.
ALWAYS post your Outlook version.
How to ask a question: http://support.microsoft.com/KB/555375


After furious head scratching, lttlemisslovely1973 asked:

| Hi folks. I have a list of contacts that I wish to import into
| outlook 2007. I have saved it as an excel 2003 document but when I go
| to import it, I only see 10 out of 12 column headers. The result of
| which is that the email address and notes do not get imported. I
| looked through this list to see if I could see any answers and have
| looked at my named range to ensure it encompasses all my columns and
| it does, so can anyone shed any light on this?
|
| Thanks.
|
| Kerry
 
A simpler, easier alternative to using Excel and named ranges and and
and....

Save your worksheet as a CSV file, use that file for importing, manually
map all fields. Done.

Karl

--
____________________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - QuickPort/DataPort/Exporter/Toolkit/Duplicate Contact Mgr
"Contact import/export/data management tools for Outlook '2000/2010"
http://www.contactgenie.com
 
Back
Top