I have a list of rows that need to generate emails.
When sending the list into an email tool, if any of the addresses cause a failure, processing of the remainder of the list stops and I have no way to definitively determine which email caused the problem or how many rows remain in the list that did not get emails sent.
I tried autonumbering each record, creating a batch macro to perform the email task, and using the autonumbered field to be the control parameter, so each record is sent to the email tool individually. The idea was that I could write to an output with each pass, and keep track of which emails processed before failure. Instead, the one bad test email fails, and the remainder of the list is processed.
Small improvement, but I still have no way of determining what email address failed.
There is no output anchor on the email tool, so I'm not sure what I can do to capture "THIS IS THE RECORD THAT FAILED" when writing to my output. Any suggestions?
