Excel spreadsheet sending email based on cell formula
 

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


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.

Excel spreadsheet sending email based on cell formula
 

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



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message ups.com...
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


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.