A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Limit on number of records importable into Outlook Contacts



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old August 2nd 06, 08:43 PM posted to microsoft.public.outlook.contacts
GeneM office
external usenet poster
 
Posts: 9
Default 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)
Ads
  #2  
Old August 2nd 06, 09:05 PM posted to microsoft.public.outlook.contacts
GeneM office
external usenet poster
 
Posts: 9
Default 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?


  #3  
Old August 2nd 06, 11:29 PM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 789
Default 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?




  #4  
Old August 3rd 06, 12:10 PM posted to microsoft.public.outlook.contacts
GeneM office
external usenet poster
 
Posts: 9
Default 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.

  #5  
Old August 3rd 06, 06:58 PM posted to microsoft.public.outlook.contacts
GeneM office
external usenet poster
 
Posts: 9
Default 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


 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
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


All times are GMT +1. The time now is 08:10 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-2025 Outlook Banter.
The comments are property of their posters.