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

mrmaruniversal

Distinguished
Dec 29, 2016
99
5
18,545
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.
 
Solution
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...

Ralston18

Titan
Moderator
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.
 
Solution