DEV Community

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

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?