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.
- Open the DL
- Go to the File, Save as menu. (This is the Office icon menu in Outlook 2007)
- 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
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 .Save End With Next Set objContact = Nothing Set o_list = Nothing End Sub
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