Mail merge to groups of 'individual files' based on a field
I've searched the forums and haven't found exactly what I'm looking for. I'm running a bulk mailing, and I want to print each tray on its own. The tray number is stored in the 'cont_id' field. It might be 4 trays, it might be 60 trays. Normally I select "edit individual documents' and then put in the a starting and ending number for each 'tray'. but that is prone to human error and can take a long time if there are 60 trays.
Is there a way to run a mail merge that splits into individual files based on a field changing?
I tried the "Merge_by_Group" code and it produces the right number of documents, but it's only the first record of each 'group'. A tray might have 1 piece in it, or 2000+. I've attached a sample excel file. In my ideal scenario, it would produce 3 merge documents, 1 for 'cont_id' = 1, 1 for 'cont_id' =2, and 1 for 'cont_id' =3.
I hope this make sense.
|