Dear All,
I am struggling with the below scenario and could not find much help, appreciate if you can help me with this-
I have created an alteryx workflow to extract the values from the file - so i have all the required fields in the last tool output anchor.
now all these values need to populate the email template which is a word document.
eg -
current Alteryx output - name marks year
Alice 40 2019
Required Alteryx output is the word document -
Dear Alice,
hope you are doing well!
your year 2020 marks are 40.
Thank you
Appreciate if you could help me with this.
Thanks in advance
Solved! Go to Solution.
Thanks a lot, can i please also ask if we have multiple templates and based on condition we need to switch to different templates. How can be done?
eg - if Class = grade 1 then template 1 which is
Dear [name:A],
hope you are doing well!
your year [marks:0] marks are [year:0].
if Class = grade 2 then template 2
Dear [name:A],
hope you are doing well and done good in your exam.
your year [marks:0] marks are [year:0].
and so on for around 6 scenarios?
Thank you very much in advance
@Ekta
If your template remains the same, we can put the greeting part into a field.
Thank you for your reply, Apology for being unclear, this is just a sample template.
Actual templates are quite big(1 full page) and around 6.
Can pls help how i can pick the templates based on the condition.we can add the field name condition and based on the condition we have to choose the template to fill the value.
Like if condition is grade 1 then fill the values in template 1 and if condition is grade 2 then fill the values in template 2 and so on.
I hope i can get some help.
Thanks & Regards
@Ekta
How about this not so pretty one?
You need to add other 3 though.
@Qiu I have a question on this Qui if you can help, i am able to output word doc ,thank you for the workflow.
can guide me on -
how to change the font type,add a image at the top and save each doc with a unique name.
Thanks in advance
OMG, I just want one accept mark. you threw many questions.
1. Change Font
There are many options in Text tools.
2. Add images with Header Tool
3. Assign Record ID to each rows then generate full path and use the Group data option for output.