Set Error Capture (On)
Go to layout (YourLayoutName)
Set Field (YourExpireDate ; Get(CurrentDate)
If( Get(FoundCount) >= 1
Go to first Record
Go to Record Next, Finish after last
Thanks for the response!
This script makes expired tasks as individual mails, such as:
But i requires all expired tasks could be come in One Mail.
Such as above mentioned in original thread!
Then you should replace the part with Send email with
Set Variable ( $EmailAddresses ;
isempty( $EmailAddresses ) ; EmailAddressField;
$EmailAddresses & "¶" & EmailAddressField
Then after your Loop have finished
Send Email and in the BCC set your new Variable $EmailAddresses . Reason for BCC is that if you set TO to $EmailAddresses all email address will see everyone else email address.
If you like to have information in the email like your first email, you just add an extra
Set Variable ( $Information ;
isempty( $Information ) ; "Task Expire Date: " & YourDateField & "¶" & "Task: " & YourTaskID;
$Information & "¶" & "Task Expire Date: " & YourDateField & "¶" & "Task: " & YourTaskID