How to send email to the recipients of the previous delivery in a trigger workflow | Community
Skip to main content
J
jasonw30638826
Level 3
August 1, 2019
Solved

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

  • August 1, 2019
  • 12 replies
  • 7595 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

Show previous replies
A
AbdulZa
Level 3
August 1, 2019

Remember that batch campaign (adhoc or recurring) are stored in the BroadLogRcp table. RT triggers/messages are stored in different set of tables in Adobe ACC mart.

J
jasonw30638826Author
Level 3
August 1, 2019

Thanks everyone. This is helpful

Terms & ConditionsAccessibility statement

Loading footer...