Converting list of contacts into a Contact Group

Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Here’s how to convert a list of contacts into an Outlook Contact Group.

Often, the need for a Contact Group isn’t obvious from the start. We realize that we’re sending emails to the same people over and over again and they really should be in a Contact Group.

How to convert an email TO list like this:

converting list of contacts into a contact group 15853 - Converting list of contacts into a Contact Group

Into a contact group like this:

converting list of contacts into a contact group 15855 - Converting list of contacts into a Contact Group

Notice that the contacts list has existing contacts (Bruce and Fred) but the rest are email addresses alone.

At first look, it seems that you have to type each name or email address individually into the Contact Group.  There’s no obvious option to bulk add members.

converting list of contacts into a contact group 15856 - Converting list of contacts into a Contact Group

The Hidden Trick

But there is a hidden way.

Open a sent email to the group of people and copy the list of recipients.

converting list of contacts into a contact group 15857 - Converting list of contacts into a Contact Group

Choose Add Members | From Outlook Contacts.

Make sure that your main Contacts list (or whichever contact list applies) is selected.  That’s to ensure a match between the list you enter and the existing contacts.

img 5a25542ab3e56 - Converting list of contacts into a Contact Group

At the bottom of the Select Members dialog is an entry field. Paste the list of recipients from the sent email into that box:

converting list of contacts into a contact group 15860 - Converting list of contacts into a Contact Group

Press OK and the recipients will be added to the Contact Group.

You might get an error and have to tinker with the list before it’s accepted.

Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address