1. Go to Analysis > Information Library.  Click Add an ad-hoc query.  Select the source view of Constituents and click OK.
  2. In the middle, click on Status and move to Include Records Where.
  3. Set the criteria to equal to Active.
  4. On the left, click on Email Addresses.  In the middle, click on email address and move to Results Fields to Display.
  5. Go to Set Save Options tab.  Enter a name and click save.