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 send email... now is 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?
alarm 1 = 1:00 PM
alarm 2= 1:15 PM
alarm 3= 1:30 PM
if alarm 1 is trigger excel send email... now is 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?
