Creating Outlook Distribution List

[Guest]

I have an Excel worksheet with over 500 e-mail addresses in one column. How
can I use this to create an Outlook distribution list (besides copy/paste
each one)?

Thanks for any assistance!

 

[Anne Troy]

File-->Import from your Outlook menu, Ed. This isn't done FROM Excel, it's
done from Outlook.
*******************
~Anne Troy

www.OfficeArticles.com

 

[Guest]

Thanks very much, Anne. Got it. Interesting that Outlook chokes if the
range includes non-contiguous cells. I wanted to include the name and e-mail
address, but they are not in adjacent columns. The only way Outlook would do
it was if my range was only the e-mail column.

Thanks again!

Ed