Having problems importing data to Outlook

T

terry

I am trying to import names, addresses, etc. from an Excel spreadsheet into
Outlook (starting from Outlook), but I keep getting the error message that
the Excel spreadsheet has no "named ranges" and to "use Microsoft Excel to
name the range of data you want to import." I have looked in Help for Excel
and I cannot find anything on how to name a range. I don't know what they
are talking about. Can someone help me, please?
 
K

Karl Timmermans

You should be able to find required info by searching "Named Ranges" in
Excel help. In pre 'Excel '2007 version, you would start the process by
following the Insert --> Name option or in Excel '2007 - it's found under
Formulas.

One way to simplify your life if this is a one time event is to simply save
the worksheet as a CSV file and import that into Outlook and you won't need
to worry about "Named Ranges".

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com
 

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

Top