Emailing a report periodically

[hobman]

I need to find out how I can have a report with a criteria emailed to me everyday before the day ends. I need the system to run a report with a date criteria (starting date=current date & end date =current date).

The report I have is rptEmpHours. The report will have the Emp_Name, Date, Start_Time, End_Time. I need the system to generate a report based on the current date and send it to me via email. For example evrynight at 11pm [Run rptEmpHours with current date as criteria]. I am not sure if I explained this well enough but any help will be appreciated.

Thank you

 

[GingerR]

To send mail, look up SendObject.
TO automate, look up Autoexec macro, and using Windows Task Scheduler.

There are a lot of posts on all these topics here on TT.

Good luck!

g


Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244