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

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

Dear Ron,

Thanks for your code and it suits my case. However, your code states that it
only works when use Excel Outlook. What about Lotus Notes? What lines in the
code need to be replaced? Please kindly advise.

Thanks a million. Regards.

"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

For Notes see
http://www.excelkb.com/?cNode=1X5M7A

Or see my CDO page
http://www.rondebruin.nl/cdo.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Freshman" wrote in message ...
Dear Ron,

Thanks for your code and it suits my case. However, your code states that it
only works when use Excel Outlook. What about Lotus Notes? What lines in the
code need to be replaced? Please kindly advise.

Thanks a million. Regards.

"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

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

Have you look at example 2 on that page
There is a formla that looks at a date in that example

If you want to send the mail to more then one person tell me where the
mail addresses are in the database.
Or are they always the same


--

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


"NS421" wrote in message ...
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