How to send Sql query output as mail

[dataleadge]

 Hello Community,

I'm new to talend and wanted to execute an job which would send my Sql query output as mail to the recipients .The query needs to be run on daily basis and the output should be attached to mail.It'd be great if anyone can help me with components and connection.

Thanks in advance!

[Anonymous · Accepted solution]

Hello,

Please have a look at this related topic:https://community.talend.com/t5/Design-and-Development/resolved-Sending-query-result-by-mail/m-p/100...

Let us know if it helps.

Best regards

Sabrina

[dataleadge]

Hi Sabrina,

Thanks for your reply-that was of great help.I would appreciate if you'll help me to get the output which is sent in mail in tabular form.Following is the example that would give you brief idea about my query.

The output I want in mail:

schema1  schema2 schema3

data            data         data

data            data         data

data            data         data

The output I'm getting:

schema1  

data            

data           

data

schema2

data

data

data

schema3

data

data

data           

Thanks in advance!

Best Regards.

[Anonymous]

Hello,

What's your output component? Could you please post your current job design screenshot here?

Best regards

Sabrina