VBA is exiting the procedure instead of running the rest of the code

Hi All,

I'm working on an automated email system for our company's design tracker. Essentially, at the end of each day, emails go out to the designated customer providing them with an update on the status of their design.

Everything has worked in previous versions, but I'm adding in a new checking process. My boss doesn't want the customers to receive the same emails "x" amount of times in a row, so I've established a counting system. The problem comes up like so:

1) The loop initiates
2) Assuming the client has opted in for email updates, has provided a valid email address, and has an incomplete design in the system, an email template is selected. (I've only included one for reference, as the only difference between them is the wording of the email).
3) The appropriate template procedure is then run, checking for the quantity of previous emails sent under this format. If the quantity of emails sent is less than the cap, it increases the "emails sent count" by one, and SHOULD assign the email body template and then return to the "SelectTemplate" procedure that called it.

Instead of that, the macro is exiting the procedure after it increases the "emails sent" count and returning to the "ProcessData" procedure and finishing the loop, skipping over the code that sends the email.

Please Login or Register  to view this content.

------------------------------------------------------------------

xladept, thanks! I tried that solution, but it has not worked.

Thanks Norie. I have tried stepping through the code, and that's how I came to find the issue with procedures being skipped over.

If we go to the SelectTemplate Procedure, and pretend that "BEING CHECKED" is the case, this is what happens when I step through the code:

intBCES is assigned a new value
BCTemplate is called
intBCES <> 2
The cell that stores the value of intBCES is increased by one
The code jumps back to the process data loop instead of: 1) creating strEmailBody 2) returning to the SelectTemplate procedure and 3) completing the rest of SelectTemplate, which includes the sub to send out the email.

I tried attaching the file, but it's too large. If you'd like to see the file, I have it in my google drive: https://drive.google.com/file/d/0B3g...ew?usp=sharing

Again, thank you all for your help!

What happens if you turn off error handling?

I get the same results.

When I comment out the lines that increase the count of each specific email sent, the macro executes perfectly.

intBCES and the rest of the ES counts are currently at zero.