dynamically inserting/deleting table rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DeepThought - 30 Jul 2007 14:52 GMT

If there is no data in the merge field in my data source, I want the blank
row to be deleted allowing the next row containing data to move up into where
the blank row used to be.

How do I do this?

Reply to this Message

Doug Robbins - Word MVP - 30 Jul 2007 20:55 GMT

Use an If...then...Else field construction in the mail merge main document
that tests for the existence of data in the field

{ IF { MERGEFIELD field1 } = "" "{ MERGEFIELD field2 }" "{ MERGEFIELD
field1 } <Enter>
{ MERGEFIELD field 2 }" }

Press the Enter key (or Shift+Enter) in place of <Enter> above so that the
{ MERGEFIELD field 2 }" } is on a separate line.

You must use Ctrl+F9 to insert each pair of field delimiters { } and Alt+F9
to toggle off their display.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> If there is no data in the merge field in my data source, I want the blank
> row to be deleted allowing the next row containing data to move up into
> where
> the blank row used to be.
>
> How do I do this?

Reply to this Message