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!
--
dab4211
"Doug Robbins - Word MVP" wrote:
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
"rfikes" wrote in message
...
I have an excel spreadsheet with 2 columns. One has a Name...the other a
Number:
John Doe 2
Jane Doe 4
etc.
The number represents the number of times the name needs to be
printed...for example....I need two sheets of paper with JOHN DOE
printed on it and four sheets of paper with JANE DOE printed on it. Is
there a way to do this with mail merge or any other method?
Thanks!
--
rfikes
------------------------------------------------------------------------
rfikes's Profile: http://www.officehelp.in/member.php?userid=4934
View this thread: http://www.officehelp.in/showthread.php?t=1250030
Posted from - http://www.officehelp.in