I have created my html email template in Uipath. I want to send emails to variable addressees: Dear Albert…xxx” and another email to “Dear Evelyn…xxx”.
However, have encountered issue where the two emails were addressed to “Dear Albert” . How do I send emails with variable email addressees? I have attached my excel spreadsheet and uipath file. Please help.
Example.xaml (9.8 KB) Excel_Template.xlsx (11.6 KB)
ppr
(Peter Preuss)
March 2, 2021, 11:03am
2
@Angel1524
Welcome to the forum
have a look here on an initial approach for using a template, replace placeholders by values
@ramata
welcome to the forum
have a look here as it similar regardless is implemented for WORD:
the main idea is about:
define a table with Keys and Values:
[grafik]
define the template along with the placeholders:
Dear <NAME>,
When we checked your account today we noticed that the following invoice is outstanding:
Invoice No. <INVNO> of <DATE1> for <AMOUNT>.
Please pay the outstanding amount by <DATE2>.
iterate over the table with keys and values and replace the placeholder by th…
so in your case it could have a flow like:
read excel
read template file
replace placeholders by vlaues from excel
send email
as the flow is driven by iterating over the excel rows from readin, it is done dynamicly
Thanks for your reply. In this case, can I use ‘Assign’ and ‘Replace’ to replace the placeholder? If can, how to do it, please ?
ppr
(Peter Preuss)
March 2, 2021, 11:43am
4
just go through the solutions from provided link and sencond reference to get more details:
@akritiverma316
Following Starter help is doing following:
Copy a WordFile Template and rename the copy (Invoice.docx)
A datatable is representing the readin from a excel and contains the different replacement values and place holder keys
in a for each row all placeholders will be replaced the value.
Find Word Template:
InvoiceTemplate.docx (12.9 KB)
Find XAML here:
ReplaceTemplate_ByDataTable.xaml (9.2 KB)
Kindly note: before running the xaml at your end change the paths as by your envi…
Yes, was done with a replace