Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Using Contacts (http://www.outlookbanter.com/outlook-using-contacts/)
-   -   Limit on number of records importable into Outlook Contacts (http://www.outlookbanter.com/outlook-using-contacts/22643-limit-number-records-importable-into.html)

GeneM office August 2nd 06 08:43 PM

Limit on number of records importable into Outlook Contacts
 
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?


--
Knowledge Spunge (need spill-checker)

GeneM office August 2nd 06 09:05 PM

Limit on number of records importable into Outlook Contacts
 
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.

--
Knowledge Spunge (need spill-checker)


"GeneM office" wrote:

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



Karl Timmermans August 2nd 06 11:29 PM

Limit on number of records importable into Outlook Contacts
 
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



"GeneM office" wrote in message
...
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.

--
Knowledge Spunge (need spill-checker)


"GeneM office" wrote:

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





GeneM office August 3rd 06 12:10 PM

Limit on number of records importable into Outlook Contacts
 
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/po...l&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

--
Knowledge Spunge (need spill-checker)


"Karl Timmermans" wrote:

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



"GeneM office" wrote in message
...
Hmm, finally Ended Task (after 30-40 minutes). re-opened Outlook & found
22,458 new empty records.


GeneM office August 3rd 06 06:58 PM

Limit on number of records importable into Outlook Contacts
 
Yep, one Range Name "Contacts", that's the ticket!
Worked like a charm!

Thanks, again, Karl!

--
Knowledge Spunge (need spill-checker)


"GeneM office" wrote:

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




All times are GMT +1. The time now is 01:46 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com