#1   Report Post  
Old January 27th 05, 10:41 PM
Donna In Denver
 
Posts: n/a
Default Naming Ranges

Hi! I need help! I am trying to import a big list of names, address &
emails from Excel to Outlook. I'm having trouble figuring out how to
correctly name ranges so that it imports into Outlook correctly. Anyone have
experience with this?

  #2   Report Post  
Old January 28th 05, 07:48 AM
Nick Hodge
 
Posts: n/a
Default

Donna

Simply select your data in Excel and in the name box (Just above the grid to
the left, normally shows an address in it), enter the text "Database", (no
quotes) and press enter. If you do this correctly Database will now show in
the name box and you will be able to click on any cell, select database from
the name drop down and it will select your data.

save and close Excel

Now open outlook, go to FileImport, etc, etc and when it asks for a named
range select Database, map the fields and voila!

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Donna In Denver" <Donna In
wrote in
message ...
Hi! I need help! I am trying to import a big list of names, address &
emails from Excel to Outlook. I'm having trouble figuring out how to
correctly name ranges so that it imports into Outlook correctly. Anyone
have
experience with this?





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
Indirect and dynamic ranges Sam Excel Worksheet Functions 3 January 24th 05 07:01 AM
Poor Workbook Performance due to Named Ranges jrusso Excel Discussion (Misc queries) 2 January 10th 05 11:39 PM
Problem with graph ranges No Such Luck Charts and Charting in Excel 6 December 3rd 04 01:09 PM
compare unique identifiers in multiple ranges bawilli_91125 Charts and Charting in Excel 1 November 30th 04 06:34 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM


All times are GMT +1. The time now is 07:31 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017