insert table in email

[Anonymous]

I want to send email though talend in which i want to insert a table. This table comes from data processing activity in which i join two mySQL tables and sort the data based on a column. How can i send this result in email body with a fixed salutation and signature?

I have read https://community.talend.com/t5/Design-and-Development/resolved-need-to-send-the-data-of-tLogRow-to-...

and 

https://community.talend.com/t5/Design-and-Development/resolved-Sending-query-result-by-mail/td-p/10...

however these examples are for sending results directly from DB without any processing. Below is what i have done so far.

[Anonymous]

Not sure why it isn't working. here is my revised workflow desgin

Here is tJavarow code.

Error message
Execution failed : Job compile errors 
At least job "test" has a compile errors, please fix and export again.
Error Line: 1457
Detail Message: Status cannot be resolved or is not a field
There may be some other errors caused by JVM compatibility. Make sure your JVM setup is similar to the studio.

[TRF]

Click on Code tab, check for errors in source code using red rectangle(s) on the right side

[cterenzi]

---

Detail Message: Status cannot be resolved or is not a field

---

This usually indicates a reference to a flow variable that's not defined.  Check the spelling/capitalization of the tMap output field you're referencing.