Sending multiple emails using batch macro

Question

Hi, I have the workflow that is connected to the batch macro that sends multiple emails. The workflow is uploaded to the gallery and it's working, it sends multiple emails to the recipient and the number of emails is based on Summarize that groups one field which is a column (LE BD) combined of two columns (LE & BD):

LEBDLE BD123WM123_WM456PC456_PC

In the macro one email should contain information to whom it should be forwarded and have information from given row in form of a table:

LENameCountryBDLE BDAdditional infoEmail ToEmail CC123Europe BranchFranceWM123_WMtextgeorge@email.comteam@email.com

At the start of the macro I have a filter that filters for one 'LE BD' and there's an Action with Control Parameter above and I suppose I need to correctly configure the action. I was trying to choose in action:

'Filter -> Simple' -> Field-value-'LE BD'' or

'Filter-> Operands -> Operand -> Operand-value-'123_WM'

However alteryx sends multiple emails but only one email has all needed information (all the info from the filter).

This is how my macro looks like (Table and Text marked in yellow need to vary depending on 'LE BD' column):

I'm attaching the macro with added text information. Thank you in advance for your help!

NewMacro.yxmc

DataNath · Answer

Hey @Baniassi if I'm understanding this right, you'll want to change your control parameter action configuration to the following:

Making sure 'Replace a specific string' is ticked.

On the outside of your macro, you'll need to pass a list of all the [LE BD] values that you want to loop through to the control parameter input (upside down question mark). Making sure it's mapped in the 'Questions' tab of the batch macro configuration: