View Full Version : auto report then email


bmcrae
12-04-2002, 11:17 AM
Hi,
Is this possible with no user operator intervention?

I would like to generate a report automatically, twice daily. The first report would list all records with a [completed date] between 09:01 h and 16:00 h. The second report generates a report between 16:01 h and 09:00 h.

I would then like to email each report to one address.

Thanks,
Brett

pdx_man
12-04-2002, 02:49 PM
Yes

Use the Timer event on a form to check the time --> Now() function.
Use the SendObject action to email the report
Create the reports based on a query with the specified time criteria.