I am using win32com.client in Python to send an email.

However I want the body of the email to be a table (HTML- formatted table), I can do it in an Excel first and then copy and paste (but how?), or directly edit the corresponding Pandas data frame.

`newMail.body = my_table` which is a Pandas data frame didn't work. 

So I'm wondering if there is smarter ways for example, to combine Excel with Outlook apps within Python?

Cheers,