Supress blank fields in merged doc

[Ralph Long]

I can't seem to find an answer to this, but it may exist elsewhere. I a
trying to create a packing slip using a Word doc using an Excel sheet a
the merge source. On each row of the Excel sheet, I have the recipien
name, address, etc and at the end of each row, i have 8 rows that list
quantity for a particular item. I have the merge fields set and it i
working except I need to be able to skip the items that don't list
quantity (blanks). The blank fields may occur in the middle of the row
For example.


5 Yr 10 Yr 15 Yr 20 Yr 25 Yr 30 Yr 35 Yr 40 Yr 45 Yr 50 Yr
3 3
5 "blank" 2 1 1 1
2 2 2 1 1

What I end up for the second row above is this:

Quantity Unit Item No. Description
5 5 Year Pin
2 10 Year Pin
1 15 Year Pin
1 20 Year Pin
1 25 Year Pin

Instead of the correct:

Quantity Unit Item No. Description
5 5 Year Pin
2 15 Year Pin
1 20 Year Pin
1 25 Year Pin
1 30 Year Pin

If I have to manually place the labels (5 year pin, etc) on the mai
document, I can do that, but the merge would have to insert a spac
where the empty cell is so the alignment will work correctly.

Any Help would be GREATLY appreciated