Hello,
I'm looking to complete a mail merge workflow where there are potentially 40 letter templates that need to be merge with a single Excel File. There data fields to merge with each letter are all the same, but each letter has different static content.
The idea here is to include a data column, named 'Template ID', and each data row should be merged with it's corresponding template ID.
For example, there are 3 different letter templates named as 'Letter 1', 'Letter 2', and 'Letter 3'.
The Excel file would have 20 rows to be merged with these 3 letters. The first 5 columns of the Excel file are data fields to be merged with these letters, however, the 6th column will indicate which letter template that row should be merged with. So out of those 20 rows of data records, 10 will be merged with 'Letter 1', another 5 will be merged with 'Letter 2', and the remaining 5 will be merged with 'Letter 3'.
After the merging process is completed, I should have 3 separate outputs files.
I'm aware that Power Automate can complete the mail merge process, but not sure if it will read a data column to trigger which letter template to use.
Your help would be greatly appreciated and will help with a painstaking work that I can simplify. Any suggestion for an automated or semi-automated process would be beneficial. Please let me know if additional information is required.
