Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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 "ll" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Word 2003 pulls up my mail merge template, but doesn't complete the merge into a new Form Letter 1 | Mailmerge | |||
Problem with merge data to word document merge field | Microsoft Word Help | |||
How to merge Excel chart for mass Word Mail Merge for employees | Mailmerge | |||
Printing a mail merge doc, merge fields print with grey background | Microsoft Word Help | |||
Insert Merge Field problem with Word-Mail Merge from Excel documen | Microsoft Word Help |