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]...
>>
>
>
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]...
>>
>
>
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]...
>
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]...
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks