Directory MailMerge with Category Grouped Lists on Labels
Hello all,
First time here. I've searched around this forum for my answer and I have found a nice tutorial by Paul Edstein that describes how to create category-based lists. I have had success recreating the work in the tutorial and also applying it to my own list however I seem to be stuck with how to apply the categories to a document designed for labels.
I have an Excel table with a list of samples. The table includes a Box #, Project #, Sample #s, and a Date. I am hoping to use MailMerge as a tool to select which labels I would like to print from the directory, and then merge them on the Word Label Template and then print.
I have created a couple of test files for this and I am attaching them to this message. The XLS file is an example table of the data. I am also attaching the word document I using to Finish and Merge to a new document and create the labels.
The problem is that I cannot get the second sample information on the same box label. It always pushes it to the next label and it does not combine them. What I want it to look like is in the second Word attachment, called "Desired Result".
Is there a way to manipulate the form fields with this label template to group the samples by box on a single label as in the desired result? I feel that I have tried a combination of fields but still can't get the desired result. Thank you!
|