Naming Ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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 File>Import, 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
(e-mail address removed)
 
You must log in or register to reply here.

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

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
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
Importing named range from another workbook 5
VBA - retrieve data on last create named range from previous inserted named range 0
No idea what "Named Ranges" are. 4
Naming a Data Range 2

Back
Top