![]() |
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) |
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? |
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? |
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. |
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