Forgive what might be a very stupid question, but i've been trying to get this to work for a while and have had no joy. I did look around and can't actually find anything that has the answer already.
I have a job in Talend which uses a tMySQLInput to tFlowToIterate to tSendMail which worksreasonably well in producing individual emails based on data from a table in my database.
However, i need the sent email to look reasonably pretty and so i have tried to use HTML - but i am failing badly.
I have tried putting the following into the the message section on the tSendMail component, but it throws up a lot of errors (appreciate the HTML itself is rubbish, i'm just trying to get the concept right before moving on):
"<html>"+
"<h2>Statement</h2>"+
"<p>Dear row1.firstname</p>" +
"<ul>" +
"<li>Your online statement is now available" +
"<li>Please logon and check" +
"</ul>"
You have to set the encoding type to HTML, select the tSendMail component, then advanced settings menu and choose the HTML encoding. You can also refer to this great post in the Talend community.