print certain number of records then next

[Onlyeyes]

I have a label mail merge set up where after each page, it goes to the next
record. What i would like it do now is to print out each page a certain
number of times automatically. For example, it would print the first page
102 times, the next one 75 times, etc based on a "count" field on the
spreadsheet data source.

Any thoughts?

-Andy

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?T25seWV5ZXM=?=,

I have a label mail merge set up where after each page, it goes to the next
record. What i would like it do now is to print out each page a certain
number of times automatically. For example, it would print the first page
102 times, the next one 75 times, etc based on a "count" field on the
spreadsheet data source.

Any thoughts?

Word just isn't built to work this way. You'd need either

1. A macro in the data source (Excel, in this case) that copies the entries
the required number of times into a new (temporary) sheet, and merge to that

OR

2. Avoid mail merge and do the whole thing using VBA (automation)

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