Will the thermal printer print 10 copies from any other app or printing source?
And from Excel you are just printing some "spreadsheet" that is open and needs to be printed out accordingly - correct?
I.e., File > Print > Copies (X) where X would be entered. For your requirements X = 10.
This thermal printer?
Did you create the spreadsheet or is the spreadsheet from some other source?
The root problem may simply be that the thermal printer uses and looks for a "cut" command between "pages"/"copies".
Excel may not be sending that and/or the printer drivers may not be recognizing whatever is sent.
The thermal printer has quite a command list per the ePOS-Print XML User's Manual. There is also a Software User's Manual.
= = = =
What you might need to do is create an Excel Macro that loops to print X number of copies but one copy at a time.
Start with a "2 copy Macro"
Perhaps something similar to what is presented in the following link:
Note the third example.
Should be straightforward to setup and test.
As a bonus you could prompt the User to enter "X" if X is not always going to be 10.