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,

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]

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.