Mail merge question

[rfikes]

I have an excel spreadsheet with 2 columns. One has a Name...the other
Number:

John Doe 2
Jane Doe 4
etc.

The number represents the number of times the name needs to b
printed...for example....I need two sheets of paper with JOHN DO
printed on it and four sheets of paper with JANE DOE printed on it. I
there a way to do this with mail merge or any other method?

Thanks

 

[Doug Robbins - Word MVP]

I wouldn't do it with mailmerge. It could however be done with some vba
code. I would use a DocVariable field in the document and interate through
the data source setting the value of the variable to the data in the first
column and printing as many copies required by the number in the second
column before moving on to the next record in the data source.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[dab4211]

Thank you. I suspected I would have to go to either VBA or Access for this.
I have a couple of "Learn *** in 21 days" at home. I'll dig them out and
begin the learning. Thanks, again!