Create Individual Contacts from a Distribution List

Last reviewed on December 30, 2013   —  2 comments

There are two ways to convert a contact group to individual contacts: Create a list of the Contact Group members and import them into Contacts or use a macro to create the contacts.

Use this method to save the names and addresses of contact group (distribution list) members in a text file to use in other programs or to import into Outlook Contacts.

  1. Open the DL
  2. Go to the File, Save as menu. (This is the Office icon menu in Outlook 2007)
  3. Choose to save as a *.txt file.

This saves the DL as a text file. You can edit it in Notepad or Excel and import it, or forward it to other users.

In this tutorial, I’m extracting the names from a DL so I can import them into Outlook as individual Contacts.

Create Contacts from Contact Groups using VBA

See How to use Outlook’s VBA Editor

You need the GetCurrentItem function from Outlook VBA: work with open item or selected item. This allows you to run the macro either by selecting the Contact Group or from an open Contact Group.

' Based on a macro by Valk Beekman.
Sub CreateContactsfromDL()
Dim o_list As Object

Dim objContact As Outlook.ContactItem

' set your category here.
t_cat = "From DL"

' Current object and should be the distributionlist
Set o_list = GetCurrentItem()

For i = 1 To o_list.MemberCount
 ' Create separate contacts
Set objContact = Application.CreateItem(olContactItem)
With objContact
        .Email1Address = o_list.GetMember(i).Address
        .FullName = o_list.GetMember(i)
        .Categories = t_cat
End With


Set objContact = Nothing
Set o_list = Nothing
End Sub

More Information

Create a Distribution List from a list of addresses – Recipients can use this method to convert the list to a new DL or to add the members to an existing DL.
Create a text file containing the names and email addresses in a DL – This tutorial uses the Forward as Internet format (vCard) method.
Create a list of Contact Group members and their phone numbers VBA Sample
Add a Category to Contacts in a Contact Group (DL) VBA sample

Written by

Diane Poremsky
A Microsoft Outlook Most Valuable Professional (MVP) since 1999, Diane is the author of several books, including Outlook 2013 Absolute Beginners Book. She also created video training CDs and online training classes for Microsoft Outlook. You can find her helping people online in Outlook Forums as well as in the Microsoft Answers and TechNet forums.

Please post long or more complicated questions at Outlookforums.

2 responses to “Create Individual Contacts from a Distribution List”

  1. Robyn

    This is too messy when all a user is likely to want is a quick export of names and email addresses from a contact group. Why are the contact group details saved as PDLs instead of in the same way as other contacts? Why not have this conversion to individual contacts as an option just as Export is an option?

Leave a Reply

If the Post Coment button disappears, press your Tab key.