Repeat data records for mail merge

[v]

I need to do a mailmerge that prints a single data record many times
(one record per page) before moving to the next record.

Each record has a field indicating the number of "copies" required. I
would like to make mailmerge grab that value for number of copies and
merge the same record for that specific count.

I know how to set up a counter, increment it, and compare it to the
value in the record. I cannot see any way to make Word print the same
record. Since each record requires a different amount of copies, I
don't see how a label would work.

Does anybody have any thoughts?

V

 

[v]

I already tried that. I need something a little more dynamic. My
data source has several hundred records, each of which needs to be
printed either 50, 70, or 80 times.

I want my user to be able to filter the data source for the record
they wish to print. I then want Word to see the number of pages that
need to be printed, merge the record that many times while
incrementing an id number for each document.

I could do this in Access but the output is not too great with a
specialty printer.

My workaround is to create a record for each document, but that is not
a long term solution.

 

[Cindy Meister -WordMVP-]

Hi V,

I think the only way you're going to be able to accomplish this with
mail merge would be a user-defined VBA function in Access that would
create the data set you need as a table (or export it in delimited text
format or Excel format). Unfortunately, I can't tell you the optimal to
do that, right off hand.

Otherwise, VBA automation (rather than mail merge) would be your other
possibility.

FWIW, about ten years ago, someone showed me once how to use the fact
that Access will generate duplicate records if you pull two tables
together in a query that are NOT "joined". But I can't recall the trick
that enabled you to set exactly how many duplicate records should be
generated for each single record...

I already tried that. I need something a little more dynamic. My
data source has several hundred records, each of which needs to be
printed either 50, 70, or 80 times.

I want my user to be able to filter the data source for the record
they wish to print. I then want Word to see the number of pages that
need to be printed, merge the record that many times while
incrementing an id number for each document.

I could do this in Access but the output is not too great with a
specialty printer.

My workaround is to create a record for each document, but that is not
a long term solution.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan 24 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