Problem: You have a list of email addresses in an Outlook Distribution List that you want to use to invite people to a workspace.
Solution: Unfortunately, Outlook doesn't provide an easy way of seeing who's in a distribution list as a set of copy and pastable email addresses, but you can get it from an export.
-
In Outlook, find the Distribution List, and open it.
-
Click File, Save As.
-
On the Save As window, select Text Only (*.txt) in the Save As Type drop-down on the bottom.
For a short list:
-
Open the text file.
-
Copy and paste all of the content into the Email Addresses section on the Kahootz invite page.
-
Manually delete the names on each line, leaving just the email addresses.
- Then write your invite message and click the Invite button, as normal.
For longer lists:
-
Open Excel and use File, Import, to import in the saved text file. (You may need to change the "file type" selector to Text files or All files).
-
When you select the file in the previous step, you will be automatically redirected to Excel's Text Import Wizard.
-
Choose "delimited" and start at import row 5 (it'll show you how many header rows are on the page). This should give you the names and email addresses as separate columns in Excel.
-
Copy and paste just the email column into the Email Addresses section on the Kahootz invite page.
- Then write your invite message and click the Invite button, as normal.