G Guest Dec 10, 2004 #1 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)?
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 Dec 11, 2004 #2 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
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
