In Microsoft Fabric in NoteBook using Python there is no Pywin32

[Anusha__v]

Hi,
In Microsoft Fabric in NoteBook using Python there is no Pywin32.
The task is to read and write the Excel file and send it as an attachment to Outlook.

can any one help

Thanks

[nilendraFabric · Accepted solution]

Hello @Anusha__v 

I have answered this question here 

https://community.fabric.microsoft.com/t5/Data-Engineering/How-to-send-an-email-with-an-attached-fil...

Please see if this helpful and accept the answer.

Thanks

[v-hashadapu]

Hi @Anusha__v , Thank you for reaching out to the Microsoft Community Forum.

Please let us know if your issue is solved. If it is, consider sharing the insights or marking the answers that helped 'Accept as Solution', so others with similar queries can find them easily. If not, please share the details.
Thank you.

[GilbertQ]

Hi @Anusha__v 

Just also to add another comment is that in the notebooks you can install any python module using the pip installer.

Here is a way to complete it: Installing and Managing Python Packages in Microsoft Fabric

[nilendraFabric · Accepted solution]

Hello @Anusha__v 

I have answered this question here 

https://community.fabric.microsoft.com/t5/Data-Engineering/How-to-send-an-email-with-an-attached-fil...

Please see if this helpful and accept the answer.

Thanks

[Anusha__v · Accepted solution]

Hi @nilendraFabric ,
thanks for your help.
can you please provide more details on "send_mail" in your code if I need to send specific mail?
Thanks

[v-hashadapu]

Hi @Anusha__v , thank you for reaching out to the Microsoft Fabric Community Forum.

Based on the information available I concluded that send_email is calling the function which might be defined elsewhere and is passing in the required parameters which attaches excel file.

Please refer to these documents: Automate creating, sending, and processing messages using the Outlook mail API - Microsoft Graph | M...

Get Started with the Outlook REST APIs - Outlook Developer | Microsoft Learn

which will help you in writing the logic for send_email function.