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.

Re: Distribution List from Excell spreadsheet by Diane

Diane
Fri May 02 09:26:10 PDT 2008

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:
dailytips-subscribe-request@lists.outlooktips.net

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM



"School Help" <School Help@discussions.microsoft.com> wrote in message
news:15B5EDD0-6041-4CAA-85EF-DEE320675366@microsoft.com...
> 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.