#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Quote:
Each document has multiple rows with same cont_id named as 1.docx,2.docx... like this https://b23.tv/TznKgL7? |
Tags |
group, merge, tray |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Create Individual Files from Mail Merge | bill1234 | Word VBA | 2 | 07-10-2021 07:33 AM |
Mail merge to individual files, there's any kind of progress indicator | eduzs | Word VBA | 3 | 08-31-2018 08:46 PM |
Mail Merge Using Rules "IF" to add additional Text Based On Merge Field Content | Alfred | Mail Merge | 2 | 05-23-2017 10:59 PM |
VBA to automatically sort items based on Mail Merge field | taylorblu | Word VBA | 3 | 09-08-2014 09:52 AM |
Mail Merge To Individual PDF Files | iamrickdeans | Mail Merge | 1 | 01-15-2014 12:46 AM |