How to send multiple emails containing data using Talend

Question

In MS SQL database I have a table with User_ID, User_Name, and User_Email. Using the below Job, I am able to send a single mail to any of the users:

But, I am not able to understand how to tell Talend to send emails to all the users present in the table.

Answer 1

Its pretty simple you know. All you need to do is add a tFlowToIterate component between tMSSInput and tSendMail components. Rest all will be handled by the tFlowToIterate component automatically. Cheers!!

Hope this will help!

Join the Talend course today to know more about and become expert.

Thanks.