excel import into outlook to creates new contact per field rather

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scholz_Outlook_import - 08 Mar 2006 11:03 GMT

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

Reply to this Message

Vince Averello [MVP-Outlook] - 08 Mar 2006 11:49 GMT

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

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

Reply to this Message

Scholz_Outlook_import - 09 Mar 2006 07:52 GMT

Thanks Vince for the rapid help. HDS

> Try exporting a contact folder from Outlook first then use that file to
> craft your import file.
>
> > excel import into outlook to creates new contact per field rather than

Reply to this Message

Sue Mosher [MVP-Outlook] - 08 Mar 2006 13:21 GMT

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.

Signature

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

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

Reply to this Message

Mark - 15 Dec 2007 19:56 GMT

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.

> 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.
>
> > excel import into outlook to creates new contact per field rather than

Reply to this Message

Brian Tillman - 17 Dec 2007 15:45 GMT

> 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.

Signature

Brian Tillman [MVP-Outlook]

Reply to this Message

Mark - 17 Dec 2007 16:31 GMT

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.

> > I am a little confused about how you are naming the range.
>
[quoted text clipped - 12 lines]
> names Outlook expects. Edit the Palm-exported CSV so that the column names
> match what Outlook expects.

Reply to this Message

Rate this thread: