i will need to run the process to check on the “DAILY REQUEST STATUS” row which is still dont have “SENT”.
and proceed to send email for each of the row that meet the condition.
But the row sequence is not in order , it may skip one row especially for revision case.
How can i get the correct row index and update the status to be " SENT" if there is no error pop up?
Hope above clarifies.