I have a SQL query that pulls some employee information. I have a Email Message task I created a loop around this task to iterate through each row of the query results to send an email to each employee returned from the query. Unfortunately, the only email address it is sending to is mine. To test the loop logic, I set-up a similar loop around a write file task and it successfully wrote out each email address, so I know the loop logic is correct.
I do not know if dynamic email addresses are allowed because I can see this might be a security issue. I have logged a ticket with VC. Does anyone do something similar where you've had to work around this? Thank you