A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Problems Importing Excel to Outlook



 
 
Thread Tools Display Modes
  #1  
Old February 15th, 2010, 03:11 PM posted to microsoft.public.outlook.contacts
Goodegg
external usenet poster
 
Posts: 1
Default 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  
Old February 15th, 2010, 04:43 PM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 682
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:07 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.