gmayor

All the macros generating the mail merge and creating the forms are in Excel – so check there!

The criteria have changed a bit, now I have to read the initial array and select all matching records based on the selected record. I have already separated all matching records into a new 2D array, still need the last record of the new array for now (I think this may change - waiting on confirmation) allowing the user to select any record of the new array and regenerate the form. I started exporting the new array to a CSV file to be able to use the macros as they currently are.

I think your suggestion of content controls will eliminate the merge fields in the main document and the need to save the new array to a CSV, it should work nicely! Let me see if a can get into practice.

Thank you for the suggestion.