@Satheesh K - Thanks for the question and using MS Q&A platform.
I see your question is answered here: Sending data frame as an attachment in email using synapse notebook (PySpark)?.
In additional to @Ganesh Gurram resposne, you can checkout the options available with and without attachements: Sending Spark DataFrame via mail.
Note: You can modify the code Scala to Pyspark for sending data frame as an attachment in email using synapse notebook (PySpark).
Hope this helps. Do let us know if you have any further queries.
If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.