Thanks for the reply - I have tried to do those steps but I must be doing something wrong.

The product name isnt in the word file - I want the merge to bring that in If there is a value in that column OR leave it out and not leave a blank line just go to the next item in the list.

This is how my sheet table is laid out:

Customer Water Wine Beer
ABC $22.00 $25.00 $0.00
DEF $0.00 $44.00 $0.00
GHI $0.00 $0.00 $23.00

I need to know how the merge field codes look to get the following outcomes:

(Customer ABC should merge the NAME of the product AND the Price)

Water $22
Wine $25

(Customer DEF should merge the NAME of the product AND the Price)

Beer $23

Ill keep playing with it to try and make it work.