One Star

How to query database, and send results as an email attachment?

I would like to query a MySQL database with a select statement, send results to an Excel spreadsheet, and email that file.
I tried tMysqlInput --> tFileOutputExcel --> tSendMail, but that did not work.
How can I do this?
1 REPLY
Seventeen Stars

Re: How to query database, and send results as an email attachment?

tMysqlInput --Main flow--> tFileOutputExcel
tMysqlInput --OnSubjobOk --> tSendMail (with the file path from tFileExcelOutput as attachment)