i’ve had to do tons of this lately and found that for the amounts of tickets being done (e.g. 7000 x 10 tickets + cover & mailer) that chuckT’s solution almost 2 years ago is similar to what i use. would be interested to know if others doing similar VDP are using a wholly indesign/excel solution, or if specific VDP software such as XMPie are being used.
Given that Word can support 2,147,483,647 SEQ fields, the whole job could be done in a single document containing 30,000 tickets. On my system, creating such a document took only a few minutes and, once created took about two minutes to update the fields - and that was with about 40,000 pairs of SEQ fields coded as {SEQ Ticket \# 00000} and {SEQ Ticket \c \# 00000}. This number formatting is enough to go to 99,999 tickets.
PS: 1. Tough and Tricky questions; 2. Hard questions; 3. Hard questions part 2; 4. Standard deviation; 5. Tough Problem Solving Questions With Solutions; 6. Probability and Combinations Questions With Solutions; 7 Tough and tricky exponents and roots questions; 8 12 Easy Pieces (or not?); 9 Bakers' Dozen; 10 Algebra set. ,11 Mixed Questions, 12 Fresh Meat
There’s an old Steve Martin joke about how to make a million dollars which starts, “First, get a million dollars…” That’s the key to this trick, too: First, get a bunch of numbers. Here’s a file with 1,197 numbers in it. Now import or paste those numbers into a thread so that the numbers appear in the right place. If you need two matching numbers, just import it twice.
Drag your cursor on the Font toolbar on the top of the ms word document and formulate necessary alterations. If you are troubling to find ways to include images to make your ticket look appealing and rich, then you need not worry. Just put your cursor on the Insert option in the tool bar and hit on it to add appropriate images befitting the occasion.
This program makes you adept for not only creating event tickets but also generating attractive resumes and different menus. What you need to do is to find the appropriate Microsoft template and include the desired texts in the blanks available. The program then allows you to opt for the color of your choice .subsequently you can either save the template as a file or you can click on the print right away.
Permalink Peter, I have done the "master" function successfully. It appears to work.I ran a form job to the press with a large quantity of numbers successfully. Thank you. A full color ticket job with only two hundred sheets did create a large file in my print que however, and feed very slowly. Can you tell me; Does Indesign still create an image for each sheet when printing? I am still a bit confused about the threading technique you mentioned. Would this create an easier feed to the printer or "smaller" file size?
You’re selling raffle tickets to make money, so why buy the tickets pre-printed? Using Microsoft Word’s mail merge function, you can create your own raffle tickets and design them any way you please. A mail merge doesn’t have to make mail; it is simply a way to define certainly elements of a document, then automatically insert variable elements, such as raffle ticket numbers. The most important thing to remember is that each ticket needs a mate–you don’t want to pull winning ticket number 81018 only to find that no one bought that one.
With all of the many available templates, how do you select the right ticket design? It’s a good idea to choose a design featuring a background image that in some way fits with your fundraising purpose. This ties your efforts together in a cohesive way, making your tickets more attractive to buyers. A good design gives potential buyers an idea into the type of cause they’re supporting right off the bat.
That’s enough tips for now. You’ll be filling your fundraising thermometer template How to Create Your Custom Excel Fundraising Thermometer Template How to Create Your Custom Excel Fundraising Thermometer Template Use an Excel thermometer chart to visually keep track of your financial goals. Whether you're saving for a new gadget or fundraising for a good cause, here's a step by step tutorial. Read More in no time. Let’s get to the tickets.
The very first step you need to do is to drag your cursor towards the Help icon in the new word document. This icon usually appears in the right part of the top portion of the tool bar listing. It is depicted by a question mark symbol. You have to left click on this menu with your mouse and you need to opt from the type of help listed in the drop-down carte du jour. (Ticket Invitation Templates Download)
We recently had to print 500 numbered tickets 8 up on 8.5 x 11. When we took it back to Bindery they would have had to hand collate the tickets back in order after the cut. So we came up with a way that when each stack was cut they would simply be stack on top of each other. We couldn’t figure out a way to add 8 sets of grouped numbers to 8-up layout so I had to go into the txt file and number it manually. It worked fine but took a little time. Is there an option to pull 8 different sets of numbers to one page?
You need to create a list of numbers using some method (maybe even through VBA) as a text file, database or other data source, then just insert merge field in the document and use Print Merge to generate multiple labels with different numbers in it. (just need to give it enough space to fit the longest string along as many lines as you think there could be) If I reserve space for 50 chars and the major strings are 25 chars, the result is not professional looking. My solution for all print merge for ID cards (and similarities, incl. Auto numbering) is to merging data BEFORE printing, in an CDR file with all pages. So, I check all the cards and I correct only on text object how need. I found an software with this capabilities, but 300 USD is excesive (not only for Est Europe) for one only week of working (yes, his UI is better than my). I found an software with this capabilities, but 300 USD is excesive (not only for Est Europe) for one only week of working (yes, his UI is better than my) And my script use photo also.
In Excel, I created a file with columns A-H labeled: ticket 1, stub 1; ticket2, stub2; ticket3, stub3; ticket4, stub4. I then numbered two rows across 1 -4, then 5 -8. Then I dropped down to A – H in row 260. (I did this to give 1,000+ numbered tickets.) I then used the Excel fill function chosing series and told the program to skip by 4. It filled the rows. I then saved as a tab delimited text file.
Permalink Peter, I have done the "master" function successfully. It appears to work.I ran a form job to the press with a large quantity of numbers successfully. Thank you. A full color ticket job with only two hundred sheets did create a large file in my print que however, and feed very slowly. Can you tell me; Does Indesign still create an image for each sheet when printing? I am still a bit confused about the threading technique you mentioned. Would this create an easier feed to the printer or "smaller" file size?
Create your first ticket, without the numbering. Then where you want the number to appear first, press Ctrl-F9 to create a pair of field braces (ie '{}') and fill in between them so that you get '{SEQ Ticket \# 00000}'. Then, where you want the duplicate number to appear, create another field and fill it it so that you get '{SEQ Ticket \c \# 00000}'. From there it's mostly just a matter of duplicating the whole ticket however many times you want. When you're done press Ctrl-A to select the whole document, then press F9 to update the fields.
Microsoft Publisher, the desktop publishing component of the Professional version of the Office Suite, can perform many time-saving tasks for busy business owners, including layout and design work. It can even help you avoid a shopping run to try to find tickets for your next employee picnic, holiday giveaway or executive board meeting. Create your own tickets, including the vital sequential ordering needed for raffles or attendance tracking, using Publisher’s page numbering. With a few tricky manipulations of the page number process, you can start running the numbers in an entirely new fashion.
Permalink Peter, I have done the "master" function successfully. It appears to work.I ran a form job to the press with a large quantity of numbers successfully. Thank you. A full color ticket job with only two hundred sheets did create a large file in my print que however, and feed very slowly. Can you tell me; Does Indesign still create an image for each sheet when printing? I am still a bit confused about the threading technique you mentioned. Would this create an easier feed to the printer or "smaller" file size?
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139
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.
But it’s not hard to duplicate and reduplicate until you have a thousand or more numbered tickets. I think the conclusion of all these Rube Goldberg approaches is that InDesign still isn’t ready for handling what is really a head-smacking-stupid-simple kind of numbering job — the kind of jobs computers were created for in the first place. My DOS word processor XyWrite — from AD 1987! — could do numbering stuff like this in no time and with no trouble. Quite ridiculous, really, when you consider the staggering graphics and typography capabilities inside InDesign — but the poor thing cannot really count. I handle this much differently. I create a number list in Excel and save as a txt file.
Another fan of Fusion Pro Desktop here. This is exactly what you need. We have sold both PrintShop Mail and Fusion Pro Desktop for this very application (numbering) and other VDP applications. Fusion Pro Desktop easily beats PrintShop Mail from both a price and performance viewpoint. You could also try Printer's Bench http://www.elkriversystems.com/ProductsList.aspx for a good entry level package
i’ve had to do tons of this lately and found that for the amounts of tickets being done (e.g. 7000 x 10 tickets + cover & mailer) that chuckT’s solution almost 2 years ago is similar to what i use. would be interested to know if others doing similar VDP are using a wholly indesign/excel solution, or if specific VDP software such as XMPie are being used.
Adobe, I expected better! Hi Folks, I’d like to share my solution. It came to me partially in my sleep, I tried refining it this morning but because of time, finally had my production person print the manually numbered tickets so that we could deliver them to the customer who needed them today. Here is my solution. I deduced that it would be better to let a program designed to count, do the counting. I used Excel.
Word templates are wonderful things. Microsoft, and hundreds of other people, have created some great free templates for almost everything. With these free templates you can make meeting agendas The 15 Best Meeting Agenda Templates for Microsoft Word The 15 Best Meeting Agenda Templates for Microsoft Word These meeting agenda templates for Microsoft Word can get you off to a great start for any type of meeting. Read More , beautiful flowcharts How to Create Stunning Flowcharts With Microsoft Word How to Create Stunning Flowcharts With Microsoft Word Used with imagination, flowcharts can simplify both your work or life. Why not try out a few flowcharts with one of the easiest tools on hand – Microsoft Word. Read More , professional resumes How to Create a Resume Template with Microsoft Word How to Create a Resume Template with Microsoft Word Your resume could be the difference between interviewing for the job of your dreams or never hearing back from the employer — use these tips to make sure it's the best it can be. Read More , and custom calendars 10+ Sites to Find the Perfect Free Printable Calendar Template All Year Long 10+ Sites to Find the Perfect Free Printable Calendar Template All Year Long You can never have enough reminders that your most valuable personal resource is limited. Our selection of printable weekly, monthly, and yearly calendars will help you manage your time wisely. Read More in minutes. A custom calendar might be a good fundraiser, too!
