Create an Outlook Distribution List from Excel

If you have a list of email addresses in an Excel worksheet and you want to easily use that list for sending emails direct from Outlook you can create Outlook distribution lists. Here's an example, many schools have parent email address lists in Excel format and need to be able to email their class lists from within Outlook. Rather than copying and pasting the emails every time from Excel, or worse still, entering them into Outlook manually, you can create separate distribution lists. Here's how.....

  1. Highlight all of the email addresses in your Excel sheet and press Ctrl C (copy)
  2. Open Outlook and go to the People View (Contacts)
  3. Click New Contact Group on the Home tab on the ribbon
  4. Type a name for the group e.g Year 9 Class List
  5. Click Add Members
  6. Choose From Outlook Contacts
  7. Right click in the Members box at the bottom of the dialog box (don't click the Members button)
  8. Choose Paste
  9. Click OK
  10. Click Save and Close
  11. To use the Distribution in Outlook to create a new email, compose a new message and start typing the name of the distribution list (it should pop up for your to choose)

Trainers Direct facilitate onsite training for businesses including schools and universities. The next time you're thinking about a staff development day, why not update your Microsoft skills? Learn tips and shortcuts from Microsoft Certified Trainers. We cover all Microsoft apps including Office 365.

Thanks for Reading

If you want to read reviews from satisfied clients go online at Google Reviews.

Thanks for reading and don't forget to get in touch if you need any training or support. We offer Excel training in Sydney, Melbourne and all major states.

Thanks

Anita Lund

Email operations@trainers-direct.com.au

https://www.trainers-direct.com.au