Mailing list with user name?

[EvilArcana]

I was looking at the Generate Mailing List function, and it doesn't appear to support this, but I'd like to be able to generate a mailing list with the username in the list...so it would look like this:

sample@gmail.com username
sample2@yahoo.com otherusername
...


is this possible? mod? sql query?

--------------- Added [DATE]1460254557[/DATE] at [TIME]1460254557[/TIME] ---------------

This will be used in an opt-in/opt-out announcement list provided by my host (Dreamhost)...I'd like to add all of my existing users to the list, which will generate and send the confirmation email allowing them to opt-in or out.

After that, I'd like to somehow add the opt-in process to account creation...so when an account is created, part of that process will be to submit a form to the dreamhost script that adds a user and kicks off the opt-in/opt-out email to be sent. Any ideas?

[EvilArcana]

Bumping this request...anyone have any ideas?

[Lynne]

Why not just run a query on the user table in the database to get this?