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? |
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? |
All times are GMT +1. The time now is 08:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com