Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #21  
Old 10-23-2012, 04:59 PM
macropod's Avatar
macropod macropod is offline Numbering Receipt Books Windows 7 64bit Numbering Receipt Books Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,512
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

I've cobbled something together based on your text file and the image you originally posted. See attached.

The file uses a macro to print the receipts, four to a page with the number sequencing as you described. Another macro is included to allow you to easily re-set the number sequencing.

To access the macros, open the document and press Alt-F8. You'll see two macros - ReceiptPrint and Reset. Double-clicking on on of them will run it.

The ReceiptPrint macro asks you to provide the first and last numbers. The macro has some internal logic to ensure that, regardless of what you input, the first number will end in 1 and the last number will end in 0. Thus, with four receipts per page, whatever is printed will be in multiples of 20 receipts, spanning multiples of five pages. The minimum you can print is 20 and the maximum is basically whatever your printer can handle. If you print receipts 1601-2000 in one go, you'll get a 100-page printout. The first quarter of the number range will be printed in the upper left corner, the second in the upper right corner, and so on.

The numbering on the pages is handled by some field coding. Pressing Alt-F9 will toggle this on/off.

I realise the mock-up in my attachment isn't going to match whatever you're using. You can copy/paste your own content into the document and delete mine (just remember to preserve & relocate the fields first!!!).

The Reset macro allows you to reset the starting # without having to produce a printout.
Attached Files
File Type: doc Receipts.doc (130.0 KB, 36 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Delay sending the read receipt Rita Outlook 1 10-04-2012 08:46 PM
New Idea for Delivery Receipt BrazzellMarketing Outlook 0 01-13-2011 03:44 PM
Read Receipt not working Dawn1231a Outlook 0 08-05-2010 07:40 AM
Read Receipt lfreng Outlook 0 04-11-2006 10:37 AM
Self Help Books for Macros? KRB Excel 0 11-22-2005 01:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:28 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