(Advanced) opens the Filter and Sort dialog box, which you can use to filter using multiple criteria. You also can click Filter under Refine recipient list in the Mail Merge Recipients dialog box to open the Filter and Sort dialog box.
Thanks I have my word ticket page set up with the code you gave me. Thank you in advance. I need to set up the mail merge so I can print blocks of tickets off as I need them. How do I go about setting this up? Do I have to have a stub, ticket format like the original ticket format?
For a ‘small society lottery’ (tickets sold in advance), tickets must show the name of the promoting society (and the purpose of the lottery), the ticket price, the name and address of the organiser and the date of the draw.
Louise Balle has been writing Web articles since 2004, covering everything from business promotion to topics on beauty. Her work can be found on various websites. She has a small-business background and experience as a layout and graphics designer for Web and book projects.
First, create a numbering “list” by choosing Type > Bulleted & Numbered Lists > Define Lists. Then click New to create a new list. You can name it anything you want, but make sure the Continued Numbers across Stories is enabled:
For Raffle tickets, you will have two placeholders. One for the ticket itself, and the other which is for the piece that is given to the individual who purchases the raffle ticket. This is where you want your sequential numbers to appear on your ticket
Easy Numbering 123 is named appropriately. I downloaded the software and tried 1 test job. I printed out a bunch of sample tickets with no problem. It’s just one job, but tickets don’t get to complicated so it should work for us too.
On an e-ticket receipt, the airline code and ticket number is located at the bottom center of the receipt. In this example, you would enter 2150030834 in the ticket number box. The 001 is already provided to the left of the box if American Airlines is selected as the airline flown. Enter the 3-digit airline code preceding the ticket number if any other airline is selected. The 4 at the end is for internal use only.
I then let InDesign CS4 do the merging. Here’s the formula. This solution will work for printing tickets 4up on an 8.5 x 11 sheet. In Excel, I created a file with columns A-H labeled: ticket 1, stub 1; ticket2, stub2; ticket3, stub3; ticket4, stub4.
Select the Text Tool (T) and start dragging a text box that will wrap around the whole ticket including the crop marks. This is very important since the Data Merge will automatically calculate the duplication. Then open up the Text Frame Option (Command + B) and set the Inset spacing to 1p4 for the top and 1p8 for the left. Of course, you can place the text for the numbers anywhere you like. I set the numbers to a small text.
It is beneficial to have a variety of prizes to include on the raffle ticket template so they appeal to a diverse population of attendees. Many businesses or volunteers will be willing to donate prize items.
Open a new blank document in Word. Create two raffle ticket designs, one for the person who buys the ticket and one for the organization selling them. Make sure to connect the two tickets, for example by making them in two-cell tables, side-by-side. Include the name of the organization, perhaps the first prize, and any other information you want on the buyer’s ticket. You might, for example, include spaces for the buyer’s name (“Name__________”) and phone number on the organization’s ticket. On both tickets, enter a dummy number for the raffle ticket number as a placeholder.
Now for the tricky bit. Mail Merges usually have the one ‘recipient’ per page. So Word won’t pick out the next number in your list until it gets to a new page. By default, it’ll print you four tickets on each page, all with the same number. Then a new page, all with the next number. Etc.
I have done this twice now, getting flustered. The ticket part the person keeps has the correct sequential number on it, but the side that we keep has the same number on it for the whole page. What part am I missing, at first I did not uncheck the box, but this time I did but have the same number on the stub side that we keep with the person’s name, etc
Now, you’ll define the actual merge values. In this case, it’s the Ticket Numbers field in the selected Excel workbook. Drag the Ticket Numbers field from the merge pane to the document (Figure G). After dropping the field control, I pressed [Enter] to replace Microsoft with the <
This is all helpful, but I still have yet to get it to work. I am printing them on one of our http://thedailyrant.net 700 Digital Presses, I will be cutting them with a shear cutter. Our main work is Large/Grand format digital printing.
Football, Baseball, Raffles, Prom, Graduation the list goes on. The worse part is each is different and has to have x number in this color that color it can be very frustrating. Then to top it off I have the most random number of requested tickets sometimes and it was extremely difficult to find a method that worked and yours did!
Gift certificates and promotional coupons can play an important role in your marketing strategy by drawing new and repeat customers to your business. However, how can you tell if they are really working to help you develop your business? To make the most of your time and your marketing budget, you need to track the success of your marketing efforts so that you can determine what marketing tactics are effective for which customers.
My solution for this when trying to add a number on a page between already existing numbers where to usa a current text frame of the previous number and create a new list object from there. And then I would overset that text and press the overset +-sign to place it on the page. Works perfect.