I've set up a test db with my trial version of FMP.
I need help/instructions on how to setup a script to send emails based on certain data within the DB.
- The DB contains Licence Records.
- Each licence has a different expiry date.
- The task required is for the DB to send an email alert 30 days in advance of the licence expiry date.
The Database includes the following relevant records for the script.
- Licence Name
- Expiry Date
- Current Date.
I've managed to figure out how to auto send an email from the script, but getting this relevant information included in the email has me stumped. Any help including tutorials or scripting would be appreciated.