I currently have a procedure set up which contains a loop that sends email alerts to different depots, based on data related on a worksheet (i.e. 1 row = 1 alert)
However when I run through this the alerts do not get delivered in the same sequence that they were sent, and the occasionally 1 is 'lost' for a little while. I've noticed that if I run the whole procedure through the debugger slowly that no emails seem to get 'lost' and they are delivered in the correct order.
So I was wondering if there was a bit of code I could put in which delays the procedure slightly during each loop to give the email before had a chance to be delivered first.
However when I run through this the alerts do not get delivered in the same sequence that they were sent, and the occasionally 1 is 'lost' for a little while. I've noticed that if I run the whole procedure through the debugger slowly that no emails seem to get 'lost' and they are delivered in the correct order.
So I was wondering if there was a bit of code I could put in which delays the procedure slightly during each loop to give the email before had a chance to be delivered first.
