Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Send Mail to Multiple Address

Someone can help me to use tSendMail if i would send one mail to multiple address?
How can I put multiple address in TO BOX of tsendMail component?
Labels (2)
23 Replies
Anonymous
Not applicable
Author

use address1 space ; space address2
ex "p1@domain1.com ; p2@domain1.com ; p3@domain2.com"
Anonymous
Not applicable
Author

I have something like 14000 address in a db table or in a file delimited how can itarate???
Anonymous
Not applicable
Author

that would be a lot of semi-colons 0683p000009MAB6.png
This example uses MySQL, but you can modify it for your database.
tMySQLInput_1 -- > tFlowToIterate --> tSendMail
In tFlowToIterate uncheck "Use the default (key, value) in global variables" and create a key called "email_address", that is set to the email address field from your database input.

In the To field of tSendMail use: (String)globalMap.get("email_address")
Anonymous
Not applicable
Author

"Agt_doc Process Failed at agt_spDocReport_Cat1;
Error message : ((String)globalMap.get("tRunJob_1_ERROR_MESSAGE"))"
This is what iam using in my tsendemail Message box . I am getting an error
Syntax error on tokens, delete these tokens
How do i resolve this. Please let me know
Anonymous
Not applicable
Author

Hi wind,
Please switch "Designer" to the "Code" tab to check the compile error "Syntax error on tokens, delete these tokens".
Best regards
Sabrina
0683p000009MBI8.png
alevy
Creator III
Creator III

Try
"Agt_doc Process Failed at agt_spDocReport_Cat1;
Error message : "+((String)globalMap.get("tRunJob_1_ERROR_MESSAGE"))
Anonymous
Not applicable
Author

Here i am attaching a simple job using one tsend mail and i am getting this error.

Exception in component tSendMail_1
javax.mail.MessagingException: Exception reading response;
nested exception is:
javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake
at com.sun.mail.smtp.SMTPTransport.readServerResponse(SMTPTransport.java:1462)
at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1260)
at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:370)
at javax.mail.Service.connect(Service.java:297)
at javax.mail.Service.connect(Service.java:156)
at javax.mail.Service.connect(Service.java:105)
at javax.mail.Transport.send0(Transport.java:168)
at javax.mail.Transport.send(Transport.java:98)
at test.tpop_test_0_1.tpop_test.tSendMail_1Process(tpop_test.java:434)
at test.tpop_test_0_1.tpop_test.runJobInTOS(tpop_test.java:647)
at test.tpop_test_0_1.tpop_test.main(tpop_test.java:513)
Caused by: javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.readRecord(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.readDataRecord(Unknown Source)
at com.sun.net.ssl.internal.ssl.AppInputStream.read(Unknown Source)
at com.sun.mail.util.TraceInputStream.read(TraceInputStream.java:97)
at java.io.BufferedInputStream.fill(Unknown Source)
at java.io.BufferedInputStream.read(Unknown Source)
at com.sun.mail.util.LineInputStream.readLine(LineInputStream.java:75)
at com.sun.mail.smtp.SMTPTransport.readServerResponse(SMTPTransport.java:1440)
disconnected
... 10 more
Caused by: java.io.EOFException: SSL peer shut down incorrectly
at com.sun.net.ssl.internal.ssl.InputRecord.read(Unknown Source)
... 19 more
Anonymous
Not applicable
Author

Hi deba2193,
Caused by: javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake

How did you set your tsendmail component? The port is? Please upload your component setting screenshot into forum so that we can address your issue quickly.
Best regards
Sabrina
Anonymous
Not applicable
Author

i am having only one tSendmail component that's it....
i am not able to upload the images anyway
to :"debashis@test.com"
from: "debashis@test.com"
show sender name : checked
sender name : "debashis"
smtp host: "smail.test.com"
smtp port :300
ssl report :checked
need authentication :checked
die on error :checked
username: debashis@test.com
password: mypass