making duplicate labels with excel and mailmerge

Thank you Jindon. That formula works fine. Someday I hope to figure out how BTW, it seems one needs to put the formula in the 2nd row in order to have a blank in the top position which the Word data file needs to properly feed the merge. I wonder how one could automate the fill down?

Quote from jindonDisplay MoreFollowing is the way to do it with the formula

1) Assuming original data begins from cell A1

2) Enter the number that you want to duplicate in cell C1

3) Enter following formula in first row in any column

=INDIRECT("A"&ROUNDUP(ROW(A1)/$C$1,0))

and then fill down as you want the data

I hope this will help you

Jindon