I made a raw addition to the script and added a custom dialog on the script right after the send email command. Also I added a re-direct comand to take user out of that particular tab and avoid duplicate emails. This way the user knows the script was run.
I was looking for something a bit more clean. Something that will make a note somewhere that in fact the script was run and the email was sent.
Something that will make a note somewhere that in fact the script was run and the email was sent.
Add a table to your database to log each time this script runs. Add steps in your script that create a new record in this database and then enters data such as the recipient's email address, the PrimaryKey of a key table, and/or other details. A TimeStamp field can auto-enter the date and time each time a new record is created in this table to log the date and time the script was run to send out that particular email.