I have created a database of the Inventory for where I work. It is used by the staff to "check out" various items from their rooms. Each item has a time that it is needed back, represented by an overdue Item column. to check out the item, they have institutional e-mail that they use as an username. I am trying to create a script that will allow me to send out an e-mail for each over-due item. it would be nice for it to be completely automatic, but it doesnt have to be, as long as it is simple and quick enough for anybody to use.
I am using FileMaker Pro 10 on a Mac G5 with low experience.