Limit on number of records importable into Outlook Contacts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GeneM office - 02 Aug 2006 19:43 GMT

Is there a limit on number of records we can import into Outlook Contacts?

I am currently importing ~1500 records, somewhat standardized in an Excel
file on old Win98 PC, across a Catg-6 cable network in our office, into our
new Dell WinXP PC. Perhpas next time I should copy the Excel file over to
the new PC, I'll bet, and import from that local file!

The Progress screen seems hungm with cute pages floating across the top, but
showing caption,
"Importing Contacts from Pager into 'Contacts'

I'm suspicous of progress, but I did Export all current Contacts to a .pst
file before I started...
And I have closed all spreadsheet handling files on both PC's. So I do not
believe any other software is hanging up the transfer.

Advice?

Signature

Knowledge Spunge (need spill-checker)

Reply to this Message

GeneM office - 02 Aug 2006 20:05 GMT

Hmm, finally Ended Task (after 30-40 minutes). re-opened Outlook & found
22,458 new empty records. I believe we will delete them, close Outlook and
try again.

Signature

Knowledge Spunge (need spill-checker)

> Is there a limit on number of records we can import into Outlook Contacts?

Reply to this Message

Karl Timmermans - 02 Aug 2006 22:29 GMT

Most likely cause of extra records is that the "Named Range" in the Excel
worksheet is not set correctly. Make sure it only encompasses the data you
want to import (along with the first header row containing the field names)

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

> Hmm, finally Ended Task (after 30-40 minutes). re-opened Outlook & found
> 22,458 new empty records. I believe we will delete them, close Outlook
[quoted text clipped - 3 lines]
>> Is there a limit on number of records we can import into Outlook
>> Contacts?

Reply to this Message

GeneM office - 03 Aug 2006 11:10 GMT

Thanks, Karl.

I am guessing you are speaking of naming the whole data set as "Contacts",
as I had seen in the web page "In Microsoft Outlook, how can I import address
information from an Excel workbook into my Contacts list?" at Indiana
University, page

http://www.microsoft.com/wn3/aspx/postui.aspx?mid=75c19e01-c9f7-4cab-b471-a7d82e
561038&cat=&lang=&cr=&guid=&sloc=en-us&dg=microsoft.public.outlook.contacts&base
=http://www.microsoft.com/office/community/en-us/default.mspx&bclr=ececec&fclr=0
00000&sxml=http://www.microsoft.com/office/community/en-us/site.xml&stgxml=http:
//www.microsoft.com/office/community/en-us/settings.xml&sdgloc=en-US

I have also read another post that tells me to Range Name each field-column
by iits field name, but that is the scheme which had resulted in my mass
mess of blank (or nearly blank) records, many of which had only one active
field per record!

Will try Range Name "Contacts", and go again.

Thanks!
-GeneM

Signature

Knowledge Spunge (need spill-checker)

> Most likely cause of extra records is that the "Named Range" in the Excel
> worksheet is not set correctly. Make sure it only encompasses the data you
[quoted text clipped - 8 lines]
> > Hmm, finally Ended Task (after 30-40 minutes). re-opened Outlook & found
> > 22,458 new empty records.

Reply to this Message

GeneM office - 03 Aug 2006 17:58 GMT

Yep, one Range Name "Contacts", that's the ticket!
Worked like a charm!

Thanks, again, Karl!

Signature

Knowledge Spunge (need spill-checker)

> Thanks, Karl.
>
> I am guessing you are speaking of naming the whole data set as "Contacts",
> as I had seen in the web page "In Microsoft Outlook, how can I import address
> information from an Excel workbook into my Contacts list?" at Indiana
> University, page

Reply to this Message