Need an easier way to extract email addresses from database

[CooperSmout]

It would be useful to have an easy way to extract email addresses for all users, and also get a list of users who pledged to a particular campaign. Currently, email addresses can be accessed through the content management system, either by (a) looking at individual pledges or (b) going into each user's profile. I've figured out a hack to convert the list of pledges (which can be copied out from the CMS) into lists of emails for each campaign, using Google Sheets, but this doesn't capture any users who haven't signed any pledges yet, which is how I've been telling people to join the mailing list. So my only way to capture people like this right now is to manually go through each user profile to get their email, which is made even worse because users aren't listed in any kind of chronological order in the CMS so I have to do it every time I send a newsletter.

Ideally there would be some way to export a list of email addresses, both for particular campaigns and across all users. This only needs to be on the admin side (not the user side), because once we have the email list I can just create a google group for those users to discuss the campaign privately.