How do I send automatic e-mails from Access when a date has expri.

[Dolphin Inc.]

How do I send automatic e-mails when a date in a table field is older then
todays date (i.e. late notice e-mail)?

 

[Tim Ferguson]

How do I send automatic e-mails when a date in a table field is older
then todays date (i.e. late notice e-mail)?

Make a query and transfer the output to your email-creating program:

SELECT FullName, EMailAddress, DueDate
FROM MyTable
WHERE DueDate < DATE()
ORDER BY FullName

Hope that helps


Tim F