Email from query date field.

[ddbrook]

I am creating a form so I can input all calendar master information so it can email a reminder on a certain date to an employee.

Example:

reportdate,email,reportfor,reportbody.
5th of month,somebody@yahoo.com,John Williams,Run AP Claims Report.

I have the email part working fine.

What I need is some help with the date field(reportdate)??
I need everything to be sent automatic on the 5th of the month to each person in my table...

Please help I am stuck and need some great ideas...

Thanks,
ddbrook

 

[bradcccs]

ddbrook,

There are a few threads on automated/scheduled emails. (and many an argument on how to avoid sending multiple times on the required day)

The basics.

You will require a form to be open at all times. (can be hidden)
The ontimer event on the form will need to check the current date.
If the date required is correct, email is sent.
** This is where the multiple sending occurs. ** If the ontimer event fires every 4 hours, it will send the email every 4 hours on the appropriate day. If it fires every 24 hours, it will not take place until 24hrs after opening the db, thus could be missed.

I have seen some people add an entry to a log on the sending of the email, and thus can first reference the last send date in the dates are correct. ie: If last send date = today, the email does not send again.

*** Other variations on same theme
Add On Open event to switchboard to check date. Requires the db to be activated on the day. If it is still open from previous day, event will not fire.


Anyhow, I will leave you to research and find the best solution for your circumstance.

Brad.

 

[ddbrook]

Thanks for the input Brad will do some testing and hopfully resolve.

ddbrook