View Single Post
 
Old 09-26-2018, 02:11 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2007
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

[QUOTE=trevorc;133735]
Quote:
Originally Posted by Marcia View Post
One of the office tasks is to print check payments.

You don't need a macro, just setup 3 copies of the receipt (after doing a print preview you will see the printer margins, use these to place your extra 2 copies and were there is a duplicate serial put in it's place =E3. Then print the sheet and you should get 3 copies.
Thank you Trevorc, your suggestion never entered my mind. We had been manually typing and deleting the serial numbers. The checks however are printed vertically so I spent time adjusting the margins to get the page accommodate three copies. Again, thank you.
Reply With Quote