Alteryx Batch Macros – Email Customized Reports to a List of Users


Alteryx Batch Macros – Email Customized Reports to a List of Users

Have you ever had the pleasure of emailing customized sales reports to 25 regional managers? How about 100 customers? It probably took a nice chunk of your day clicking the same buttons in Outlook and verifying you’ve attached Joe’s sales report to Joe’s email address. Ever wish for an easy button?

With Alteryx batch macros, this mundane task is now automated!

Step 1 – Obtain Email Addresses

To begin, specify a list of email addresses you’d like to message. For customization, I’ve added first name and last name, as well:

Specify email addresses in Alteryx

Step 2 – Feed The Macro

The batch macro at the end of this workflow will process each email address and send a tailored message to each recipient with a detailed report by location attached to the message. In this example, I’ve previously generated a sales report by email and location. This file is then split into multiple files for each recipient. Sales across locations are aggregated and included in the body of our message.

Alteryx batch macro

Step 3 – Configure The Macro

Modify settings for the email tool as shown in Step 2, save and execute the email workflow. That’s it. Easy right?

Hit the download link below, and let me know if you have any questions.

More About the Author

Jubail Caballero

Delivery Architect
Optimizing Tableau Relational Models With Row-Level Security: Filters In Part two of this series, we covered a method of distillation to reduce data volume and size. However, we need to translate our ...
Optimizing Tableau Relational Models With Row-Level Security: Performance In a previous installment, we kicked off this blog series by materializing our policy and entitlement table and removing all physical ...

See more from this author →

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK


Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Geschäftsführer: Mel Stephenson

Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072


Love our blog? You should see our emails. Sign up for our newsletter!