First we create a query to find all of the accounts with an email address:
  1. Click the Queries button on the menu bar
  2. Click Manage Queries
  3. Select a category that you want to store this query in (Ex: Base)
  4. Click New Query under the Tasks menu
  5. Name the query “All accounts with email”
  6. Set the Starting Query to Base: All Constituents – A
  7. Set the Data Return Type to Accounts
  8. Select Match Each Criteria under the Criteria Matching field
  9. Select Account from the Browse Fields drop down menu and click Email Address
  10. Check off the box next to ‘Field has any value’
  11. Click Save And – Preview

Then, we'll create a report to display all of the email addresses:
  1. Click the Reports button on the menu bar
  2. Click Manage Reports
  3. Select a category where you’d like to store the report (Ex: System)
  4. Click New Report under the Task Menu
  5. Name the report
  6. Choose Commonly Used Fields from the Browse Fields drop down menu and click on Account Name and Email
  7. Arrange the columns into order by clicking on the middle of the field column and dragging up or down.
  8. Click Save and Run under the Task Menu
  9. Set the Category drop down menu to the category you stored your query under and set the Query drop down menu to “All accounts with email,” the query we created in Step A
  10. Under Personas Reported select All
  11. Select your Report Format at the bottom of the page
  12. Click the Submit button
The report will list each persona on a separate line. If the account has more than one persona, the account will be listed once for each persona, with the email address from each persona displayed as well.