Dynamic HTML Table in tSendMail

[thiagoft]

Hi I'm trying to create a table in the message of tSendMail that would send the data to that specific email/list of emails from an excel file.

Each email/list of emails would receive only the records that match that email.

So far I can send the email but I have it for each record, one email and that would create hundreds of emails and some people would get multiple emails, we are just trying to combine the data for that specific email into one message.

Thank you

The data in the excel file would look like this

email    |  id   |  make   |   model  |  comment 

email1  |   1   |     a      |      XX     |    abcdef

email2  |   2   |     a      |      YY     |    abcdef

email2  |   3   |     a      |      XX     |    abcdef

email1  |   4   |     a      |      ZZ     |    abcdef

email3  |   5   |     a      |      XX     |    abcdef

The email would be:

to email1:

id   |  make   |   model  |  comment 

1   |     a      |      XX     |    abcdef

4   |     a      |      ZZ     |    abcdef

to email2:

id   |  make   |   model  |  comment 

2   |     a      |      YY     |    abcdef

3   |     a      |      XX     |    abcdef

to email3:

id   |  make   |   model  |  comment 

5   |     a      |      XX     |    abcdef

[TRF]

tfileInputExcel-->tUniqRow-->tFlowToIterate-->tfileInputExcel(filter expression on input flow to get only records matching with "rown.id" created by tFlowToIterate)-->tJavaFlex(to build the message body within a global var)
Add a 2nd iterate flow after tFlowToIterate to send 1 email per id using tSendMail
Should work (or not so far)

[thiagoft]

Thanks @TRF , I'm learning here still, but not sure how to "filter" the second tfileinputExcel.