Mail Merge

[adobriyal88]

I'm trying to mail merge what you see below on to Word.

MergingPractice.xlsm
	A	B	C	D	E	F	G
1	Customer	PO	Ship Date	Product	Cases	Units	Status
2	UNFI West	266505	27-Jun	Chocolate Granola	48	576	Completed
3	UNFI West	266505	27-Jun	Banana Granola	36	432	NC
4	UNFI West	266505	27-Jun	Blueberry Granola	48	576	NC
5	KeHe Arizona	1207536	29-Jun	Chocolate Granola	24	288	Completed
6	KeHe Arizona	1207536	29-Jun	Banana Granola	36	432	NC
7	KeHe Arizona	1207536	29-Jun	Berry Burst Snack Bites	90	540	NC
8	KeHe Dallas	2037201	27-Jun	Apple Cinn Oat Clusters	32	192	NC
9	KeHe Dallas	2037201	27-Jun	Chocolate Granola	64	384	NC
Sheet1

I want it to look like this on Word after I mail merge:

Priority #1 - UNFI West / PO 266505
Ship Date: June 27
Chocolate Granola: 48 cases - 576 units - Completed
Banana Granola: 36 cases - 432 units - NC
Blueberry Granola: 48 cases - 576 units - NC

Priority #2 - KeHe Arizona/ PO 1207536
Ship Date: June 29
Chocolate Granola: 24 cases - 288 units - Completed
Banana Granola: 36 cases - 432 units - NC
Berry Burst Snack Bites: 90 cases - 540 units - NC

Priority #3 - KeHeDallas/ PO 2037201
Ship Date: June 27
Apple Cinn Oat Clusters: 32 cases - 192 units - NC
Chocolate Granola: 64 cases - 384 units - NC

This is merge fields I have in Word:

Priority #1 - «Customer» / PO «PO»
Ship Date: «Ship_Date»
«Product»: «Cases» cases - «Units» units - «Status»

I'm not sure how you have Priority 1,2,3 etc come up for every unique Customer/PO/Ship Date. My problem is when I run it it puts every individual product on another page with Customer, PO and Ship Date whereas I want it too look like what I posted all the products under one unique Customer/PO/Ship Date and each Priority just goes one under another.

 

[GlennUK]

What defined what is supposed to be on one label? Is it per unique combination of customer and ship date? Or is it per PO number? Or what? Not that I can think of a way to combine multiple data table records into one merge record, so far.