Link to home
Start Free TrialLog in
Avatar of qsysllc
qsysllcFlag for United States of America

asked on

Mail Merge with no blank lines for missing data

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.

For Ethyl:
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.
ASKER CERTIFIED SOLUTION
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of qsysllc

ASKER

The initial response from Graham Skan was very good.  It provided the strategy I needed.  The response from ProdOps was also helpful in that it helped me with the syntax.  One minor correction - I couldn't get the "<> 0" condition to work so I switched it to "> 0".

Thank you both for the help.