Importing contacts from Excell file

P

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?
 
L

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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top