Merge

L

ll

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
 
D

Doug Robbins - Word MVP

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.

--
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
 
Top