PC Review


Reply
Thread Tools Rate Thread

Importing contacts from Excell file

 
 
pcserra
Guest
Posts: n/a
 
      3rd Mar 2010
Outlook 2007 - I´m trying to import contacts from an excell file. I have 1000
contacts on the file but Outlook only imports about 114. I´ve tried several
times and not always the same contacts are imported. What could be happening?
How can I import all the files in the excell file? Is there a limit?
 
Reply With Quote
 
 
 
 
Leonid S. Knyshov // SBS Expert
Guest
Posts: n/a
 
      3rd Mar 2010
On 3/2/2010 8:22 PM, pcserra wrote:
> Outlook 2007 - I´m trying to import contacts from an excell file. I have 1000
> contacts on the file but Outlook only imports about 114. I´ve tried several
> times and not always the same contacts are imported. What could be happening?
> How can I import all the files in the excell file? Is there a limit?

There are no limits.

Are you importing into regular Outlook or are you trying to import into BCM?

This is a BCM-specific group.

Regardless, the procedure is as follows:

1. Export an existing contacts folder as a CSV file
2. Open the CSV in Excel
3. Place your cursor in the A2 cell and press Ctrl-Shift-End
4. Press Del

You now hve a blank template that Outlook will import into contacts
without issues.

Now match your data to be imported with the columns in this file, save
the file as a CSV, and import it into Outlook.
--
Leonid S. Knyshov
Crashproof Solutions
510-282-1008
Twitter: @wiseleo
http://crashproofsolutions.com
Microsoft Small Business Specialist
Please vote "helpful" if I helped you
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
new excell will not read old excell file rebecca Microsoft Excel Programming 1 29th Nov 2009 02:16 AM
Is it possible to change the normal excell icon on an excell file? Romileyrunner1 Microsoft Excel Worksheet Functions 7 8th Sep 2009 08:38 PM
Importing contact data from excell into contacts manager =?Utf-8?B?S2VubiBLaXRl?= Microsoft Outlook Contacts 0 16th Jun 2005 07:39 PM
Importing Excell Spreadsheet into Outlook Contacts =?Utf-8?B?RXRoYW4=?= Microsoft Excel Misc 5 27th May 2004 08:02 PM
Importing Contacts from Excell spreadsheet =?Utf-8?B?RXRoYW4=?= Microsoft Outlook Contacts 1 29th Jan 2004 04:20 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:14 AM.