create a distibution list in Outlook from Excel Spreadsheet

D

DennisT

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

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?
 
G

Gordon

DennisT said:
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?
Click to expand...


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
 
B

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.
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Distribution lists 2
How do I merge 3 distribution lists together (Outlook 2003) 1
How to make only the display name appear for a distibution list 1
Creating Distribution Lists from Contacts 1
Create a distribution list by copying names from e-mail 5
Copy addresses fr/ e-mail to new distribution list 1
Creating a Distribution List from Excel Spreadsheet 1
distribution list without names 5

Top