Dynamically Generated Lists in an Email

[Alex11]

We'd like to send a daily (internal) company wide email listing everyone's work anniversary that day. We don't have any issues automating an email send to all employees each day, but having trouble with the email content itself. Is there a way to generate/update that email content automatically each day?

We have all employees as Contacts in Marketo and a work anniversary as a date field for each. The subscribe to list option doesn't work since it only sends a link rather than generating the list within the email itself.

[SanfordWhiteman · Accepted solution]

You can’t include data from multiple Marketo People in a single email using only built-in functionality.

If you can pull the aggregate data using a webhook or push it via REST API, that would work. Basically mirroring that day’s anniversaries onto every employee’s Person record.