Thought I’d share. I host a couple local group web pages and email lists. One uses Mailman and it works fine - email, one size fits all. Another one needs a more personal email approach. DH sets a limit of 100 emails per hour - so…
A MySql DB (id#, name, address, etc…) and a web page (table, tr per person…) and a button that says [ Send emails ]. Oh and all PHP. Send runs “select id from members where (condition…)” fputs -> file T1. Then exec (“split -75 T1”); Now I have 7 files: xaa, xab, xac… and I exec (“echo php send.email.php | at now”);
send.email.php does a “ls x??” and if $list exists read it ($idlist) and runs “select name, email, duesdate, aflag, etc from members where id in ($idlist)”. Then build the member specific email ($body=) Dear Robert … news of the day/month … Oh and your dues are good for the year / expired last year / … if ($aflag) add “As a member of the social committee…”
mail ($to, “NewsLetter”, $body, $headers);
After all 75 emails have been sent “unlink ($list)”
Then exec (“echo php send.email.php | at now + 65 minutes”);
So it takes 7 hours to send out all the emails - So? - You kick it off at 9 PM … next morning everybody has their monthly newsletter.