How to generate receipt book using mail merge, is one of the best tricks in your bag if you run a stationary business.
If you have clients who need receipt books this may be time saver, you not only produce high quality receipt books but also top of the line receipt books.
Normally you could use Adobe Illustrator, Photoshop, and InDesign to accomplish this task; however you will have the uphill task of engrossing the receipt numbers which takes about 35 Minutes, in addition to 5 minutes to perforating the pages.
Using the method here, you will only use 5 Minutes for perforating the pages.
Requirements:
- 1. Office 2007 and above
-
- 2. Epson L382
Steps:
- Design the receipt paper as you would in Adobe Illustrator, Photoshop, and InDesign. It would be easier if you use textboxes without fill.
- Create an excel workbook having columns equivalent to the number of receipts on the paper i.e if a page has 6 receipts then the work should have 6 columns.
- Fill the column A with the first receipt number
- Copy and paste =A2+1 to B2, =F2+1 to A3, drop and fill to row 50 if you want 50 pages.
- Save your work book where it’s accessible.
- Open you receipt template click mail merge
- Select recipients and click use existing list. Locate and load it.
- Position the cursor where you want the numbers to appear then click insert Merge field and select your first receipt number.
- Repeat step 8 for all receipts
- Click finish & merge select edit individual document
- Print as you like
You can use the attached templates
