tsendmail send same mail manytimes

[Anonymous]

I'm trying to join two tables and send the result of the join filtered in a tsendmail, Job below :

What I want to do is to send the rows collected in the same mail

My problems is that it's sending the same row many times.

Can you help solving this problem ?

[vapukov]

Hi

the simplest way - store all in csv file and run tsendmail as separate subjob connected by OnSubjobOk trigger with attachments

[Anonymous]

Is it possible to clean the csv file each time the email is sent so we can send new rows after each execution ?

[vapukov]

of course, just add after tSendMail -> OnSubJobOk -> tFileDelete

[Anonymous]

Hi,

You can use tjavaflex just before tSendmail and save you rows from table in array and then using global variable you can print in under "Message box" in tSendmail component.

Regards,

Rahul

[Anonymous]

@rahuljan  I'm using TjavaRow to read the output that I'm injecting in an HTML Code and then using the global variable to send the email.

Can I  declare the array in the same place and using it afterward or I need to move the code to the tjavaflex

[Anonymous]

@vapukov I'm a bit confused, can you walk me through your suggestion?

[vapukov]

---

@SwanGhazi wrote:

@vapukov I'm a bit confused, can you walk me through your suggestion?

---

what do you mean?

create file tFileOutputDelimited 

send file - tSendMail

delete file - tFileDelete

[Anonymous]

Yes you to save everything in array before.

[Anonymous]

@vapukov  I should create that file before tjavaRow right ?