Importing contacts from Excell file

  • Thread starter Thread starter pcserra
  • Start date Start date
Status
Not open for further replies.
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?
 
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 :)
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
N Importing Google contacts from CSV file removes recipient names in autocomplete list Using Outlook 0
S Importing emails to contacts Using Outlook 3
K New to BCM - trouble importing contacts & accounts BCM (Business Contact Manager) 3
V Problem not having Contacts folder after importing emails from Yahoo. Using Outlook 0
O Importing contacts from CSV, comma delimited Using Outlook 7
wallisellener BCM 2013 importing contacts from CSV file BCM (Business Contact Manager) 8
R Exporting and importing contacts in Outlook 2007 Using Outlook 1
K Importing CSV contacts- doesnt allow me to map or move forward V 2007 Using Outlook 1
J importing contacts, data, emails and attached files from ACT 2009 BCM (Business Contact Manager) 1
C Importing emails/contacts to Outlook 2007 from Windows Mail Outlook VBA and Custom Forms 3
M having trouble importing excel data into outlook contacts BCM (Business Contact Manager) 1
R importing contacts BCM (Business Contact Manager) 1
B Importing Contacts Does Not Use Defined Custom Form in Outlook 2007 Outlook VBA and Custom Forms 1
W Primary Contacts and importing BCM (Business Contact Manager) 1
J importing contacts from excel BCM (Business Contact Manager) 3
M Importing Contacts from Act 6.0 to Outlook 2007 BCM (Business Contact Manager) 3
J Importing Business Contacts linked to Accounts BCM (Business Contact Manager) 1
HarvMan Importing PST into IMAP account Using Outlook 12
CWM330 Importing " Old Skool" Data Using Outlook 0
P Importing other e-mail accounts into Outlook Using Outlook 1
M How to setup outlook after importing old account information - Entering email account info creates with "(1)" after the account! Using Outlook 1
J Importing N2K from a different Exchange Server Using Outlook 1
J Outlook 2010 Changing events in Outlook calendar via opening file, importing CSV Using Outlook 0
O Importing Mbox - anyone out there having experience with this tool... Using Outlook 2
D Importing Outlook Categories from another domain (Exchange 2016/Outlook 2016) Using Outlook 4
B Importing business card into Outlook for SIgnature Using Outlook 1
S Importing Ribbons Not Saved Using Outlook 7
V importing appointments to non-default calendar? Using Outlook 1
Diane Poremsky Importing Lists from Excel to Outlook Using Outlook 0
B Importing Text from Excel to Outlook 2013 Calender Using Outlook 0
CWM330 Importing from Eudora Update Using Outlook 5
CWM330 Importing from Eudora Using Outlook 7
Z Importing PST files from Outlook 07 to Outlook mac Preview Using Outlook 1
Z how to make OL (2007) to use custom contact form when importing / opening .VCF? Using Outlook 1
P Importing Thunderbird email to outlook Using Outlook 2
K Importing appointment body from excel in outlook 2010 Using Outlook 1
A Importing too many emails from Gmail Using Outlook 2
J Importing to the correct calendar from Excel 2010 to Outlook 2010 Outlook VBA and Custom Forms 2
S Possible to link to ics file without importing? Using Outlook 4
L Importing Opportunities in to BCM 2013 BCM (Business Contact Manager) 0
LarryH Importing csv file to custom form/fields? Using Outlook 3
T Importing Excel 2010 data into Outlook Calendar 2010 Using Outlook 12
W Importing .pst from Outlook 2010 (Win7) to Outlook 2013 (Win8.1) Using Outlook 2
V Importing Rules in Outlook 2013 Using Outlook 2
D Importing custom fields into custom form in BCM BCM (Business Contact Manager) 1
B importing Outlook from a backup on an external hard drive Using Outlook 5
M Trouble Importing folders from Outlook 2007 to Outlook 2013 Using Outlook 12
T BCM not importing address BCM (Business Contact Manager) 1
T Importing OE6 e-mail to Outlook via Store Folder Using Outlook 9
A Trouble importing data to radio buttons Business Contact Manager 2010 (BCM) Using Outlook 2

Similar threads

Back
Top