Sending emails with attachment via pipeline

[vitran23]

Does anyone know if it's possible to loop through a set of files in a lake house and attach them to a email and send out to a distribution group within a pipeline?

I've done this via a VBScript just curious if there is native functionality to allow this in fabric pipelines. 

[v-saisrao-msft]

Hi @vitran23,

We haven’t heard back from you in a while. If your issue has been resolved, please mark the relevant response as the solution to help fellow community members.
If you still need support, Please let us know if you still need assistance.

Thank you.

[v-saisrao-msft]

Hi @vitran23,

checking in to see if your issue has been resolved. If the response provided was helpful, kindly mark it as the solution so that others with the same issue can benefit.
Please let us know if you still need assistance.

Thank you.

[v-saisrao-msft]

Hi @vitran23,

I hope you had a chance to review the solution shared earlier. If it addressed your question, please consider accepting it as the solution — it helps others find answers more quickly.
If you're still facing the issue, feel free to reply, and we’ll be happy to assist further.

Thank you.

[NandanHegde · Accepted solution]

As stated, Outlook activity unfortunately doesnt support email attachments.

You can use logic apps or external offerings for the same:

https://allenvisser.azurewebsites.net/2023/03/29/azure-logic-apps-how-to-send-an-email-with-an-attac...

And you can trigger the logic app via fabric data pipeline

[v-saisrao-msft]

Hi @vitran23,

Thank you for reaching out to the Microsoft Fabric Forum Community.  

The fabric pipeline doesn't support sending emails with attachments directly through Outlook activity; it can only send plain emails.  

To work around this, create a data pipeline to fetch the required files from the Lakehouse and store them in a staging location such as Blob storage. Then, trigger Power Automate using a web activity to send the files via email.

If this post helps, then please consider Accept it as a solution to help the other members find it more quickly.

Thank you.