Way to have the database send an email based on a date automatical

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a database with a table that has a field that contains a site "start
date" which is a date in the future sometime. In the meantime, it's status
is "Pending". When the current date is now >= to that site's Start Date, I
would like the database to send an email to me automatically (without any
user interference) reminding me to change that status to "Active."

Is there a way to do this?

Thank you in advance!
MN
 
Create an autoexec macro (run at startup automatically) if you do not already
have one and run a function that queries your table for all pending entries
=date(). if there are results from the query send you and email using the
Click to expand...
SendObject method (simplest to use for your needs). If you need more details
post back (indicate what you need help with).
--
Hope this helps,

Daniel P
 
Back
Top