Hi all, This is more of a designing question than related to the tool. I have a SQL query whose output I need to write in a message and send it using the tSendMail component. Anyone has done something similar or can tell me how I can design this job ? One job design that comes to my mind is: tMysqlInput---row1 (Main)--->tMap---sql_data (Main)--->tFileOutDelimited But then I get stuck. I don't understand how I can read the contents of this delimited file and write it into the mail body. Can anyone help me please?
Use following tMysqlInput---row1 (Main)--->tJavaRow-->OnSubJobOk-->tPop in tJavaRow read every row and write formatted data in the form of html to context variable Use that context variable inside the body of mail. Check the post by largo-- he used html template for composing message you will get some idea from this. Thanks Vaibhav
The text in the mail appears as <html><body><table><tr><td>value1.1</td><td>value2.1</td></tr><tr><td>value1.2</td><td>value2.2</td></tr></table></body></html> Is it possible to format the mail as a HTML content mail