excel spreadsheet with e-mail notification when due date arrives

Hi Karen

Please put your question in the body and not in the header next time

Start here
http://www.rondebruin.nl/mail/change.htm

You can create a formula cell that change to yes when the due date arrives.
Check for yes then in the change event

Give more information if this is not what you need


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


"karen gomez" <karen [email protected]> wrote in message news:[email protected]...
>

Another way is to check the date in the workbook open event and to run the mail sub from there.

See Chip Pearson's site for more info
http://www.cpearson.com/excel/events.htm


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


"Ron de Bruin" <[email protected]> wrote in message news:[email protected]...
> Hi Karen
>
> Please put your question in the body and not in the header next time
>
> Start here
> http://www.rondebruin.nl/mail/change.htm
>
> You can create a formula cell that change to yes when the due date arrives.
> Check for yes then in the change event
>
> Give more information if this is not what you need
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "karen gomez" <karen [email protected]> wrote in message news:[email protected]...
>>
>
>

Hi Karen

Please put your question in the body and not in the header next time

Start here
http://www.rondebruin.nl/mail/change.htm

You can create a formula cell that change to yes when the due date arrives.
Check for yes then in the change event

Give more information if this is not what you need


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


"karen gomez" <karen [email protected]> wrote in message news:[email protected]...
>

Another way is to check the date in the workbook open event and to run the mail sub from there.

See Chip Pearson's site for more info
http://www.cpearson.com/excel/events.htm


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


"Ron de Bruin" <[email protected]> wrote in message news:[email protected]...
> Hi Karen
>
> Please put your question in the body and not in the header next time
>
> Start here
> http://www.rondebruin.nl/mail/change.htm
>
> You can create a formula cell that change to yes when the due date arrives.
> Check for yes then in the change event
>
> Give more information if this is not what you need
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "karen gomez" <karen [email protected]> wrote in message news:[email protected]...
>>
>
>

Hi Karen

Please put your question in the body and not in the header next time

Start here
http://www.rondebruin.nl/mail/change.htm

You can create a formula cell that change to yes when the due date arrives.
Check for yes then in the change event

Give more information if this is not what you need


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


"karen gomez" <karen [email protected]> wrote in message news:[email protected]...
>

Another way is to check the date in the workbook open event and to run the mail sub from there.

See Chip Pearson's site for more info
http://www.cpearson.com/excel/events.htm


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


"Ron de Bruin" <[email protected]> wrote in message news:[email protected]...
> Hi Karen
>
> Please put your question in the body and not in the header next time
>
> Start here
> http://www.rondebruin.nl/mail/change.htm
>
> You can create a formula cell that change to yes when the due date arrives.
> Check for yes then in the change event
>
> Give more information if this is not what you need
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "karen gomez" <karen [email protected]> wrote in message news:[email protected]...
>>
>
>