Help! We are sending a bunch of reports to our members this morning and I designed a workflow to do this. In the testing phases all worked perfectly, but in action, it's disastrous.
I have a workflow that finds all of the entries in a folder. It found 227 entries. It then looks up the entry name from a SQL table and finds the email addresses associated with the file, and emails the file to those people. I have the emails separated out into separate cells and my workflow emails to Email1, Email2, Email3, Email4, Email5 and Email6 that are derived from the query of the file name.
I am BCC'd on them. I only received 113 emails. Workflow skipped every other entry - I cannot find a reason for this. For all of the emails that it did send, I got an error that it was "Unable to send to a recipient" or "Mailbox unavailable. The server response was 5.7.1". We have concluded that they most likely are seen as spam, so I'm not sure how to get around that.
But why did it only send every other entry? It says it found 227, but it sent 113.
I just noticed that this is a For Each File, not entry. Would this make a difference?