Populate a personalisation field which is not available in the DB into email

[#1]

Hi there,

I would like to populate a personalisation field (say account balance) into my email template. Unfortunately this account balance field is not available yet in the database (Recipients). Just checking is there a way to populate this account balance into the email template via the list instead of adding a new account balance field into database ?

Thanks and Regards,

[#2 · Accepted solution]

You need use a data loading (file) activity to load the data in your workflow transaction. Once it is in your workflow transaction data you can use tragetData to use in email for example below

<%= targetData.firstName %>

Hope it help, if you need help with Data loading file activity let me know.

Regards,

Ankur A.