Create a Contact Group from selected Contacts

When you create a new Contact Group (also known as a Distribution List), Outlook doesn’t offer you much flexibility when it comes to finding and selecting contacts via the “Add Members” dialog.

For instance, there is no way to quickly add several people belonging to the same company or Category to your Contact Group.

The VBA macro from this article allows you to select your members directly from your Contacts folder. This enables you to first sort or filter your Contacts folder by a specific field such by Company or Category and/or do a search query and thus select your contact group members more conveniently.


AddContactsToDL macro

The AddContactsToDL macro allows you to directly create a add your currently selected contacts to a Contact Group. With this method you can bypass the inflexible “Add Members” dialog which doesn’t allow any filtering or sorting.

When executing the macro, you’ll be prompted to name your Contact Group. If you already have a Contact Group with that name, you’ll be asked if the macro should add the currently selected Contacts as members to the already existing Contact Group or if it should create a new one with the same name.

You can even quickly add selected contacts to an existing Contact Group.
You can even quickly add selected contacts to an existing Contact Group.

Quick Install

Use the following instructions to configure the macro in Outlook;

  1. Download this code-file (add2dl.zip) or copy the code below.
  2. Open the VBA Editor (keyboard shortcut ALT+F11)
  3. Extract the zip-file and import the Add2DL.bas file via File-> Import…
    If you copied the code, paste it into a new module.
  4. Add a button for easy access to the macro.
  5. Sign your code.

Add a button to the Ribbon or the QAT to execute the Add2DL macro
Add a button to the Ribbon or the QAT to execute the Add2DL macro.

Macro Code

The following code is contained in the zip-file referenced in the Quick Install. You can use the code below for review or manual installation.


Click in the area above and press CTR+A to select all. Press CTRL+C to copy the code.