import contacts from Excel sheet into Outlook contacts folder

G

Guest

Whenever I try to import my Excel contact list into MS Outlook, it keeps
giving me an error msg when I am in the migrattion process: " The MS Excel
file C:\........" has no named ranges. Use MS Excel to name range of data you
want to import"

Pls help..
 
S

Sue Mosher [MVP-Outlook]

You need to do what the message says: Open the list in Excel and create a
named range. Select the cells that contain the data you want to import, then
choose Insert | Name | Define.
 

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

excel97-03 into Outlook Contacts 2
merge excel 2007 into Outlook contacts list 2
Import Contacts From Excel to Outlook Not Working 3
Importing Contacts 4
Problem importing data from Excel into Outlook 2007 Contacts 3
import email addresses from Excel spreadsheet 4
import excel contact list into outlook 2
importing info from Excel into outlook contacts 2

Top