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