Mark wrote:

I am a little confused about how you are naming the range.

Is this an XLS file or a CSV file? If the former, open it in Excel, select
the entire range of addresses with your cursor, then enter a name in the
name field to the left of the formula bar. Save the spreadsheet. If the
latter, no named range is needed, but a column header wuld be a good idea.

In every case, i get the error message that says I have no named
ranges despite quite the opposite. how can i get this file to
finally import? When I imported the CSV file from Palmone's export,
it created lots of contact names with no info for them. There is no
mapping option in outlook 2007 as far as I can tell during the import.

Export a list of contacts from Outlok to a CSV so that you know what column
names Outlook expects. Edit the Palm-exported CSV so that the column names
match what Outlook expects.
--
Brian Tillman [MVP-Outlook]