Problems Importing Excel to Outlook

  • Thread starter Thread starter Goodegg
  • Start date Start date
G

Goodegg

Hello,

I have exported my current outlook contacts (appox 400) to excel and
have manually added to the sheet and copied and pasted in, about an
extra 1000 contacts. I have changed the ‘Categories’ column to a new
name and they are all now listed as 2, different and new categories.
When I come to import the sheet back it makes the new categories, and
then adds about 20% of the contacts on the excel sheet to each of the
new categories. It won’t add them all.

Any ideas or solutions would be appreciated.

Good Egg
 
After you added the new contacts - did you change the "Named Range" to
reflect the additional rows?

You may find this article of interest regarding import/export using Excel
http://www.contactgenie.com/blog/?p=75

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