PDA

View Full Version : VBA OF EMAIL FROM EXCEL



ccruz
07-19-2013, 05:47 AM
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

D_Marcel
07-20-2013, 03:43 PM
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!

Kenneth Hobs
07-20-2013, 07:06 PM
With out seeing code, it is hard to help. Either post code that pertains to the problem or post a simple workbook.