Creating an email mailing list using a list of addresses in a database

view full story

http://stackoverflow.com – I'm running a club website with Drupal 7 and have a mailing list hosted offsite using GNU mailman. I'd really like to consolidate this list to the web domain. I don't care about archiving the old emails. What's the easiest way to use the list of email addresses of the accounts in the mysql database that drupal uses as the addresses to send mailing list messages to? It's a low traffic list, so I don't care about a 'digest version'. I ~could~ make a cron script to query the database nightly, save the results to /etc/postfix/virtual (or another virtual file) and run postmap, but I swear I rememb (HowTos)