Script to send email before a particular date

[richardbabley]

Hello,

I'm trying to set up a training database which will send an email reminder to users 90 days before their training expires, but I'm having trouble writing a script!

I would like the email to send to Personnel Records::Email and for it to be sent 90 days before Training::Expires.

Could someone give me a hand?

Thank you!

Personnel (local).fmp12.zip

[eos]

I'm trying to set up a training database which will send an email reminder to users 90 days before their training expires, but I'm having trouble writing a script!

I would like the email to send to Personnel Records::Email and for it to be sent 90 days before Training::Expires.

Try this one. You might want to add a flag field like “Reminder sent” to the Training table and set it in the script.

Personnel (local)_withMailScript.fmp12.zip

[richardbabley]

Thank you so much!

Could you please tell me where you entered the script?

[eos]

Thank you so much!

Could you please tell me where you entered the script?

It's called in the OnOpenFirstWindow script.

[richardbabley]

I'm probably being very stupid here, but how do you get to the OnOpenFirstWindow script?

[eos]

See here:

[richardbabley]

Got it. Thanks very much!