Paste Excel clip to body of an email through Python
- by Twinkle
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,