Creating Distribution Lists from Address Lists

We get many questions on how to create contact groups (distribution lists) from messages in a folder, from addresses on a message, from addresses in another distribution group, or from lists of addresses in Excel or CSV files.

As long as the addresses are one address per line or semi-colon delimited, you can use any list to create a contact group.

Note: Beginning with Outlook 2010, Microsoft changed the name of Distribution lists to Contact Groups. Unless otherwise noted, all information on this page works in all versions of Outlook, for both Distribution lists and Contact Groups.

See Page 2 for instructions to Split a large Contact Group into smaller Contact Groups and utilities that can make it easier to use distribution lists.

Use the Sender Addresses from Messages in a Folder

This is an all too common question:

"I have several hundred emails archived in Outlook and I want to create a mass distribution list without opening each email and pasting the addresses into my address book. Is there a simple, fast way capture all of the addresses at once?"

Rather than copying and pasting addresses, just right click on the sender's address, either in the preview pane or open message, and choose "Add to contacts". While this is still much too slow if you have a large number of emails, there are several add-ins that will capture the addresses and create contact records for you. We have a VBA sample that can create contacts using sender's addresses or look for these utilities at Data Entry and Updating Tools for Microsoft Outlook . Outlook should warn you if you are creating duplicates, but if not, there are duplicate contact remover utilities at Remove Duplicate Contacts from Microsoft Outlook .

Once you have the list of addresses, you can convert it to a distribution list one of two ways.

My preferred method is a dynamic DL. Assign categories to contacts then group by category and select the category, then choose Actions, New Message. When you edit contacts, the DL is always updated and adding or removing contacts from the group is as easy as changing the category. If you're saving all of the addresses in your main contacts folder, sort by the Modified date field, select all of the new contacts and right click, choosing Categories... and enter a category. We have a tutorial at Using Categories for Dynamic Distribution Lists

If you prefer using the distribution list form (Contact group in Outlook 2010), you won't need to create contacts for the senders. You can get the addresses from the messages using a custom view.

Create a custom table view that shows just the email address field
Select all of the addresses and Copy

After getting the list of addresses, you can paste them into a Contact Group, Notepad, Excel, or other applications that accept paste. If you paste them into Word or an Outlook message or Notes field, you need to use Paste Special, as Text.

To paste into a Contact Group:

Click on Select Members (Add Members > From Address Book in Outlook 2010)
Paste the addresses into the field to the right of the Members button near the bottom of the dialog
Click OK and save your DL

The video tutorial below shows how to do this is Outlook 2010.

See Adding Extended MAPI Fields to Microsoft Outlook for instructions to add the from address field to the view.

Creating and copying from a table view is a cool trick that can be used in place of export to create contact lists for use outside of Outlook, including as a data source for a mail merge when your Outlook and Word versions are mismatched.

Because only the fields used in the view are copied, you can easily control the data you are copying. Note that the copied data contains OLE information and if the other program supports OLE, you may paste the data as contacts, not plain text data. If this happens, you'll need to paste the copied records into notepad then select all and copy to have plain text data.

Create a Contact Group from Messages Video Tutorial

This video tutorial shows how to create a distribution list using the From addresses on messages in a folder. The CFG required to do this is at Adding Extended MAPI Fields to Outlook

Create a Contact Group from addresses a message was sent to

A video tutorial and written instructions to create a distribution list using the addresses on an email message is at Tutorial to Create a Distribution List from a List of Addresses

The tutorial shows how to get addresses from a message header, such as the one shown below, and use them to create a contact group.