In The Raiser's Edge 7.94 and higher:
  1. Create a constituent query
  2. Select on the Criteria tab: 
    • Phones > Phone Number contains @
    • AND Phone Inactive equals No (Add this line to include only active emails.)
  3. Select on the Output tab: Phones > Phone Number
  4. Select the Results tab to run the query.
  5. Export the query results.
.  
In The Raiser's Edge 7.93 and earlier:
  1. Create a constituent query
  2. Select on the Criteria tab: Addresses > All Addresses > Phones > Phone Number contains @
  3. Select on the Output tab: Addresses > All Addresses > Phones > Phone Number. 
  4. Select the Results tab to run the query.
  5. Export the query results.