I am developing a database of licenses and agreements. These items all need to be renewed or updated on particular dates. I would like to create a script that will compare a date field with the current date and send an e-mail containing the contents of a record number field saying "This document <doc #> must be renewed." The e-mail will always be sent to a single e-mail address.
Is there an easy way of scripting this without resorting to plugins or third party apps?