Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm looking for a way to allow members of a society to contact all members by sending mails to one group address. At the moment this is done by using mailman but this is rather unconfortable because every group member needs to be added to the mail list. Because of this I'm looking for a way to use our existing member list (SQL Table) as the recipient list. I tried googling it but I guess I haven't tried the best keyword - or there is no such solution. One important thing: I don't want a newsletter system - everybody in the group shall be able to just email to a single address to reach everyone!

Thank you

share|improve this question

1 Answer 1

With the Majordomo list manager the list is saved in text files on the server. If this is the same with Mailman one could write a script that fills the list file from your data in your database.

Depending on the how the database is populated now I can see three scenarios depending on the level of control when creating the list: 1: full control: Create a website that lists your users and mail lists and select who goes where (not much better then the normal situation I guess) 2: website control: Assuming you populate the database from subscription to a website. When a user is added to the database, the email address is added to the list file. On deletion the opposite. 3: automatic: A script run from cron every half hour, which adds all email addresses from the database to the list file.

1 seems to me a rewrite of the mailman web interface, 2 could be cumbersome when the website is an upgradable CMS, 3 seems to me the most logical assuming that it is no problem that there is a small delay in when someone is added.

Your Important note, should always depend on the configuration of the mailinglist. In majordomo it is possible to limit who can send to the list via the config of that list. I assume this is no different with mailman.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.