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

[Anonymous]

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?

[Anonymous]

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