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

D

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)?
 
T

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)?
Click to expand...

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
 
Top