ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Creating Outlook Distribution List (https://www.excelbanter.com/excel-discussion-misc-queries/35865-creating-outlook-distribution-list.html)

Ed Kura

Creating Outlook Distribution List
 
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!
--
Ed Kura

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


"Ed Kura" wrote in message
...
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!
--
Ed Kura




Ed Kura

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
--
Ed Kura


"Anne Troy" wrote:

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

www.OfficeArticles.com


"Ed Kura" wrote in message
...
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!
--
Ed Kura






All times are GMT +1. The time now is 01:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com