If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
create a distibution list in Outlook from Excel Spreadsheet
How do I create a distribution list from e-mail addresses in an Excel
spreadsheet? -- DennisT |
#2
|
|||
|
|||
create a distibution list in Outlook from Excel Spreadsheet
"DennisT" wrote in message
... 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 -- Brian Tillman [MVP-Outlook] |
#3
|
|||
|
|||
create a distibution list in Outlook from Excel Spreadsheet
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? -- DennisT "DennisT" wrote: How do I create a distribution list from e-mail addresses in an Excel spreadsheet? -- DennisT |
#4
|
|||
|
|||
create a distibution list in Outlook from Excel Spreadsheet
"DennisT" wrote in message
... 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 -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s) |
#5
|
|||
|
|||
create a distibution list in Outlook from Excel Spreadsheet
"DennisT" wrote in message
... 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. -- Brian Tillman [MVP-Outlook] |
Thread Tools | |
Display Modes | |
|
|