How to attach a flat file into informatica Email?

email attachment xls email-attachments informatica
Görkem Hatipoğlu picture Görkem Hatipoğlu · May 15, 2013 · Viewed 11.7k times · Source

I want to send a mail to some users after workflow is done. This email should contain 3 xls file or 1 xls file with 3 sheets. The xls file contains a query result -less than 50 rows- which is loaded by a task dynamically on each run of the workflow.

So in Informatica I couldn't see an option inside the "Email" task to attach anything. Can you help me please?

Answer

Marek Grzenkowicz picture Marek Grzenkowicz · May 15, 2013

You cannot send emails with attachments using the Email task (don't ask me why, I cannot imagine any reason for that and this is how it is).

However, sessions can send emails and these emails may contain attachments - the appropriate options are on the Components tab, the variable you need is %a<>.

More information: How to attach new files to email task?

Related questions

Sending email with attachments from C#, attachments arrive as Part 1.2 in Thunderbird

I have a C# application which emails out Excel spreadsheet reports via an Exchange 2007 server using SMTP. These arrive fine for Outlook users, but for Thunderbird and Blackberry users the attachments have been renamed as "Part 1.2". I found this article …

Read More
Lotus Notes email as an attachment to another email

This is in Notes 8.5 environment. I just wanted to know how to attach an email to another email as real attachment not a "Document Link". I intended to attach an email, so I drag & dropped an email to another …

Read More
Sending Multipart html emails which contain embedded images

I've been playing around with the email module in python but I want to be able to know how to embed images which are included in the html. So for example if the body is something like <img src="../…

Read More