Having problems importing data to Outlook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

terry - 09 Mar 2007 18:10 GMT

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?

Reply to this Message

Karl Timmermans - 10 Mar 2007 02:32 GMT

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

>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
[quoted text clipped - 3 lines]
> 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?

Reply to this Message