Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / September 2004

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Martha - 14 Sep 2004 06:33 GMT
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- - 14 Sep 2004 15:25 GMT
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
[quoted text clipped - 10 lines]
> 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 :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.