How to send email to the recipients of the previous delivery in a trigger workflow | Community
Skip to main content
New Participant
August 1, 2019
Solved

How to send email to the recipients of the previous delivery in a trigger workflow

  • August 1, 2019
  • 12 replies
  • 7591 views

Hi,

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.

Thanks,

Jason

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jonathon_wodnicki

Hi,

Query nms:recipient, filtering on nms:broadLogRcp. For second email, this would be 'recipient exists in broadlog where delivery=first delivery and status=sent'.

Thanks,

-Jon

12 replies

New Participant
August 1, 2019

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?

Thanks,

Jason

Jonathon_wodnicki
Jonathon_wodnickiAccepted solution
New Participant
August 1, 2019

Hi,

Query nms:recipient, filtering on nms:broadLogRcp. For second email, this would be 'recipient exists in broadlog where delivery=first delivery and status=sent'.

Thanks,

-Jon