Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
GDB026
 
Posts: n/a
Default Outlook wants an Excel named range to import contact data why?

I am trying to import into Outlook some names and addresses from Excel.. Why
does Outlook need a named range in that spread sheet?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default Outlook wants an Excel named range to import contact data why?

Because you could have multiple sheets in a workbook, Outlook needs to know
where to find the data.

To name a range, select the range and InsertNameDefine.

Alternative.......copy the worksheet with the names and addresses to a new
workbook and save as *.txt or *.csv file.

Use that file as the source file for importing to Outlook


Gord Dibben Excel MVP


On Fri, 16 Dec 2005 06:36:02 -0800, GDB026
wrote:

I am trying to import into Outlook some names and addresses from Excel.. Why
does Outlook need a named range in that spread sheet?

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
issue with excel 2003 data import LNguyen Excel Discussion (Misc queries) 0 December 8th 05 07:42 PM
Array to named range conversion... i-Zapp Excel Discussion (Misc queries) 4 October 25th 05 09:09 PM
Protecting sheet disables import of extetrnal data in Excel 2003 MNord Excel Discussion (Misc queries) 0 August 31st 05 04:34 PM
Importing data from Excel to Outlook JTRNPTNY Excel Discussion (Misc queries) 1 August 5th 05 03:35 PM
named range, data validation: list non-selected items, and new added items KR Excel Discussion (Misc queries) 1 June 24th 05 05:21 AM


All times are GMT +1. The time now is 12:45 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"