I would like to create an email distribution list using custom templates. I wish that the body of the email template will include the name of the recipient.
I created a table including the email of the recipient and the email body. for the email body I used a rich text field.
How can I add to the rich text field the name of the recipient as a variable?
I know that I can do it directly in an automation, but then I will need to create an automation for every single email which is a less classic solution.
I wish to create only one automation that will send an email to all the people in the distribution list with the relevant email body (including their name).
Thanks in advance!
- I know that I can use CONCAT() but its not dynamic enough. I wish that the user will be able add a simple custom template without complex formulas