Ok, so earlier on I was amending an automated email process, and forgot to change the sheet reference for my lngLastRow variable.
This was not good as I have a loop which sends emails that's set to end at this lngLastRow value, unfortunately because of the incorrect sheet reference the initial value for my loop was set higher than the lngLastRow value, so it was never ending.
I did realise this after a few minutes and clicked stop, however I am now receiving 1000's of emails to my account (luckily I was just testing and hadn't sent this out to the whole company).
Is there a way to check that more emails are not still being sent? If it's just a case of me deleting a few 1000 more back logged emails then it's not a problem, but if it's still sending them then it is.
Please help
This was not good as I have a loop which sends emails that's set to end at this lngLastRow value, unfortunately because of the incorrect sheet reference the initial value for my loop was set higher than the lngLastRow value, so it was never ending.
I did realise this after a few minutes and clicked stop, however I am now receiving 1000's of emails to my account (luckily I was just testing and hadn't sent this out to the whole company).
Is there a way to check that more emails are not still being sent? If it's just a case of me deleting a few 1000 more back logged emails then it's not a problem, but if it's still sending them then it is.
Please help
