Send Dynamic Emails from Config File Where Body is Stored

[Luecke_Anthony]

Hi all,

I have a large email config file similar to below:

{0} = Name
{1} = Order Number

I need to iterate through each row, and send an email using string.format method. I already know how to do this part - but I’m having a hard time figuring out how to pull the text from the body column and formatting appropriately for the email. I cannot put the body in a .txt file because it is coming into the config file from another source, and may be different each time. For example, it should look like this in the email:

Dear {0},

Thank you for your order {1}, We hope you enjoy it.

Please let us know if you have any questions or concerns.

Thanks, Anthony

[William_Blech_Sister]

Hy @Luecke_Anthony,

Please check my workflow and let me know if its what you have in mind.

DynamicEmailBody_Test.zip (29.1 KB)

Happy Automation

[Luecke_Anthony]

Thanks! This works, but was hoping to not use a .txt file with the template. Rather - the template would be pulled directly from each row. Just not sure how to get it formatted properly (in terms of paragraph spacing).

[William_Blech_Sister]

Hy @Luecke_Anthony,

I am glad I could help you

If you use the text file you can get the line breaks and its better to manage, you can setup diferent models for your data.

Please mark my answer as the solution.

Thank you