Having problems importing data to Outlook

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

Guest

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?
 
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
 
Back
Top