I am a little confused about how you are naming the range.
I have exported a file from Palmone to Excel 2003, modified it to match the
fields and order from Outlook 2007 and used tried naming the entire range one
name as well as letting excel name each column by it's header.
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.
"Sue Mosher [MVP-Outlook]" wrote:
Sounds like you might not have correctly set up the named range in Excel or the import mapping in Outlook. In Excel, create a single named range that covers all the data to be imported and the column headings. In Outlook's Import and Export Wizard, check the mapping between Outlook fields and those column headings before you complete the import.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx
"Scholz_Outlook_import" wrote in message ...
excel import into outlook to creates new contact per field rather than