excel import into outlook to creates new contact per field rather

  • Thread starter Thread starter Guest
  • Start date Start date
Try exporting a contact folder from Outlook first then use that file to
craft your import file.
 
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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
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.
 
Mark said:
I am a little confused about how you are naming the range.
Click to expand...

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.
Click to expand...

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.
 
Thanks for trying to help. I had done the first recommendation already to no
avail.

I ended up having to adjust all of the columns to match up to the outlook
output, replace all "," with ";" and save as a CSV. Then I imported it and
mapped the columns that it still didn't recognize. So I am updated and hope
that if someone else has this problem, this solution helps them too.
 
Back
Top