Labels - what command to use to go to next label?

[Martha]

Hi - I'm using mail merge on a pivot table output - e.g.
when 3 people are sitting at a table, there would be three
entries, but if 9 people are sitting at a table, there
need to be 9 entries. I have figured out how to use "next
record if" so it'll scroll through the records within a
label, and when it reaches the condition that makes it not
read any more records (until the next label), it just
repeats the same info until it reaches the maximum
possible I've allowed (12). I could do this also using If
then else, nesting 12 commands, but it's not clear to me
what command makes it move on to the next label. If I only
want three entries, I'd like it to just move to the next
label upon a certain condition, rather than repeating last
line 9 more times. Thanks for all the great advice!

 

[Cindy M -WordMVP-]

Hi Martha,

I'm not sure I follow exactly what you want, but this sounds
a lot like a "one-to-many" type of merge. There's a Knowledge
Base article on how to get Word to loop through records until
a certain condition changes. You'll find a link to it in an
article in the Special Merges section of my website.

I'm using mail merge on a pivot table output - e.g.
when 3 people are sitting at a table, there would be three
entries, but if 9 people are sitting at a table, there
need to be 9 entries. I have figured out how to use "next
record if" so it'll scroll through the records within a
label, and when it reaches the condition that makes it not
read any more records (until the next label), it just
repeats the same info until it reaches the maximum
possible I've allowed (12). I could do this also using If
then else, nesting 12 commands, but it's not clear to me
what command makes it move on to the next label. If I only
want three entries, I'd like it to just move to the next
label upon a certain condition, rather than repeating last
line 9 more times.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail