I want to join multiple tables and create a horizontal layout and send email

Question

I want to join multiple tables and create a horizontal layout  with a unique key which is a dealer code. and attach a file based on the delaer code(dealercode.xlsx) and send it to multiple receipients. i have a list with 14 dealer codes and unique files withdealer code as file name. need to send individual emails.

Thanks in Advance

alexnajm · Answer

To add to this, just make sure you have Dealer Code as your grouping column selected so you can link the Tables to your distribution list. You'll also need to combine all your To emails together and your CC emails together into one column each - a combination of Transposes plus Crosstabs should do the trick!

OTrieger · Answer

@GowriRaghavan

You can create the individual tables in Table tool then connect to a Union tool and with Layout Tool you can arrange them horizontally.