#1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
ll ll is offline
external usenet poster
 
Posts: 40
Default Merge

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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Merge

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2003 pulls up my mail merge template, but doesn't complete the merge into a new Form Letter 1 Sean Steele Mailmerge 1 April 12th 07 11:04 PM
Problem with merge data to word document merge field DB Microsoft Word Help 1 September 14th 06 11:18 PM
How to merge Excel chart for mass Word Mail Merge for employees hmboomer Mailmerge 3 June 9th 06 10:08 PM
Printing a mail merge doc, merge fields print with grey background Stanby Microsoft Word Help 1 April 12th 06 03:21 PM
Insert Merge Field problem with Word-Mail Merge from Excel documen Augusta E. Microsoft Word Help 2 June 20th 05 10:59 AM


All times are GMT +1. The time now is 02:03 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"