There are ways to set up a script so that it is performed once a day.
That script can perform a find for all records where a date in a date field matches specified criteria such as the date equals or is greater than today's date.
The script can then loop through the found set of records and use send mail to send out the emails.
The easiest way to schedule a script for daily execution is with FileMaker Server, but there are ways to do this with just FileMaker Pro as well.
Thanks for that. Where would be find the script, sorry we are newbies! and we would like to just stick to Filemaker Pro.
There is no one script for this. The details depend on the design of your database and whether you use an email client or SMTP server to send out the emails.
What parts of this process are ones that you need assistance with?
Scheduling the script to take place on a regular schedule?
Scripting the find?
Scripting the email process?
Scripting in general?
To be honest we use iCal at the moment and so we wanted something as simple as that, but integrated into our database. We thought there, but be a date field you could put in and say send this document on this day. Maybe expecting to much of Filemaker?