Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Next Record If - MS Word mail merge
I've used "Next Record If" years ago without any problems yet now I can't make it work.. Can someone help?
This is a simplified version: I want to use mail merge let parents know what prizes their children have won. Main document: ---------------------------------------------------------------------------- Dear { MERGEFIELD Parents }, Congrats! Here are the prizes: { MERGEFIELD Child } { MERGEFIELD Prize } { NEXTIF { MERGEFIELD Last } = "" } { MERGEFIELD Child } { MERGEFIELD Prize } { NEXTIF { MERGEFIELD Last } = "" } { MERGEFIELD Child } { MERGEFIELD Prize } { NEXTIF { MERGEFIELD Last } = "" } { MERGEFIELD Child } { MERGEFIELD Prize } { NEXTIF { MERGEFIELD Last } = "" } { MERGEFIELD Child } { MERGEFIELD Prize } { NEXTIF { MERGEFIELD Last } = "" } { MERGEFIELD Child } { MERGEFIELD Prize } --------------------------- Data source: ------------------- Parents Child Prize Last John and Mary Peter train set John and Mary Lisa doll John and Mary Marc computer y Mike & Ann Tom book y Lisa Frida mobile phone Lisa Anna dress y Matt & Sarah Luke laptop y Frank & Rosie John monopoly Frank & Rosie Pat Disney trip Frank & Rosie Claire DVD Frank & Rosie Thierry wallet y Cindy Oliver book y ------------------- So the rule would be that as long as Last is empty the data (Child and Prize) of next record have to be merged in the existing document. If it's false then a new merge document willl be created for the data of the next record. In the example the comparison { MERGEFIELD Last } = "" } is true up to John and Mary / Marc.For John and Mary / Marc the comparison is false so this should trigger Word to create an new merge document for Mike and Ann. It is then for Mike and Ann false again so again an new merge document.. Then it's true for Lisa / Frida so Anna will come on the same page but Matt and Sarah start at a bew document etc.. Doesn't work.. The row with "y" is repeated to make six lines: Peter train set Lisa doll Marc computer Marc computer Marc computer Marc computer (next page) Tom book Tom book Tom book Tom book Tom book Tom book (next page) Frida mobile phone Anna dress Anna dress Anna dress Anna dress Anna dress |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Next Record If - MS Word mail merge
What you are trying to do is a "multiple items per condition (=key field)"
mailmerge which Word does not really have the ability to do out-of-the box. You can however do it by following the method on the following website: http://cornell.veplan.net/article.aspx?&a=3815 -- 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 "Marc Hendrickx" wrote in message ... I've used "Next Record If" years ago without any problems yet now I can't make it work.. Can someone help? This is a simplified version: I want to use mail merge let parents know what prizes their children have won. Main document: ---------------------------------------------------------------------------- Dear { MERGEFIELD Parents }, Congrats! Here are the prizes: { MERGEFIELD Child } { MERGEFIELD Prize } { NEXTIF { MERGEFIELD Last } = "" } { MERGEFIELD Child } { MERGEFIELD Prize } { NEXTIF { MERGEFIELD Last } = "" } { MERGEFIELD Child } { MERGEFIELD Prize } { NEXTIF { MERGEFIELD Last } = "" } { MERGEFIELD Child } { MERGEFIELD Prize } { NEXTIF { MERGEFIELD Last } = "" } { MERGEFIELD Child } { MERGEFIELD Prize } { NEXTIF { MERGEFIELD Last } = "" } { MERGEFIELD Child } { MERGEFIELD Prize } --------------------------- Data source: ------------------- ParentsChildPrizeLast John and MaryPetertrain set John and MaryLisadoll John and MaryMarccomputery Mike & AnnTombooky LisaFridamobile phone LisaAnnadressy Matt & SarahLukelaptopy Frank & RosieJohnmonopoly Frank & RosiePatDisney trip Frank & RosieClaireDVD Frank & RosieThierrywallety CindyOliverbooky ------------------- So the rule would be that as long as Last is empty the data (Child and Prize) of next record have to be merged in the existing document. If it's false then a new merge document willl be created for the data of the next record. In the example the comparison { MERGEFIELD Last } = "" } is true up to John and Mary / Marc.For John and Mary / Marc the comparison is false so this should trigger Word to create an new merge document for Mike and Ann. It is then for Mike and Ann false again so again an new merge document.. Then it's true for Lisa / Frida so Anna will come on the same page but Matt and Sarah start at a bew document etc.. Doesn't work.. The row with "y" is repeated to make six lines: Peter train set Lisa doll Marc computer Marc computer Marc computer Marc computer (next page) Tom book Tom book Tom book Tom book Tom book Tom book (next page) Frida mobile phone Anna dress Anna dress Anna dress Anna dress Anna dress |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
WORD 2007 mail merge - only one record | Mailmerge | |||
Word Mail Merge - Go back to first record | Microsoft Word Help | |||
word 2003 mail merge toolbar display record number | Tables | |||
word+excel mail merge omits 1st numeric record | Mailmerge | |||
sort mail merge by merge record number | Mailmerge |