how do I name a range of data in excel to export to outlook

[Guest]

I am trying to import a mailing list into outlook from excel and when I try
it tells me I haven't set a name for the range of data to be imported. how
do I do it?

 

[Bernard Liengme]

To name a range in Excel: select the range, type the required name (you make
up a name) in the Name box (to left of the Formula Bar) and press Enter
(important last step)
Not sure if this is what Outlook want.
happy new year

 

[Gord Dibben]

tommy

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 MS Excel MVP