excel import into outlook to creates new contact per field rather than

Try exporting a contact folder from Outlook first then use that file to
craft your import file.

"Scholz_Outlook_import"
wrote in message ...
excel import into outlook to creates new contact per field rather than

Thanks Vince for the rapid help. HDS

"Vince Averello [MVP-Outlook]" wrote:

Try exporting a contact folder from Outlook first then use that file to
craft your import file.

"Scholz_Outlook_import"
wrote in message ...
excel import into outlook to creates new contact per field rather than

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

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

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]

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.

"Brian Tillman" wrote:

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]