If you need to print just a number of the copy when printing the same document, there is no macro needed. Save an excel file with a header and a column filled with serial numbers (i.e. "ID" in A1, 1 in A2, 2 in A3 etc.). Now you can do a mail merge using excel data as source, can be combined with any text (Copy no <<ID>> of 10). Send the mail merge to the printer, you can choose a range of records to print.
combo