Problems Importing Excel to Outlook

[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

 

[Karl Timmermans]

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