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.

Attached Files

disk file.xlsx (10.9 KB, 3 views)

You could, of course, us the filter in the "Edit Recipient List" and do separate merges that way. Of course, if there are 60 that would be a right pain.

If you're doing this repeatedly, I'm sure VBA could help, though I haven't used VBA for this particular thing.

There are some add-on tools for merge - Doug Robbins' for example - I don't know whether this will help specifically with this.

Also in this forum, there is an item towards the bottom on this Tips and Tricks page which looks like it might work by, after merging all your items into one document, helping to split it into separate documents afterwards?
https://www.msofficeforums.com/mail-...%20the%20merge

would produce 3 merge documents, 1 for 'cont_id' = 1, 1 for 'cont_id' =2, and 1 for 'cont_id' =3.

Each document has multiple rows with same cont_id named as 1.docx,2.docx... like this https://b23.tv/TznKgL7?

Attached Files

mail_merge.zip (41.8 KB, 3 views)