Note: The other languages of the website are Google-translated. Back to English
English English

How to create a contact group (distribution list) from Excel data?

Generally speaking, you can import a CSV file to Outlook contact folder, and then create a contact group from these imported contacts. But how about from an Excel workbook? This article will guide you to create a contact group (or distribution list) from an Excel workbook.

Create a contact group (distribution list) from Excel data


Create a contact group (distribution list) from Excel data

This method will guide you quickly create a contact group (distribution list) from Excel data, without applying the Import and Export Wizard in Outlook. Please do as follows:

1. Open the Excel workbook that you will create a contact group from, select the data, and press Ctrl + C keys together to copy it.

2. Shift to the People (or Contacts) view in Outlook, and click Home > New Contact Group to create a new contact group.

3. Now a Contact Group window is opening. Please click Contact Group > Add Members > From Outlook Contacts. See screenshot:

4. In the popping out Select Members dialog box, put the cursor in the Members box, press Ctrl + V keys simultaneously to paste the Excel data, and then click the OK button. See screenshot:

5. Now you return to the Contact Group window. Please type a name for the new contact group in the Name box, and then click Contact Group > Save & Close button.

So far, you have created a contact group from an Excel workbook already.

Create contact group based on senders/recipients of emails in Outlook

Normally, we can copy a sender or a recipient from an email, and then add it as a contact group member with Add Members > From Address Book, and it seems no way to add multiple emails' multiple senders or recipients into a contact group in bulk. But, with the excellent Add to Groups feature of Kutools for Outlook, you can easily add multiple emails' senders or recipients into contacts groups in Outlook with several clicks only. Click for 60-day free trial without limitation!
ad add senders recipients to contact groups 9.50

Related Articles


Kutools for Outlook - Brings 100 Advanced Features to Outlook, and Make Work Much Easier!

  • Auto CC/BCC by rules when sending email; Auto Forward Multiple Emails by custom; Auto Reply without exchange server, and more automatic features...
  • BCC Warning - show message when you try to reply all if your mail address is in the BCC list; Remind When Missing Attachments, and more remind features...
  • Reply (All) With All Attachments in the mail conversation; Reply Many Emails in seconds; Auto Add Greeting when reply; Add Date into subject...
  • Attachment Tools: Manage All Attachments in All Mails, Auto Detach, Compress All, Rename All, Save All... Quick Report, Count Selected Mails...
  • Powerful Junk Emails by custom; Remove Duplicate Mails and Contacts... Enable you to do smarter, faster and better in Outlook.
shot kutools outlook kutools tab 1180x121
shot kutools outlook kutools plus tab 1180x121
 
Comments (7)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Thank you!!! This is exactly what I was looking for. Your post is very useful. Thank you.
This comment was minimized by the moderator on the site
unfortunately this does not work for large numbers... :-(
This comment was minimized by the moderator on the site
Hi koen,
For a large number of contacts, you can save the Excel workbook as a CSV file, then apply the Import feature to save these email addresses as contacts in Outlook, and finally create a new contact group and add these new contacts as members.
This comment was minimized by the moderator on the site
thank you!
This comment was minimized by the moderator on the site
Works perfect, I added over 1000 contacts without a problem. Thanks!
This comment was minimized by the moderator on the site
Thanks a lot man, you just eased my life
This comment was minimized by the moderator on the site
How to do this in mac?
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations