Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
GOH GOH is offline
external usenet poster
 
Posts: 13
Default How do you name "range" of data to import/export?

When I try to import my outlook contact list from excel file, i receive a
message asking me to name "range of data that i wan to import".......how do
you name the range?

Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default How do you name "range" of data to import/export?

hi
When I try to import my outlook contact list from excel file<

since you are importing from excel into outlook, i'm wondering if this is an
outlook question or an excel question???
but... in excel, to name a range, 2003, on the menu bar.....
insertnamedefine.....follow the wizard.
you may have to high light the range first or manually name the range.

regards
FSt1

"GOH" wrote:

When I try to import my outlook contact list from excel file, i receive a
message asking me to name "range of data that i wan to import".......how do
you name the range?

Thanks.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default How do you name "range" of data to import/export?

See Ron's site for how-to's on importing/exporting between Excel and Outlook

http://www.rondebruin.nl/mail/importcontacts.htm

Note that *.CSV files will work in 2003 and earlier and 2007.

Outlook 2007 won't import directly from Excel 2007


Gord Dibben MS Excel MVP

On Fri, 18 Sep 2009 19:56:01 -0700, GOH
wrote:

When I try to import my outlook contact list from excel file, i receive a
message asking me to name "range of data that i wan to import".......how do
you name the range?

Thanks.


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 - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
How to change Import Data source folder "permanently"? [email protected] Excel Discussion (Misc queries) 1 September 3rd 07 06:21 PM
"Import" data from old version into New? Ray Excel Discussion (Misc queries) 1 January 31st 07 08:57 PM
Import HTML data into Excel - data in "1-1" format translates to J PaulT Excel Discussion (Misc queries) 2 December 6th 06 06:28 AM
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" Dennis Excel Discussion (Misc queries) 0 July 17th 06 02:38 PM


All times are GMT +1. The time now is 02:56 AM.

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

About Us

"It's about Microsoft Excel"