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
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
On Sun, 27 Feb 2005 15:35:03 -0800, "Bryan" <Br...@discussions.microsoft.com> 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
> 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
> On Sun, 27 Feb 2005 15:35:03 -0800, "Bryan" <Br...@discussions.microsoft.com> > 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.
>> 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
>> On Sun, 27 Feb 2005 15:35:03 -0800, "Bryan" <Br...@discussions.microsoft.com> >> 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
"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" <Br...@discussions.microsoft.com> > 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.
> >> 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
> >> On Sun, 27 Feb 2005 15:35:03 -0800, "Bryan" <Br...@discussions.microsoft.com> > >> 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
On Mon, 24 Oct 2005 09:09:09 -0700, "CA" <C...@discussions.microsoft.com> 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" <Br...@discussions.microsoft.com> >> 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.
>> >> 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
>> >> On Sun, 27 Feb 2005 15:35:03 -0800, "Bryan" <Br...@discussions.microsoft.com> >> >> 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, 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!!
> 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
> On Sun, 27 Feb 2005 15:35:03 -0800, "Bryan" <Br...@discussions.microsoft.com> > 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
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
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.
> 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
> On Sun, 27 Feb 2005 15:35:03 -0800, "Bryan" <Br...@discussions.microsoft.com> > 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
> 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
> On Sun, 27 Feb 2005 15:35:03 -0800, "Bryan" <Br...@discussions.microsoft.com> > 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
|
