create a distibution list in Outlook from Excel Spreadsheet

[DennisT]

How do I create a distribution list from e-mail addresses in an Excel
spreadsheet? --
DennisT

 

[Brian Tillman [MVP - Outlook]]

How do I create a distribution list from e-mail addresses in an Excel
spreadsheet? --

Google is your friend.
http://www.outlook-tips.net/archives/2004/20041105.htm

 

[DennisT]

Brian, that worked if I wanted to copy and paste each cell one at a time, but
doesn't seem to work if I have a bunch. It will only paste the top cell if
more than one address are selected. It would be no real time savings. I can
copy all of the cells to the To: field but don't know how to create a
distribution list from there. Any ideas?

 

[Gordon]

Brian, that worked if I wanted to copy and paste each cell one at a time,
but
doesn't seem to work if I have a bunch. It will only paste the top cell if
more than one address are selected. It would be no real time savings. I
can
copy all of the cells to the To: field but don't know how to create a
distribution list from there. Any ideas?

If you don't want these contacts to appear in your main contact list, then a
(slightly laborious) workaround is in Outlook to create a new pst file,
import the contacts into that contact list, create a D/L, and then copy it
to your main contact list.
However, if you have THAT many contacts in this spreadsheet, it would be far
better administratively to import them to your main contact list with a
Category assigned to them rather than using a D/L.

HTH

 

[Brian Tillman [MVP - Outlook]]

Brian, that worked if I wanted to copy and paste each cell one at a time,
but
doesn't seem to work if I have a bunch.

It does work with all of the items. I tested it. I don't think the article
mentions any "To" field. You must have either one or two columns in your
spreadsheet: either the mail addresses or the names and mail addresses, one
pair per row. Open a new DL, click Select Members. Open the spreadsheet and
select the data you want to be in the spreadsheet. To be safe, select the
cells containing the name/address pairs, not the entire rows or columns.
Right-click the selection and choose Copy. Select the Select Members window
again, right-click in the "Members" field and choose Paste. Click OK.