View Single Post
  #7  
Old December 17th 07, 04:31 PM posted to microsoft.public.outlook.contacts
Mark
external usenet poster
 
Posts: 238
Default excel import into outlook to creates new contact per field rat

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]


Ads