Hello



I have been fighting with this for a long time and so finally came here to seek help from you people.

MS Office Version - 2013

I am trying to do a directory merge of sales records where item numbers under the same Order ID would be grouped together.

Please find attached a screenshot of how I want the final merge to be.

Also attaching the merge template and a sample source file.

I have gone through the directory merge document at https://support.microsoft.com/en-us/kb/294686 but unable to understand how to put it to work within my template.

What I want to do is this:-

If you open the sample data file, you will find two entries under Custom Label (Column #N) against the same Sales Record Number (Column #A).

I would like to group the Custom Label Entries together in a single label as is shown in the attached screenshot file.

Kindly advise on how I can do this.

Many Thanks

Attached Images

label-screenshot.jpg (15.8 KB, 13 views)

Attached Files

	merge-template.docx (46.0 KB, 9 views)
	Sample-data-file.xlsx (8.6 KB, 8 views)

Neither your data source nor your document lend themselves to the type of merge you wish to achieve.

However, if you add the address fields to your worksheet, remove the bulk of the document from the table onto the main document body, and add a single row table for the items with a second row under the table for the item count (you won't be able to count variable lists of items otherwise) then you can use http://www.gmayor.com/ManyToOne.htm to create the merge document(s), declaring the two listed fields as child fields.

Whether you can actually print onto the labels will rather depend on what format the labels are supplied as. Individual sheets should work.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com