Importing contacts from Excell file

[pcserra]

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?

 

[Leonid S. Knyshov // SBS Expert]

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