Partial page printing.

[Jim Bob]

I am using Win98 and Word 97 SR-1

I have created a data source which was query fields which I can pair down
the data I want for a specific merge.

My template is for a 6 label form in the following layout

«Company» | «Next
Record»«Company»

«Next Record»«Company» | «Next Record»«Company»

«Next Record»«Company» | «Next Record»«Company»



If I print a merge that ends on the last page with only 3 labels used,
How do I start my next merge to utilize, say the last 3 labels remaining on
the page?

 

[Cindy M -WordMVP-]

Hi Jim,

If I print a merge that ends on the last page with only 3 labels used,
How do I start my next merge to utilize, say the last 3 labels remaining on
the page?

Mmm, it can be done, but it's finicky. Basically, you need to include as many
"empty" records at the "top" of the data list as you have labels you want to
skip.

If your data source were an Excel file, you'd simply insert empty rows.

For an Access database, create an additional Table that contains the same
fields as the table you'll get the data from. Add five records (for 6 labels,
max/sheet) that have primary key values that will be either below or above
those for the data source; all other fields are blank. do a UNION query to
bring the two tables together. Sort on the Primary key, and set a criteria to
include only the records > (or <) than the value of the primary key that will
give you the number of empty records you need.

You get the idea

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

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