DEV Community

loading...

Discussion on: Automate Excel with Python

Collapse
pratikaambani profile image
Pratik Ambani

I need to send mails via excel on a date mentioned in particular cells. Failing to achieve this. Anybody?

Collapse
stokry profile image
Stokry Author

Hello, you can use smtplib library and openpyxl library that will read data from Excel. After that, you can compose an email that you want to send, if you have code, you can post or send me, then I can help you.

Collapse
pratikaambani profile image
Pratik Ambani

Thanks for your response. Well, I need to trigger mail (when meeting certain criteria) when I open excel itself. I'm attempting to make it possible within a single file.

Can we achieve this?