Here is some code, not tested, to toggle a checkbox which in turn can be used to Trigger and email of Type OPEN.
So each morning you receive your subscription reports and mindlessly click the button on each record until the report is empty
But if you want to click just one button to have all records toggled slowly enough to trigger separate email notifications, you will need to contact me directly to have a script put in place. The script runs at a rate of about 3 per second.
var bool NewToggle= not [Toggle checkbox to trigger email];
var text URL =URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_12=" & $NewToggle // jiggle the toggle checkbox field
& "&_fid_13=" & totext(Today()); // capture date emailed to filter off report
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);
