hello
I have a workbook with a vba code to send an email if acertain cell as value 1
but sometimes that send to much emails .
Is it possible limited the number of Email ( only want send one ) send in that Hour or day ?
ccruz
hello
I have a workbook with a vba code to send an email if acertain cell as value 1
but sometimes that send to much emails .
Is it possible limited the number of Email ( only want send one ) send in that Hour or day ?
ccruz
Hello ccruz!
Hum... strange, if your VBA code consider the value of a single cell, it should send only one e-mail, am I right?
Well, I do not know if is there a way to limit the number of e-mails sent, but if you have a loop structure such as For Each Next or Do While, what about to put a Counter and use a If when it is higher than 1?
Hope it helps!
With out seeing code, it is hard to help. Either post code that pertains to the problem or post a simple workbook.