Baffled on how to import contact list from Excel into Outlook.....

R

rebell

I go through the 'motions' in excel-

File>Import&Export>import from another program or file>Microsoft Excel
97-2003>browse & select the excel file>target 'Contacts to import to> press
the import button and I get:

Translation Error: 'File selected has no name ranges - go to the Excel page
selected and name the range of data you which to import'

Problem is that there is no definitive info in Excel's Help index to
discribe how to accomplish this task. Where may I find instructions on 'how
to name the range of data' in my contact list in Excel?

Rick
 
J

Jim Thomlinson

Seelct the range that you want to name. In the formula bar to the left of
where you enter formulas is a drop down list where you can type in a name.
Name the range something like Contacts and hit enter. You now have a named
range...
 

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

Contacts from Excel to Outlook 1
How do you name "range" of data to import/export? 2
importing contacts from excel to Outlook error 2
Import 4 Different Excel Files from One Folder 0
How do I import data into Excel from Bloomberg using Excel 2007? 1
Importing Contact List into Microsoft Outlook 2003 3
name the range of data 3
Import/Export 1

Top