On Sat, Jan 06, 2001 at 08:45:58PM -0000, John P wrote:
> I have a database of over 50,000 customer e-mails that we wish to send a
> newsletter to, probably monthly, from a RH System running Qmail. Would this
> require any special configuration changes or should a stock Qmail install
> work just fine? At the moment sending mail is working fine from the machine.
>
> This database is in MySQL. I was thinking of using PHP to retrieve and send
> each individual e-mail; is this the best way, or is there another way I
> should do it?
>
> Also, I would like to manage bouncebacks somehow - how could I track any
> failed e-mails and either remove this from the database or add them to a new
> database that I could check each time I send this e-mail.
>
> Finally, any good utilities around to help with composing MIME e-mail?
> Ideally I could construct the e-mail on a Windows PC and then copy it over
> to the RedHat box..
>
> I'm looking for resources, pointers etc.. as I can probably send all the
> things now but don't want it dying halfway through!
I would definitely recommend ezmlm, the qmail-friendly mailing list
manager. Or, rather, ezmlm-idx. Go to http://www.ezmlm.org/
There are options for MySQL interfacing, the bounce handling is very, very
good and you can set up a list that definitely only you can post to. The
creation of the message could be done on the Win machine and sent directly
to the list.
-Johan
--
Johan Almqvist
