Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ll - 15 Apr 2008 17:19 GMT

I have a large table. One of the fields is "Plan", another is "CCs". I'd
like to know if it's possible to generate a document where the name "Smith"
comes up in the CCs column and the name of the plan associated with Smith,
which would be in the "Plan" column?

Any help appreciated. Thanks, ll

Reply to this Message

Doug Robbins - Word MVP - 16 Apr 2008 10:43 GMT

Manipulation of data in such a manner is a lot easier in the data source
than trying to do it when doing the merge in Word.

However it you put the following fields at the beginning of the merge main
document, it should skip over the records that do not meet that criteria

{ SKIPIF { MERGEFIELD "Plan" } <> "Smith"}{ SKIPIF { MERGEFIELD "CC" } <>
"Smith"}

You must use Ctrl+F9 to insert each pair of field delimiters { } and you use
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

>I have a large table. One of the fields is "Plan", another is "CCs". I'd
> like to know if it's possible to generate a document where the name
[quoted text clipped - 3 lines]
>
> Any help appreciated. Thanks, ll

Reply to this Message

Rate this thread: