I'd like to do something similar to this. I have a Contract database, that
tracks the Vendor, the Go Live Date and then calculates about 2 weeks out
when the contract should be sent out. What I'd like to be able to do is have
the spreadsheet send a reminder e-mail to the three people involved in the
Contract process once the 2 week date is hit.
I'm not very good at this.. I've only ever written one macro and that was
pretty much a copy and paste job from someone here. Any and all help would be
greatly appreciated!
N
"Ron de Bruin" wrote:
Start here
http://www.rondebruin.nl/mail/folder3/message.htm
If you need more help post back
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Freshman" wrote in message ...
Dear experts,
I've a database of clients' information. Column A is clients' names; column
B is account numbers; column C is subscription dates; column D is expiry
dates.
My question is, if I set a formula in column E which shows "Renewal" if
expiry date minus today is less than 30 days. Subsequently, if coulmn E
showed "Renewal", then a macro can trigger an action which can generate a
reminder e-mail to respective client in accordance with the e-mail address in
column F. In the reminder e-mail, it should contain respective client's name,
account name, the expiry date and some standard wordings. Can it be done? If
yes, please kindly advise.
Thanks in advance