I'd like to create a automate trigger that send out three series of emails to the same recipients. For instance. First email A send out today to 100 recipients. 7 days later, send email B with different content to the same recipients as the first email, then 7 days later, send email C to the same recipients of the second delivery. I am having difficulty to find a way to query the recipients of the previous delivery in the automated trigger. If anyone has built the similar workflow, can you please share.
I see. Are you trying to do this all in one workflow? Will it be easier to have one workflow for each deployment.
1st workflow will be used for 1st email sent to the new recipients who just joined. 2nd workflow will be used to send the 2nd email 7 days after the 1st email. 3rd workflow will be used to send the 3rd email 7 days after the 2nd email is sent?
It’s the same, and’ed to this query, though with ‘not exists’ instead of ‘exists’ and with the second delivery instead of the first. You don’t need to do it here if the workflow runs on a daily cadence, since it’s implied by the 7 day check on first delivery. Might come up later on a variant though.
Forgot to mention, if this is automated the delivery should also do an inverse filter on itself- where recipient doesn‘t exist in broadlog for this delivery. Otherwise recipients will be spammed until the workflow stops.
Thanks Jon. This works. I will also need to add delivery create date = 7 days ago which is the date the first email sent.
Do you know what's the difference between delivery create date and event date under nms:broadLogRcp?