Want to Repeat Records certain number of times

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

davis - 16 Feb 2005 01:27 GMT

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?

Reply to this Message

Doug Robbins - 16 Feb 2005 02:27 GMT

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.

Signature

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

> Procedure: MailMerge
> Word Version: Word 2000
[quoted text clipped - 16 lines]
> have
> no idea how to put it in there. Any ideas?

Reply to this Message

davis - 16 Feb 2005 20:21 GMT

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

davis

> 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
[quoted text clipped - 22 lines]
> > have
> > no idea how to put it in there. Any ideas?

Reply to this Message