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
Tableau’s New Data Model: Physical vs. Logical Data Sources With the recent release of Tableau Desktop 2020.2 came the introduction of a brand-new data model. In versions prior to 2020.2, users ...
Alteryx Tool Spotlight: Compare Values Across N Groups with Dynamic Replace Imagine you are supplied financials from multiple vendors and have the wonderful task of comparing them to each other? With two ...

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


Insights are just a search away! - Join our webinar on June 21 to see ThoughtSpot in action.