Breaking-down an Outlook Distribution List

This article describes how to produce a list that contains the email addresses in a single column.

The problem is, if a user breaks down a distribution list in Outlook or OWA to the individual members and then copies and pastes into Excel, the email addresses will all appear in the same cell.

Refer to the PDF guide attached to this Knowledge Base Article for steps to take an Outlook distribution group, break it up into the individual members, add it into Excel, and format it as a single column of email addresses. The list can then be used in your mass-emailing software.