If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 -- Goodegg |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|