Distribution List from Excell spreadsheet

[School Help]

I have a list of email addresses (hundreds) in a spreadsheet that I want to
put in a distribution contact list called "all employees". When I create a
new distribution list in outlook 07 it will not allow me to just copy and
paste all the address from the sheet. I am guessing they have to be set up
as contacts first? I don't really have time for that. I just want to dump
them into a distribution list and be done with it so I can send emails to all
employees.

 

[Diane Poremsky {MVP}]

you can copy and paste - you just need to do it right.

http://www.outlook-tips.net/archives/2004/20041105.htm

http://www.outlook-tips.net/howto/copy_data.htm#pastedl has a screenshot of
the field you need to paste the list into.