We make a program to do batch printing to files and have an example of how
to do batch printing of files and then email each file to a specific
customer.
I would recommend using PDF format over HTML, Access built in HTML exporting
is not that great.
Basically you buy our software (which is just an Access module and a few
tables that you import into your database).
You have a central set of tables that controls what report(s) go to what
customers.
You buy a PDF printer driver and we recommend using ASPMail to do emailing
(which is one DLL file that sits
next to your MDB file). So total price is:
- $199.95 for our source code version
- $30 approx. for win2pdf
- $50 approx. for aspmail
We have sample code that does exactly what you are trying to do. It keeps a
central queue of all
reports created and when they were emailed for history/auditing.
HTH,
Mark
RPT Software
http://www.rptsoftware.com
PS: Next step is to build a web based system for your customer to come to
and run their own reports.
See our other product to build this type of system. If your reports are not
complicated you might be able to
just code a solution in asp or asp.net.