Problems Importing Excel to Outlook
 

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

Problems Importing Excel to Outlook
 

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


"Goodegg" wrote in message
...

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




--
Goodegg