Email Tool - Creating a Batch Macro to Pass Thru One Email At a Time

Hi, Team:

I need to include a layout as Email body and pass through one email at a time so if there are undeliverable emails, it will not disrupt the entire workflow (meaning, I would want emails with correct addresses to be sent out and only the undeliverable emails to error).

Any idea on how to accomplish this? Your guidance on how to create this batch macro would be much appreciated!

Attaching my workflow (without the batch macro) below.

Thank you!!!

Capture.PNG

Batch Macro

Accepted answers

All comments

gautiergodard

Hey @kkkim

The good thing is that you shouldn't need a batch macro to do this!

The email tool sends one email per row that is passed into the tool. Therefore, you simply need to create fields (as columns) with the email addresses you are looking to contact. Using the group by functionality in the table tool and layout tool, you could group your data on the basis of the email the data needs to be sent to.

Hope this helps!

saiirangam

This should help you, create a batch macro to send emails one by One from the list

Solved: Creating a Batch Macro to email multiple users dif... - Alteryx Community

Let me know if you need more clarification.

Sai

kkkim

@gautiergodard Hello! Thanks for your feedback - yes this is how I set it up right now. However, when there is one undeliverable email address, the entire list of emails in the table does not get sent out. So trying to create a batch macro so the rest of the emails will get sent out and only the wrong email address will be held back.

Thank you!

kkkim

@saiirangam - I've reviewed the post. Where does the Sum tool actually go? Do you have an example workflow using reporting tool and concatenate email address (via Sum Tool)?

Thank you so much!!!

saiirangam

@kkkim

We have step by Step for creating the batch macro, meanwhile I have created sample batch macro for this scenario

Solved: Email tool - handling bad addresses gracefully? - Alteryx Community

Email Batch Macro.JPG

Workflow.JPG

kkkim

@saiirangam thanks so much for this. Does this macro only work if input is a text file? Because the email addresses are one of the columns in the table? How do we use this macro with input being layout tool or table?

Thanks again!!!

saiirangam

@kkkim Please click on the, Accept the solution if this is solved

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703