Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Baffled on how to import contact list from Excel into Outlook.....

I go through the 'motions' in excel-

FileImport&Exportimport from another program or fileMicrosoft Excel
97-2003browse & select the excel filetarget '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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default Baffled on how to import contact list from Excel into Outlook.....

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...
--
HTH...

Jim Thomlinson


"rebell" wrote:

I go through the 'motions' in excel-

FileImport&Exportimport from another program or fileMicrosoft Excel
97-2003browse & select the excel filetarget '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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel-Outlook Contact List [email protected] Excel Discussion (Misc queries) 1 July 9th 08 09:40 PM
importing excel contact list to outlook Katelyn Excel Discussion (Misc queries) 2 November 6th 07 06:03 PM
Can I use Outlook contact information in Excel w/o import or expo. Mark Norton Excel Discussion (Misc queries) 0 September 25th 06 03:02 AM
Outlook wants an Excel named range to import contact data why? GDB026 Excel Discussion (Misc queries) 1 December 16th 05 04:59 PM
How to import Outlook Contact data into Excel jee Excel Discussion (Misc queries) 1 October 14th 05 02:29 PM


All times are GMT +1. The time now is 06:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"