Hi,
I have a list on which there is a field called Manager1Email and field called NextReminderDate.
If Today=NextReminderDate, a reminder email should be sent to Manager1Email.
At the end the "NextReminderDate" field should be set to NextReminderDate+14days (for the next reminder).
I have created a site workflow and the output is defined as "separate output per column" (and not collection, so that I can use the separate fields, such as Manager1Email).
But then I'm not sure how I can go over each item to send the email. ("For Each" needs a collection variable which I don't use.)
Hope you can help me with defining the workflow.
I've attached a screenshot of the workflow.
Thanks,
Shiran