[SOLVED] Excel & Epson Receipt/Thermal Paper Copy Issue

[mrmaruniversal]

Trying to print multiple copies of thermal paper from an EPSON TM T88V on Excel. I have tried multiple different printing options and nothing seems to work. I ask for 10 copies and it will only print one. Anyone know what's going on? I assume they might not be compatible.

 

[jojesa]

Did you happen to download the latest drivers from Epson and install it following the steps on the printer manual?
The printer should not be connected to the PC until you are asked to do so during the drivers installation.

 

[Ralston18]

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?

https://epson.com/Support/Point-of-...Epson-TM-T88V-Series/s/SPT_C31CA85011#manuals

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:

https://learn.microsoft.com/en-us/office/vba/api/excel.sheets.printout

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.