![]() |
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. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
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) |
Ads |
#2
|
|||
|
|||
![]()
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? |
#3
|
|||
|
|||
![]()
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? |
#4
|
|||
|
|||
![]()
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. |
#5
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Limit Number of Concurrent Appointments | [email protected] | Outlook - Calandaring | 1 | August 2nd 06 10:40 PM |
limit of number of contacts | Leticia | Outlook - Using Contacts | 5 | June 14th 06 04:15 PM |
How do I limit the number of emails that are pulled into outlook? | Doug | Outlook - General Queries | 5 | April 26th 06 02:54 PM |
limit number of messages sent in 1 session | Andrew Zenz | Outlook - General Queries | 2 | February 15th 06 07:53 PM |
Is there a limit to the number of emails and contacts? | [email protected] | Outlook - Using Contacts | 1 | January 22nd 06 04:59 PM |