| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
send mail on value
I find myself in need of a way to send an email via excel when a cell gets to
a certain value. I have the recipients email in A1. In B1 I have the number of days remaining till his certification expires. B1 is dynamic and changes every day so thats not the issue. I need a way to email the address in A1 when B1 drops below 30. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
send mail on value
Hi Ryan
You can try this http://www.rondebruin.nl/mail/change.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ryan" wrote in message ... I find myself in need of a way to send an email via excel when a cell gets to a certain value. I have the recipients email in A1. In B1 I have the number of days remaining till his certification expires. B1 is dynamic and changes every day so thats not the issue. I need a way to email the address in A1 when B1 drops below 30. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bypass: A program is trying to send mail using Item.Send prompt | Excel Discussion (Misc queries) | |||
| Send an e-mail | Excel Discussion (Misc queries) | |||
| A program is trying to send mail using Item.Send | Excel Programming | |||
| Send e-mail | Excel Programming | |||
| Send Mail | Excel Programming | |||
Hybrid Mode
