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.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:




"School Help" School wrote in message
...
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.