The general procedure is to:
1. Output a report to a certain file format (HTML or txt probably)
2. Read that file back in while constructing the email
or
you could send the report as an attachment in PDF or another format
Checkout our email module if you want to just plug in a solution that
handles all kinds of emailing needs.
It would let you do something like:
- setup and email template with the to, from, cc, bcc, subject and body how
you like
- at runtime substitute the output of a report to a variable in the body
- run the emails for all your customers (send one email to each with
appropriate report data and/or attachments)
When you say automated I'm not sure if you just want code that cranks out a
few hundred emails (easy) or you want the
emails to shoot off at a certain day/time (usually involves running the
database via windows scheduler or something of that nature)
HTH,
Mark
RPT Software
http://www.rptsoftware.com