Importing Excel database into Outlook Contacts says "No Named Rang

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to import contacts into Outlook from Excell Version 2003. During
the process I am getting a message stating that there are No Named Ranges. I
have gone to Insert, Name, Define but this doesn't do anything. I can't
figure out how to name the ranges. I would apprectiate any help. Thank you
 
Bryan

This is how I do it.

The basics........Your layout may differ. Instructions here are for Name and
Email address only, but adjust to suit for more columns.

First have the names and email addresses in Excel in two columns.

I set up also a third column with the names duplicated so when you Import to
Outlook you have a name for the Contact and a Display Name instead of the
email address in the To: box.

File>Save As>File Type CSV(comma delimited)(*.csv)

Click "Yes" when you get the messages about losing formats and "are you sure"?

Close the file.

Now open Outlook and File>Import/Export>Import from another file>Comma
Separated Values(Windows)>Next>File to Import(you can browse to your saved
*.csv file). Next you will be asked where to import them to. I bring mine to
"Contacts".

Follow the instructions and you will get a Map. Drag your names and addresses
to the appropriate spots on the Map

1. Name of Contact
2. Email address1
3. Display Name(if you have one by making the duplicate column mentioned
earlier). If not, the email address wil be displayed in the To: box.

Continue with the OK's until Outlook pulls all from the *.csv file(should take
only a few seconds).

Now they are in the Contacts folder, you can group them as you wish.


Gord Dibben Excel MVP
 
Thanks for the feedback Bryan.

Took me a while the first time around also. Didn't know what I wanted the
"map" to look like.


Gord
 
Thank you Bryan for asking the question, and Gord for such a clear answer. I,
too, have been working for hours to solve this riddle. Wish I'd checked here
first.
 
THANK YOU, THANK YOU, THANK YOU!! I just came to this website just by a last
resort to try to find an answer to this very same question. I was so
surprised to see someone had already posted my question AND that there was
an answer! I tried the solution and it worked beautifully, fast and simple!
I have spent weeks trying to figure this out, always with the same error as
Bryan. I posted in numerous forums and no one had an answer. I should have
come here first! This will save me tons of time with data entry with my
customer mailing list. Thank you so very much, Gord!!

Krista
 
Bryan said:
I am trying to import contacts into Outlook from Excell Version 2003. During
the process I am getting a message stating that there are No Named Ranges. I
have gone to Insert, Name, Define but this doesn't do anything. I can't
figure out how to name the ranges. I would apprectiate any help. Thank you
Click to expand...
 
Hi Guys,

I have tried it this way but all contact information appears in one line for
some reason and gets exported to the same cell within Outlook. Can you tell
me why and how to avoid it?
 
Thank you Thank you Thank you Gord. I too was going crazy trying to get Excel
to export an email list to Outlook. Naming ranges? What the heck is that all
about. Your workaround works well and should be incorporated in Excel Help.
 
Thank you!!! I still would like to figure out why I can't do it the way the
outlook program say's, but your answer worked perfect!!

Thanks again!!!
 
Hi,

I'm Carlos, from Lisbon (Portugal).

I have this Excel file wtih contacts and I would like to append it on my
Outlook Contacts.

First of all I exported my actual Outlook Contact to a Excel file, then
append new contacts at the end and then made "File > Import from file".

It seams to work, but do nothing ... nobody is imported from Excel file.

Can you help me ?

Thank you ([email protected])
 
Back
Top