Automatic emails.

[motherboard]

I have a database that creates tasks. When a person creates a task (in the task form) they can assign it to anyone in the contacts area. When they assign the task, they insert a "due date" for the completion of the task. I would like to create a query that can scan the form and find all overdue "due dates". If an overdue date is found, it will automatically email the person assigned the task and the person who assigned it, informing them the task is overdue.

Can this actually be done and how do you do it?

Thanks in advance

[TheShabz]

Start HERE and let us know if you come accross any more specific issues.

[motherboard]

would that be the same for Access 2003?

[TheShabz]

Should be.