Importing Excel database into Outlook Contacts says "No Named Rang
 

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.

FileSave AsFile 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 FileImport/ExportImport from another fileComma
Separated Values(Windows)NextFile 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

On Sun, 27 Feb 2005 15:35:03 -0800, "Bryan"
wrote:

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

Thank you, it worked great. I spent hours trying to figure it out.

"Gord Dibben" wrote:

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.

FileSave AsFile 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 FileImport/ExportImport from another fileComma
Separated Values(Windows)NextFile 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

On Sun, 27 Feb 2005 15:35:03 -0800, "Bryan"
wrote:

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

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

On Sun, 27 Feb 2005 16:41:01 -0800, "Bryan"
wrote:

Thank you, it worked great. I spent hours trying to figure it out.

"Gord Dibben" wrote:

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.

FileSave AsFile 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 FileImport/ExportImport from another fileComma
Separated Values(Windows)NextFile 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

On Sun, 27 Feb 2005 15:35:03 -0800, "Bryan"
wrote:

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

Importing Excel database into Outlook Contacts says "No Named
 

I also found your instructions extremely helpful.

Thanks a Million!
CA

"Gord Dibben" wrote:

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

On Sun, 27 Feb 2005 16:41:01 -0800, "Bryan"
wrote:

Thank you, it worked great. I spent hours trying to figure it out.

"Gord Dibben" wrote:

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.

FileSave AsFile 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 FileImport/ExportImport from another fileComma
Separated Values(Windows)NextFile 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

On Sun, 27 Feb 2005 15:35:03 -0800, "Bryan"
wrote:

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

Importing Excel database into Outlook Contacts says "No Named
 

Thanks for the feedback CA.


Gord

On Mon, 24 Oct 2005 09:09:09 -0700, "CA" wrote:

I also found your instructions extremely helpful.

Thanks a Million!
CA

"Gord Dibben" wrote:

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

On Sun, 27 Feb 2005 16:41:01 -0800, "Bryan"
wrote:

Thank you, it worked great. I spent hours trying to figure it out.

"Gord Dibben" wrote:

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.

FileSave AsFile 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 FileImport/ExportImport from another fileComma
Separated Values(Windows)NextFile 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

On Sun, 27 Feb 2005 15:35:03 -0800, "Bryan"
wrote:

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

Importing Excel database into Outlook Contacts says "No Named Rang
 

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


"Bryan" wrote:

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

Importing Excel database into Outlook Contacts says "No Named
 

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

"Gord Dibben" wrote:

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.

FileSave AsFile 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 FileImport/ExportImport from another fileComma
Separated Values(Windows)NextFile 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

On Sun, 27 Feb 2005 15:35:03 -0800, "Bryan"
wrote:

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

Importing Excel database into Outlook Contacts says "No Named Rang
 

"Bryan" wrote:

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

Importing Excel database into Outlook Contacts says "No Named
 

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?

"Pat Sloan" wrote:

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


"Bryan" wrote:

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

Importing Excel database into Outlook Contacts says "No Named
 

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.


"Gord Dibben" wrote:

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.

FileSave AsFile 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 FileImport/ExportImport from another fileComma
Separated Values(Windows)NextFile 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

On Sun, 27 Feb 2005 15:35:03 -0800, "Bryan"
wrote:

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

Importing Excel database into Outlook Contacts says "No Named
 

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


"Gord Dibben" wrote:

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.

FileSave AsFile 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 FileImport/ExportImport from another fileComma
Separated Values(Windows)NextFile 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

On Sun, 27 Feb 2005 15:35:03 -0800, "Bryan"
wrote:

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

Importing Excel database into Outlook Contacts says "No Named
 

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 )

Importing Excel database into Outlook Contacts says "No Named
 

See
http://www.rondebruin.nl/mail/importcontacts.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Carlos Stumpo" wrote in message ...
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 )