topic Sending an email w/ Excel Attachment in Talend Studio

Sending an email w/ Excel Attachment

Anonymous — Sat, 16 Nov 2024 14:05:54 GMT

I have built a job that processes an Excel workbook and generates multiple workbooks from the data.
I would like the job to then email the output workbooks as an attachment using the tSendMail component.
The job will send the email IF I hardcode the path to the attachment in the tSendMail component. However, if I use a context variable for the attachment file path it will not work. It will only send 488 byte file that will not open in Excel (see images).
Does anyone have any ideas?
Thanks, Rick.

Re: Sending an email w/ Excel Attachment

_AnonymousUser — Fri, 16 Oct 2009 09:04:48 GMT

Same issue.
Can someone help to solve this issue?
Antonio

Re: Sending an email w/ Excel Attachment

Anonymous — Fri, 16 Oct 2009 09:29:20 GMT

Hello,
U have to use a trigger "onSubjob ok" after writing excel files and then send the email.
That's because excel file handlers are not closed yet, using the trigger, the finalization are operated and the files are then available to read.
I don't understand the meaning of your row2 and row4, just put the trigger between your tFileOutputExcel_2 and the tSendMail_1.