Want to Repeat Records certain number of times

[davis]

Procedure: MailMerge
Word Version: Word 2000
OS: Windows 2000
DataSource: Word Document.

Problem:
I'm trying to do a mailing label mailmerge that will allow me to repeat a
record N times depending on a value in one of the fields. For example, I have
a numeric field called 'numberofcopies' and for each number of copies, I want
the record repeated in the merge. So if the value is 5, then I want that
record merged 5 times. I then want to look at the next record and find out
the value of 'numberofcopies' so that record will be repeat however many
times and so on. I want all these records to appear on the same page and not
on different pages. I have tried looking at vba scripting but with no
success. I know it is a FOR..Each loop I want in the main document but have
no idea how to put it in there. Any ideas?

 

[Doug Robbins]

There is no way that you can do that with mailmerge. It should be possible
however to create a macro that would do it, by iterating through the records
in the data sheet, getting the value in that field and then inserting the
data from that record into the cells of a table (label) in another document
the required number of times before moving onto the next record.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[davis]

Doug,
thanks for the reply. I'll give it a try.

davis