Hi all,
I am using the Email tool to send an email to 2000+ employees within my company. As you can imagine, it is very difficult to figure out if all 2000+ employees are still with the company at any given time. I have found that the Email tool will email the employees that are active until it hits the first invalid email address and then the entire workflow fails. Is there a way to just let the workflow skip any invalid email addresses and continue processing the rest of them.
For example: In this example, the first 2 email addresses will get an email but then the workflow will just fail when it hits the 3rd email address which is invalid. Is there a way to just skip email 3 and have the workflow continue to email addresses 4 and 5?
Email 1 - valid
Email 2 - valid
Email 3 - invalid
Email 4 - valid
Email 5 - valid
Thanks for any help!
Solved! Go to Solution.
Hi @ELPC
This is a common issue we face with email tool. How you can tackle is by using batch macro to send emails. What batch macro does is it sends a single email at a time and even if an email fails it will go to next email.
Workflow: batch by record id I,e each row
Macro: create macro to send a single email at a time.
Learn more about creating batch macro: https://community.alteryx.com/t5/Interactive-Lessons/Creating-a-Batch-Macro/ta-p/657923
Hope this helps : )
Thank you so much for the response, I will try this method. Is there a way to know which emails failed after running the batch macro? Thank you.
Hi @ELPC
You will get the row numbers which failed based on that you can check for emails which failed.
Happy to help : )
Cheers and have a nice day!