Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
karen gomez
 
Posts: n/a
Default excel spreadsheet with e-mail notification when due date arrives


  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

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



  #3   Report Post  
Ron de Bruin
 
Posts: n/a
Default

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Send Excel 2002 spreadsheet to MacIntosh Excel 2004 cagedbirdflies Excel Discussion (Misc queries) 0 February 21st 05 08:13 PM
Convert Word labels to Excel spreadsheet Lisa Excel Discussion (Misc queries) 2 January 18th 05 10:36 PM
How do I export an Excel spreadsheet to Pocket PC (Pocket Excel)?. Selena Excel Discussion (Misc queries) 1 December 7th 04 03:01 AM
How do I password protect cells in a spreadsheet created in Excel Tbenson37303 Excel Worksheet Functions 0 November 22nd 04 09:21 PM
How do I password protect cells in a spreadsheet created in Excel [email protected] Excel Worksheet Functions 0 November 22nd 04 09:21 PM


All times are GMT +1. The time now is 07:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"