|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
May 4th, 2002, 12:39 AM
|
#1 |
|
Board Regular
Join Date: Apr 2002
Posts: 64
|
I have a spreadsheet that tracks repairs to customers' equipment. One of the columns is required delivery date. Is there a way to send an alert by email when today's date is within five days of the required delivery date?
|
|
|
|
May 4th, 2002, 06:14 AM
|
#2 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,065
|
set the alert you request in conditional formatting
so when 5 bays B4 the alert pops up...
__________________
Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you" |
|
|
|
|
May 4th, 2002, 06:17 AM
|
#3 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,065
|
eH!
posted on its own... then set the email to trip and sent as requited.. your need VBA for this sll in one go, on set conditional formal and you can them do manula and you have control,,, poss i prefer this.. as then i could check YES or no to send as you cant un send emails if they have the smallest error or any other reason Some help i hope
__________________
Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you" |
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
