contact limit

[Marc]

I am trying to import contact records from Excel into Outlook. I have over a
1000 records but only 957 are being imported. Do you know why?

 

[Vince Averello]

I'd take a look at one of the contacts that's not being imported and see if
there's a common thread like bad field content or similar

 

[Marc]

Thanks I will look at that, how many contacts can Outlook have???

 

[Vince Averello]

The lowest limit would be 16383 or 65535 so you're not near it.

 

[Karl Timmermans]

If the missing records are at the end of the Excel worksheet - then the most
likely cause of the problem is that the "Named Range" in use in the Excel
worksheet doesn't encompass all rows and needs to be changed (if you're not
familiar with Excel Named ranges - you can save the worksheet as a CSV file
and import that file instead). Don't recall an instance where the Outlook
import wizard will not import an item without issuing an error message and
keep on going.

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com

 

[Diane Poremsky [MVP]]

Using a worksheet you previously exported and not extending the named range
to cover all records is the usual cause.
See http://www.slipstick.com/Tutorials/import/import.htm

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.