I'm looking for something similair but havent found it yet. I'd like an auto-mailer that, once a week, would;
1) query a table for all entries made in the last 7 days, and select only 2 fields of the data, and then
2) query a second table for email addresses to send the info pulled from the first query.
This is basically a table of names and email addresses (or mailing list), and ideally it would send all the weeks entries to the members automatically. If anyone knows of a script to do this I'd appreciate taking a look at it.