Email tool - handling bad addresses gracefully?

[JasonTrippet]

I've got a workflow that takes an input table, does some prep, and uses the Render tool to build a customized message for the body of the email, so each recipient (one per row) gets a personalized message, and it works great - when all the email addresses are good.  The issue I'm having is that when even just 1 email address turns out to be "bad" (using my company's SMTP, so I'm assuming that Alteryx is doing an Address Book check before trying to send), the workflow halts and zero emails get sent, not even for the rows with good addresses (whether before or after the bad one's position in the table).

Is there a way to have the Email tool handle that gracefully, and successfully send the emails that it *can* send, and perhaps just post (or collect somehow) warnings about the bad ones that it was unable to send?

Thanks!

Jason

[JasonTrippet]

Works perfectly @Thableaus , thanks again!

[alison]

Hi! I know you found a workaround to your problem, but I am encountering a similar issue and am hung up on the "why". Have you seen any insight to the process of Alteryx checking the address book? I'm trying to figure out exactly where the validation point happens as I'm getting error messages for DLs that are valid, but don't show up in all global address books.

Thanks!

[JasonTrippet]

To be honest I haven't revisited the email function since I posted, and hadn't looked into it further.  I assumed that using my company's SMTP was driving Alteryx to check those internal address books, and if an address couldn't be found in them, it failed.  I just did a quick test with a personal email address of mine, and confirmed - even though the address is valid, real, and good, the workflow failed because it's not in my company's SMTP address book.  I don't know if there's a way to use an external provider's SMTP that wouldn't require an address book check.  Sorry it's not very helpful!

Jason

[alison]

I appreciate hearing your experience on the matter, in any case, so thank you for responding.

My issue is that I'm not sure which address book alteryx might be checking. I know there is a "Global Address Book" and an "Offline Global Address Book" and I'm sure there are others...all of our internal addresses don't show up in all of them. Hopefully I'll stumble upon someone who can tell me where to look to find out!

[OnTheFly]

just came across this solution and feel that I am going to run into the same issue. do you happen to have an example workflow/macro to share or the best place to go learn this? 

[PinuRabbit]

Hi @JasonTrippet,

I wonder if you tried the Iterative Macro or a Batch Macro to solve your issue successfully? I have the same issue and I tried both. Both of them still email the recipients that are active until it hits the first invalid email address and then the workflow stops. 

For example:  In this example below, the first 2 email addresses will get an email but then the workflow will just fail and stop when it hits the 3rd email address which is invalid.  

Email 1 - valid 

Email 2 - valid 

Email 3 - invalid

Email 4 - valid

Email 5 - valid

Since this article was posted long time ago. I'm now using the version 2022.1. I'm not sure if the way of Iterative Macro or Batch Macro no longer works for this issue in version 2022.1?

Thank you in advance