Send bulk email using tsendmail component

[Anonymous]

Dear sanvaibhav,
I have a job requirement in which i have to take email ids from the excel sheet and send the email notification to that email ids.
excel sheet is containing list of email ids.
Regards,
Csah

[Anonymous]

Hi,
tfileInputExcel-->tjavarow-->titeratetoflow-->tpop
Read your column containing excel file
Create context variable email_id
Assign value of incoming row to context variable in tjavarow
use context variable in tpop for mail Id
Try using similar logic/concept.
Vaibhav

[Anonymous]

hi,
have also a look at tSendMail (some procedure as described by sanvaibhav : iterate is the key word )
https://help.talend.com/search/all?query=tSendMail&content-lang=en
regards
laurent

[Anonymous]

Hi sanvaibhav,
could you show me an example for the same..

Regards,
Csah

[Anonymous]

Hi,
Following is example itself - tfileInputExcel-->tjavarow-->titeratetoflow-->tpop
Read your column containing excel file
Create context variable email_id
Assign value of incoming row to context variable in tjavarow
use context variable in tpop for mail Id
Try implementing it and whatever problem you face, pl let us know.
Try implementing solution from following example. You will understand the basic of how to use iterate...
https://help.talend.com/search/all?query=tIterateToFlow&content-lang=en
This will help you
Vaibhav

[Anonymous]

Hi Vaibhav,
i am able to send the email notification to the recipient using the below logic
tfilieinputexcel---------> tflowtoiterate----->tsendmail

but i want to send the html email template in the body of the email
Please suggest...
Regards,
Csah

[Anonymous]

Hi,
Please check the discussion at http://community.talend.com:80/t5/Design-and-Development/How-to-inject-html-code-into-message-of-tSe....
largouwalid implemented message with image and other formatting including html template...
Vaibhav

[Anonymous]

Hi Vaibhav,

Can you help me regarding how to get the log file of the talend job after exporting it.
means what we are getting in the console tab.

Regards,
Csah

[Anonymous]

Whatever you get on console you can redirect it to the job, but need to do some small java coding...
pl check the blog - http://helicaltech.com/redirecting-talend-console-logs/
Code is simple
java.io.File logFile = new java.io.File(?_logs/?+projectName+?.log?);
java.io.PrintStream ps = new java.io.PrintStream(new java.io.FileOutputStream(logFile));
System.setOut(ps);
System.setErr(ps)
This writes logs as well as info from console to file.
Thanks
Vaibhav

[Anonymous]

Hi Vaibhav,

Could you tell me where to connect the tjava with the which component as per my job

Regards
Csah