How do I import an Excel file into an Outlook distribution list?

[Sandi]

I need to know how to import an Excel file into an Outlook distribution list.

 

[Noel All]

You cannot do that but you could import it into the Contact folder and then
create the DL

 

[Casey Davison]

Im trying to import from Excel into Outlook folder and it won't work. We
just recently upgraded to Office 2007. I'm doing it the same way I did it
before but it doesn't work. Just appears to be importing then gives me a
Microsft Error and shuts down.

I did try to go in and name the ranges but then get an ODBC error that too
many items have been defined. It's the same amount of contacts I had before
and it was working fine, I just need to update the list.

Any suggestions?

 

[Casey Davison]

Yes I'm trying to import it into a contact folder. Sorry, I wasn't clear.

 

[Brian Tillman]

Im trying to import from Excel into Outlook folder and it won't work.
We just recently upgraded to Office 2007. I'm doing it the same way
I did it before but it doesn't work. Just appears to be importing
then gives me a Microsft Error and shuts down.

I did try to go in and name the ranges but then get an ODBC error
that too many items have been defined. It's the same amount of
contacts I had before and it was working fine, I just need to update
the list.

Save the spreadsheet as a CSV and you may have more suggess. No named
ranges needed.

You can't import into a DL.