Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 09-26-2018, 02:11 PM
Marcia's Avatar
Marcia Marcia is offline Macro to print a value in the duplicate and triplicate copies only Windows 7 32bit Macro to print a value in the duplicate and triplicate copies only Office 2007
Expert
Macro to print a value in the duplicate and triplicate copies only
 
Join Date: May 2018
Location: Philippines
Posts: 553
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to print a value in the duplicate and triplicate copies only Unable to get two copies of a table to print Enoch Word Tables 2 08-08-2018 03:55 PM
Print copies of onepage document with different text kciejek Word VBA 4 06-03-2014 03:21 AM
Macro to print a value in the duplicate and triplicate copies only Unable to print multiple copies zip p pong Word 1 03-16-2014 08:56 PM
Macro to print a value in the duplicate and triplicate copies only Mutliple copies 167 print as one document John-N Mail Merge 5 02-19-2012 07:15 PM
Print copies not resetting? denisep98 Word 0 09-14-2009 08:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft