Excel spreadsheet sending email based on cell formula

[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
(e-mail address removed)

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.

 

[Ron de Bruin]

Hi

Yes this is possible
See
http://www.rondebruin.nl/mail/change.htm

Try the CDO example or look on this site for a lotus mail example

Sending mail from Lotus Notes (XL-Dennis)
http://www.excelkb.com/?cNode=1X5M7A