tSendMail + parameters in a table

One Star

tSendMail + parameters in a table

Hello everybody,
I block on a simply task.
I would like to send an email using parameters (body, subject, from, to ...) stored in a oracle table.
For example: a row with the expeditor, a row with the body...
How can I do?
Using tSendMail is a good Idea?
Thank you for reading
Bonjour à tous,
Mon problème est simple mais c'est le genre de chose que je n'ai jamais fait sous Talend il doit donc me manquer une notion je pense. Je n'ai pas trouvé de cas similaire.
Alors voilà:
Je veux envoyer un mail en utilisant des paramètres (Body, objet etc...) contenus dans une table oracle.
Une ligne de la table peut correspondre à l?expéditeur, l'autre à l'objet du mail etc...
Comment puis-je faire?
Est-ce que passer par le tSendMail est une mauvaise idée?
Merci de m'avoir lu!
Seventeen Stars

Re: tSendMail + parameters in a table

I cannot see the problem. You could read out the Oracle table with tOracleInput and use the flow fields in the tSendMail.
tOracleInput --> tFlowToIterate --> tSendMail
In the tSendMail component you can use the values from the tFlowToIterate to set email subject and body.
Or do I miss something here?

Re: tSendMail + parameters in a table

Hi qschneider,
Some screenshots of your job design will be preferred. Here is a related topic .
What's the issue you got for your current job?
Best regards
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.


Talend named a Leader.

Get your copy


Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables


How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration


APIs for Dummies

View this on-demand webinar about APIs....

Watch Now