Import contacts from excel spreadsheet

  • Thread starter Sharon @ Flag Fen
  • Start date
S

Sharon @ Flag Fen

When I try to import from an excel spreadsheet using wizard, I am only given
three fields from the excel spreadsheet. These being Company, First anme
and surname. As I only needed company and email address I tried moving this
info to be the first two columns but still get the same options up. Help
please.
 
S

Sue Mosher [MVP-Outlook]

Check that you have properly defined a named range in the spreadsheet that covers all the columns and rows that you want to import. Then in the Import and Export wizard, click the Map Custom Fields button to tell Outlook which Excel column's data to put in which Outlook field.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 

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

Similar Threads

Integrating information from Word to Excel (not mail merge) 1
Merging from an Excel file with graphics 1
How do I import a contact list from excel to Outlook? 8
How to print labels from excel 1
Create timeline with event being hyperlinks to documents on drive 1
Problem importing data from Excel into Outlook 2007 Contacts 3
Outlook 2007- import contacts from excel spreadsheet???? 3
Importing Contacts 4

Top