VB and Mail Merge Excel/Word

M

mr starface

I'm producing a number of Reward Statements. The data is held in Excel
and the Template in Word with one piece of data per line in a table
(Description and Value).

I'm mail merging the 2 together but for specific rows where the data
value is zero I need to delete the entire row in Word. I suspect there
is some sort of VB solution within Word that may work? Thanks for any
help!
 
B

Beth Melton

You don't need VBA for this. In Word all you need to do is add a filter for
your merge to supress the records so they aren't included in the merge.

If you aren't familiar with how to access the merge filter then we need to
know what version of Word you are using.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
Top