Any way to send email from pipeline / notebook with data in lakehouse?

[aseagull]

Hi. Without premium or a reserved capacity, and only an F2, is there a way to use a python notebook and smtplib to send email? I have been getting 501 errors (connecting to Exchange Online), even though the python works fine from a desktop.

SMTPHeloError: (501, b'5.5.4 Invalid domain name...

Thanks,
Amon

[Anonymous · Accepted solution]

Hi @aseagull 
Thanks for using Fabric Community.
Can you please share the code which you are using in the Fabric Notebook?

You can use a pipeline to send an email using the Outlook activity:
https://learn.microsoft.com/en-us/fabric/data-factory/outlook-activity
https://www.youtube.com/watch?v=sbxnDqRxTPQ

Hope this helps. Please let me know if you have any further questions.

[aseagull]

Thank you very much! I did not even realize all the Activities that are available. In the video link you shared, the presenter uses an expression language to encode dynamic content. Do you know where I can find a reference for this expression language?

[Anonymous]

Hi @aseagull 
Glad that I could help you in resolving the query. For information regarding dynamic content please refer to this link:
Parameters - Microsoft Fabric | Microsoft Learn

Please continue using Fabric Community for any help regarding your queries. Glad to help.