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!

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/

"mr starface" <mrstarface******.com> wrote in message
news:1168354222.607977.301580@38g2000cwa.googlegro ups.com...
> 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!
>

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/

"mr starface" <mrstarface******.com> wrote in message
news:1168354222.607977.301580@38g2000cwa.googlegro ups.com...
> 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!
>