Yes. I've automated this before at a company that used the database in a very similar way. You can dump out the email addresses into a text file - and only the email addresses - one email address per line. Then use the Mailman command-line commands to sync up the list with the text file.
You can get the text file on a Linux box several ways: making direct ODBC calls to the database, or having the server dump it out to the Linux box running Samba. I also scanned the unsubscribe's that came into the list and passed those back in a text file for the admin to play with. Good Luck - Jon Carnes === On Mon, 2002-09-30 at 16:18, Bob Treitman wrote: > Question: Can list administrators do batch replacements of > the entire mailing list membership list? > > I'm considering using Mailman to distribute email newsletters > to an organization whose email addresses are stored in a > database. For several reasons, I don't want people (un)subscribing > from Mailman; instead, I want to make sure that their email > addresses are disabled in the database, and then the list > administrator will replace the existing Mailman list with a > completely new list generated from the database in plain text > or any other format. > > The reasons: > > 1. As people are removed from the database, I need to make sure > that their email addresses are removed from the Mailman list. > 2. I need to minimize the administrative effort, and since we > need to make the changes in the database, I would rather not > duplicate the work by editing the Mailman list. > > -- > Bob Treitman [EMAIL PROTECTED] > > > ------------------------------------------------------ > Mailman-Users mailing list > [EMAIL PROTECTED] > http://mail.python.org/mailman/listinfo/mailman-users > Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py > Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/ ------------------------------------------------------ Mailman-Users mailing list [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/