My favorite example to understanding the difference between standard macros, batch macros, and iterative macros during training uses laundry.
A standard macro is a process consolidated into a single tool. It’s like tossing all your clothes together in the washing machine without sorting them out.
A batch macro is data grouped in some way and the process repeats per group. It’s like sorting your clothes into different loads: whites, colors, and darks, then washing them in separate loads.
An iterative macro can be thought of as goal-oriented. The process repeats for each record until a specific goal or criteria is reached. This is like if an item of clothing has a tough stain and you need to keep washing it until the stain comes out.