How can I email a set of records on a daily basis,
I have a table called items and one of the fields is called "amended_date", this is a date stamp for when the record was last altered,
there is also a field called "engineer", what I need to do is email a list of items that are 7 days old to each engineer, this needs to be triggered every morning, the idea is to remind them to return kit promptly.
regards
Morpheus