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.
Bookmarks