Excel spreadsheet sending email based on cell formula

E

excelnut1954

I've looked at past posts many times, and I need to know the answer to
this question:

Can an If-Then formula in a cell generate an email?
Example: Formula in a A1
If date greater than or equal to Jan 1 2007, send email to
[email protected]

Note, the company I'm with uses Lotus Notes for all the emailing.

Am I wasting time looking for a way to do this? Or can this be done?

Thanks,
J.O.
 
Top