Give users the ability to select multiple records on the result page and send them all an email. When sending they can use a template driven from a table or type in their email. They should also have the ability to specify text or HTML.
I think this was solved, with bulk update, you can send an acknowledgment email to all updated rows. Update one of your "users" fields, and send the email to their email address within that row.
David Corpcat commented
For me the best option would be to have some form of report integration in the email notification system. Of course it would be no problem if email programs supported Iframe as you could just send the report as an iframe with parameter searching. Is there a way to put a table in the email and fill the fields?
C.j. Cross commented
Have you folks checked into integration with MailChimp or their other service, Mandrill?
How about integrate with mailchimp, constant contact, or icontact? They already have advanced reporting and all the other goodies that comes with email campaigns such as tracking open rate, bounce rate, etc.
AdminAdmin (Product Manager, Caspio) commented
We love to open up more emailing capabilities but because we let our customers import massive amount of data our concern is SPAM. If our mail servers get blacklisted due to misuse of one customer, the delivery of legitimate emails of other customers would be impacted.
Any suggestions on how we can reach a happy medium or solve the problem completely?