print certain number of records then next

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Onlyeyes - 29 Oct 2004 20:01 GMT

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

Reply to this Message

Cindy M -WordMVP- - 01 Nov 2004 20:13 GMT

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
[quoted text clipped - 3 lines]
>
> 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 :-)

Reply to this Message