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

Analytics Consultant
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 →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

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