automatically email a report based on date

[jon98548]

Hi, all. I have a report that lists items that are overdue. I would like this overdue report to be emailed to the responsible person on the due date. I have a macro that will handle the email portion and I am using Task Scheduler to open the database daily and I have a report that lists items overdue. I'm not sure how to go about tying everything together to be sure the responsible person gets the report at the due date and not every day past the due date. I suppose here the criteria would be where DueDate = Now(). At 30 days past DueDate, another note will be generated to the next level. Anyway, I would be grateful for any help.