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?


"Noel All" wrote:

You cannot do that but you could import it into the Contact folder and then
create the DL
"Sandi" wrote in message
...
I need to know how to import an Excel file into an Outlook distribution
list.
--
Sandi Russell

Casey Davison wrote:

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.
--
Brian Tillman [MVP-Outlook]