I am attempting to set up a Mail Merge using Excel and Word 2007 on Win XP.
The XL data file looks something like:
Name Jan 1 Jan 15 Feb 5...
Frank $100.00 $5.70
Ethyl $10.25 $15.35
Tony $23.00 $12.75 $50.35
The Word document is to include the dates and amount but only if the amounts are non zero.
For Frank the letter would include:
Jan 1 $100.00
Feb 5 $5.75
and Jan 15 would not be shown.
Jan 15 $10.25
Feb 5 $15.75
and Jan 1 would not be shown.
For Tony there would be all 3 items. The table actually contains many more rows and columns but the types of data are the same as shown above.
How do I set up the merge to show the dates and amounts for any entries where the amount is non-zero and not show a date with no amount where the amount is zero? I don't care whether it is a table or simply a list of dates and amounts.