Bulk email addresses validation

Question

Good day Everyone

I have designed a workflow that sends email notifications to 5000 users. I get the email addresses for the users from my organizations HR portal. My question is how I find out if any of the 5000 employees email addresses are inactive (by inactive I mean that the email is correct, but the employee has left the org) ? I know and have tested in Alteryx that if it encounters an inactive email the workflow terminates and all subsequent emails following the inactive email are not sent.

So is there a way in Alteryx where I can validate if an email ID is valid or not, also is it possible for the workflow to not terminate if it encounters an inactive email.

Thanks

AbhijeetChib · Answer

Thanks @DanFlint

DanFlint · Answer

@AbhijeetChibI'd recommend this article as an intro to batch macros: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/ta-p/488165

You can set up some control parameters for the To and CC email addresses.

The actions from these can either update the email tool directly, or update a formula tool or text input which can be the fields used in the email tool.

AbhijeetChib · Answer

Thank you @DanFlint

My email tool takes a table as the body and To and CC takes values from - email1 and email 2 fields from the workflow.

Can you please share an example of how to set up this macro, i have never used a batch macro.

Regards

Abhijeet