Help Needed

[erzon]

I have created an alarm like if the time = to current time then it will fire the send email. Its working properly. My only problem is the loop.. example

alarm 1 = 1:00 PM
alarm 2= 1:15 PM
alarm 3= 1:30 PM


if alarm 1 is trigger excel will send email... now if the alarm 2 is trigger excel will send email also but it will not send anymore email from alarm 1.. just alarm 2.. if the alarm 3 is trigger it will send email for alarm 3 but not for alarm 2 and alarm 1 anymore.. how can i solve this using loop? or any idea to solve this?

 

[FDibbins]

Well if you are testing for "time" = current time, why would you expect anything else? If is it 1.15, and that "time" is current time, then the 1.00 alarm will not trigger, because that is no longer "current time"

Perhaps you need to test for <= current time? But that could lead you into problems with "yesterday's" alarms, to you may need to test for "today" = today's date as well

 

[erzon]

Well if you are testing for "time" = current time, why would you expect anything else? If is it 1.15, and that "time" is current time, then the 1.00 alarm will not trigger, because that is no longer "current time"

Perhaps you need to test for <= current time? But that could lead you into problems with "yesterday's" alarms, to you may need to test for "today" = today's date as well

i got your point.. the condition also if alarmtime<current time then the alarm will trigger.. but the problem is even the 2 alarm is < current time it only trigger the last alarm that it loop.

 

[erzon]

<current time="" then="" the="" alarm="" will="" trigger..="" but="" problem="" is="" even="" 2="" <="" current="" it="" only="" trigger="" last="" that="" loop.[="" quote]
yes the condition is alarmtime < currentime but problem is even alarm 1 and alarm 2 is less than currentime. only the last will trigger </current>