Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Need help creating a list sorted by category in Word
Hi all....
I'm trying to create a list of children to be picked up by parents. A single parent may pick up one or more than one child. I tried following the mail merge instructions on http://support.microsoft.com/kb/294686/ And did this.... {IF{MERGESEQ} = "1" "" "{MERGEFIELD "PickUp_Person"} "} {SET Parent1 {MERGEFIELD "PickUp_Person"} } {IF {Parent2}{Parent1} "First Child to be picked up: {MERGEFIELD Name_First} {MERGEFIELD Name_Last}" "Second child {MERGEFIELD Name_First} {MERGEFIELD Name_Last}" } {SET Parent2 {MERGEFIELD "PickUp_Person"} } I always get condition two (Parent2 = Parent 1). So it shows the parent and "Second child xyz" Then the next record again shows the same second parent and a new "Second child abc" I'm missing something simple here but can't seem to find it... Any help would be appreciated. Thanks, Mike |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Need help creating a list sorted by category in Word
Hi Mike,
Check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/cgi-bin/w3t/show...?Number=731107 The tutorial has working field codes and a sample data source. It also gives better results with Excel data sources than the MS example. Do read the tutorial before trying to use the mailmerge document included with it. -- Cheers macropod [MVP - Microsoft Word] wrote in message ... Hi all.... I'm trying to create a list of children to be picked up by parents. A single parent may pick up one or more than one child. I tried following the mail merge instructions on http://support.microsoft.com/kb/294686/ And did this.... {IF{MERGESEQ} = "1" "" "{MERGEFIELD "PickUp_Person"} "} {SET Parent1 {MERGEFIELD "PickUp_Person"} } {IF {Parent2}{Parent1} "First Child to be picked up: {MERGEFIELD Name_First} {MERGEFIELD Name_Last}" "Second child {MERGEFIELD Name_First} {MERGEFIELD Name_Last}" } {SET Parent2 {MERGEFIELD "PickUp_Person"} } I always get condition two (Parent2 = Parent 1). So it shows the parent and "Second child xyz" Then the next record again shows the same second parent and a new "Second child abc" I'm missing something simple here but can't seem to find it... Any help would be appreciated. Thanks, Mike |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Need help creating a list sorted by category in Word
Hi macropod
I tried using your tutorial and I'm having the same problem I had with my example. That is, if I take some code that should produce all the text on one page I get the first record on one page (city one, representative one) then on the next page I get the next record (city one, representative two), even though they should be on the same page. Page one These are the sales totals for ACT City Representative Sales Canberra Yang $2,100.00 Page two These are the sales totals for NSW City Representative Sales Coffs Harbour Roulston $4,000.00 Page three Dubbo Kristiansen $6,700.00 Page four Newcastle Avard $3,400.00 I made sure not to add the Quote 12 text or any other text to the mail merge. What am I doing wrong here? Thanks, Mike |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Need help creating a list sorted by category in Word
On 26 Feb, 12:20, Peter Jamieson
wrote: Your Mailmerge main document needs to be set up as a "Directory" ("Catalog" in old versions of Word). If it is set up as "Letters" you will get a section break after every record which will typically cause a page break. Peter Jamieson Thanks Peter....that was it. I was setting it up as a letter. I went back to my original "problem" document and merged it as a directory and then it was fine. It's always the little things that get you! Thanks again, Mike |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Need help creating a list sorted by category in Word
And, when they do, the first thing to do is RTM.
-- 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, originally posted via msnews.microsoft.com wrote in message ... On 26 Feb, 12:20, Peter Jamieson wrote: Your Mailmerge main document needs to be set up as a "Directory" ("Catalog" in old versions of Word). If it is set up as "Letters" you will get a section break after every record which will typically cause a page break. Peter Jamieson Thanks Peter....that was it. I was setting it up as a letter. I went back to my original "problem" document and merged it as a directory and then it was fine. It's always the little things that get you! Thanks again, Mike |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is There a Better Way to Create a List Sorted by Category? | Mailmerge | |||
Mailmerge to create a list sorted by category not working | Mailmerge | |||
How to use mail merge to create a list sorted by category in Word | Mailmerge | |||
Mailmerge to create list sorted by category not working | Mailmerge | |||
Mail Merge to Create a List Sorted by Category | Mailmerge |