tSentMail recipient in .txt file

[Ven6]

Hello

I have a problem.
I would like to know how, or have an example of a job that allows you to send mail to multiple recipients from tsend mail. the list of recipients found in a .txt file in a directory.

plz help

[Anonymous · Accepted solution]

Yes, tSendMail allows you to sent mail to multiple receipients at a time. To read the recipients from a .txt file, use tFileInputDelimited and append each recipient to a string on tJavaFlex.
tFileInputDelimited--row1-->tJavaFlex
|onsubjobok
tSendMail

on tJavaFlex:
the beginning part:
String to_recipients="";

the main part:
if(to_recipients.equals("")){
to_recipients=row1.columnName;
}else{
to_recipients=to_recipients+";"+row1.columnName;
}

the end part: put the recipients string to a global variable for used later on tSendMail:
globalMap.put("to",to_recipients)

on tSendMai, set the To filed as:
(String)globalMap.get("to")

Hope it helps you!

Regard
Shong

[Ven6]

Tks i used tfileproperties-->tSetglobalvar-->tsentmail