To post as a guest, your comment is unpublished.· 4 months agoHi 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.
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.
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.
Recommended Productivity Tools
- Complicated and repeated operations can be done a one-time processing in seconds.
- Forward multiple emails individually with one-click, and auto forward by rules.
- Auto CC/BCC every sending email and easy for customizing rules, and auto reply without requiring exchange server.
- Powerful junk emails filter, remove duplicate emails, reply with attachment, bunch of one-click operations, and so on...
- 60-day unlimited free trial. 60-day money back guarantee. 2 years free upgrade and support. Buy once, use forever.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 1 years agounfortunately this does not work for large numbers... :-(
To post as a guest, your comment is unpublished.· 1 years agoThank you!!! This is exactly what I was looking for. Your post is very useful. Thank you.