Automatically send email based on date value

[Eric]

Is there way to send an email automatically based on a date field in a
table? Some more information about what I am trying to do. I have a
form where users enter in upcoming bids. I would like to send a
reminder email out some specified time (ie, 14 days, 7 days, and again
3 days) prior to the bid being due based on the Bid due date field in
the table. I don't want to have to go into the form and hit a button,
I would just want it to review the table perhaps every time the
database is open or even when the form is opened and send the email.
The email only needs to go to one person, so the email address can be
fixed, if that is necessary. Is this possible?

Additional information that might be helpful:

Access 2003
Db being housed on a Win 2003 server
accessed by several users using XP Pro
No Exchange server, email is on a POP server,
all clients using Outlook 2003


Thank you in advance,
Eric

 

[Jeff C]

Because of the limitations imposed by the Office Service Pack Security
updates, email will not "automatically" be sent anywhere without user input
unless you install and use 3rd party software. "Click Yes" is one example
you can read up on for that.

If your data table includes a specific date for each record from which your
"time criteria" measure for your emails, it is possible to structure queries
that will return records for 14 days, 7 days, 3 days etc, from your original
date.

You would then need to loop through each of those record sets returning the
email address your notice will be sent to.

The "SendObject" function will generate your email notice. The "Click Yes"
program or one like it will allow the email to be sent.

The "automated" cycle could come from using the windows task scheduler with
command lines specifying access macros to process your queries loosely
described above.

 

[Eric]

Because of the limitations imposed by the Office Service Pack Security
updates, email will not "automatically" be sent anywhere without user input
unless you install and use 3rd party software. "Click Yes" is one example
you can read up on for that.

If your data table includes a specific date for each record from which your
"time criteria" measure for your emails, it is possible to structure queries
that will return records for 14 days, 7 days, 3 days etc, from your original
date.

You would then need to loop through each of those record sets returning the
email address your notice will be sent to.

The "SendObject" function will generate your email notice. The "Click Yes"
program or one like it will allow the email to be sent.

The "automated" cycle could come from using the windows task scheduler with
command lines specifying access macros to process your queries loosely
described above.

Thanks Jeff for that info. Your answer is basically what I already
suspected but could not verify easily. I think that I will try to
create an button that queries upcoming bids and send it that way.
Which I believe will work.