Hello once more,
I have a data set that gets split into multiple excel files and is further broken down into multiple tabs in each file.
I have 3 excel files that get created from this flow and I must send them out into 2 different emails:
- The 2 files for regions AMER and APAC must be sent to email1@outlook.com
- The file for region BOLD must be sent to email2@gmail.com
The data set tends to change daily, so I can't rely on static parameters to create these files or send out the emails to.
For example, some days, I only need generate files for APAC and BOLD, other days all 3 AMER, BOLD, and APAC files are generated.
I've tried to look into some possible solutions for this issue and found a macro someone made here:
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Email-Batch-Macro-With-Varying...
I feel like it might be the answer to my problem, but I'm lost on how to utilize it properly, even though the macro looks pretty simple to use... The creator didn't really explain how to configure it and I don't think they're very active anymore...
Any and all help or insight would be appreciated on how I can go about achieving this goal!
