I answer readers’ questions about Microsoft Office when I can, but there’s no guarantee. When contacting me, be as specific as possible. For example, “Please troubleshoot my workbook and fix what’s wrong” probably won’t get a response, but “Can you tell me why this formula isn’t returning the expected results?” might. Please mention the app and version that you’re using. I’m not reimbursed by TechRepublic for my time or expertise, nor do I ask for a fee from readers. You can contact me at email@example.com.
Go to “Format” and “Background” to change or add a background to the ticket. The options for the different types of backgrounds will appear in the box on the left side of the screen. Click on one to apply it to the ticket.
It’s pretty easy in Excel. Take your number of tickets you’ll get on a sheet, divide 20000 by that number. That will be your number of rows. Type a 1 in the A1 cell location, type =(A1+1) in the A2 cell location. Paste that in as many rows as you determined. Copy the last cell in your first column. Paste that in cell B1. Copy B1 and paste in as many rows as you had in Column A. Copy column B and paste in column C. Copy C and paste in Column D. Repeat as many times as you have tickets on a sheet until you have enough columns as you do tickets on a sheet. Save as Tab deliminated text and bring into data merge on an imposed sheet. Data merge should be able to build you a document easily with as many sheets as you need and on a 1 knife trimmer you should have neatly stacked tickets in order.
If running a raffle where tickets are NOT sold before the event, this falls under the terms of an ‘incidental non-commercial lottery’. As such, you will not require a licence or any specific permissions. However, you must adhere to the following rules:
10% Discount for Nonprofits and Schools Forest Stewardship Council 100% Wind Powered UPS Carbon Neutral Shipment Trusted Security 100% Satisfaction Guarantee Better Business Bureau Accredited Business
Enter your own text into the template once it is opened in Publisher. Click in the text boxes on the template to enter text. To change the color of the text, highlight it and use the tools under “Format” and “Font” to change the font color.
Was very easy to use and the tickets looked great. Unfortunately, when I went to print them, there is a fee. I am doing this for a non-profit group and I personally do not have the funds to do this. Maybe something before we get to the print page would make for a lot less frustration which generated negative feedback. The tickets look great otherwise and was very easy to do.
I have the first sheet with numbers up to 80. Now, how do you go from 80 to the next 160 for the next sheet? Once it gets to what should be 90 on the second sheet, it goes to 810 and so on. It adds a “0” to the same numbers.
Now for the slightly hard bit. If you just try and complete your merge now, you’ll get several pages of tickets. Each page will have four tickets on it. But all tickets on any page will have the same number. Each page will have a different number, but all the tickets on that page will have the same number. That’s no good. You need each ticket to have a different number.
My tickets only printed two per page, in the first and third spits of the letter sized page. They did print properly/sequentially ordered however. Any suggestions as to how to get four tickets per page?
Number-Pro can be used to create unlimited amounts of the numbering mail merge file you need. This is great for small print shops, non profit organizations that do there own tickets. Using your own home or office printer you can number your own raffle tickets.
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.
We use the auto page numbering trick here, the trick is to do it as spreads. You just make your pages the same size as the ticket with crops and bleeds. Then set up the shell on the master page and place your auto page number where you want your numbers. Each pages is the next number. You can also have two sets of numbers for perforated ticket. You then can use the page start options to add to the numbers and keep the same number of total numbers. For example you would do a new page start after number 99. 0001 to 0099 so it doesn’t add two “0’s” to the front of 100 and you get 00100 when you want 0100. Works great for small quantities, we have done up to 1000+ tickets and once you do it once or twice it is a snap to set up. To avoid having to do 1000 pages just send the tickets in groups. Usually between 25 to 100 at a time works good depending on artwork file size. Just save each time before sending to printer and name the file with what the tickets are. Like “MyTickets-0001-0100.Indd”. Makes it easier to go back if you have a problem. You can even do two rolls of tickets if your using 12 x 18 sheets by flipping the sheet and doing one row along the top and one along the bottom on reverse side. That is if your ticket is single Sided. Two sided tickets are a bit trickier. 🙂
Print using a template. If you’re printing over a computer, you don’t need to design the tickets from scratch. There are templates specifically designed for raffle draws. Look up one of these templates and print rows and columns of them onto as many printer sheets as you need. You can take the image and type the necessary information as needed via a Word processor. Print off a sheet and have it ready.
In the Mail Merge task pane, in the list under Prepare your publication, locate the field name that corresponds to sequential numbering column heading for the list of tracking numbers in your data source. For example, if you used Tracking Number as the column heading for the list of tracking numbers in your spreadsheet, locate Tracking Number. Drag the tracking number field into the text box that you created for it.
If you figure how many you have on a sheet that will be printing and the location it is pretty easy. I just do a quick round of numbering with Excel so the stacks come out in order. I haven’t found a way to get InDesign to do this, but I regularly have to do this for a couple of tickets and gift certificates.
If you’re intent on doing your tickets by hand, it’s recommended that only one person make them. That way, the handwriting will be consistent for each one, and it will be easier to spot a dupe if one occurs.
If you have already developed a set of specific code numbers that you want to use to track and categorize customer responses, you can type these numbers into a column of the data source that you plan to use for the mail merge.
The next step is to create the simple Excel workbook that contains the ticket numbers. Open a blank Excel sheet. Using Figure B as a guide, create the ticket numbering sheet and save it, making sure to note the new workbook’s name and location. As we discussed earlier, the Excel workbook stores the ticket numbers. In this example, we’ll create 11 tickets numbered 100 through 110. You’ll need to update the ticket values for each merge.
Since it’s a group of people who have chosen to raise fund using this means the format of the raffle ticket has to be the one agreed upon by the group. The initial stages will thus be those of trial and error as each person will have his/her own opinion of what should be the format and design of the raffle ticket. This site recognizes that such challenges exist and the raffle ticket templates that we offer you will be in a design and format that most if not all of the people will fall in love with. After a certain format is accepted by everyone you will not have to worry about how to come up with new raffle tickets as these can be used over and over again.
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.
Deacon Martha Jane Dunphy, Deacon Ms. Maria Campos, Secretary, ext. ext 18 Mr. Arturo Ortiz, Director of Music, La Gracia Ms. Marilyn Castillo, Vocalist, La Gracia THE WORD OF GOD The First Reading Acts 2:1-21 When the day of . For raffle tickets, please see members of Caribbean Ministries in the parish hall
data merge can be a little tricky for this. Try making a single ticket at the top of your page (not on the master page). Put your merge fields into this ticket. Then when using data merge click the option to put more then one per a page, preview and see if this does what you want it to do. Granted if you have double sided printing, data merge gets very tricky, but can be done.
The tickets were printed exactly as ordered and arrived on the day they were scheduled to. We are very happy again with the high quality nature of the printing and the material the tickets are printed on, even with choosing the least expensive options. We’ll be back next time we need tickets!
An awesome new feature to has been introduced to Microsoft Publisher 2010 is the ability to use Data Sources to create “Catalogue Pages”. This is like a Mail Merge for design documents. Now, I would have to agree that Publisher isn’t the best graphic design program in the market. But it’s certainly adequate for simple ticket designs — for example, for a school social. Let’s say we want each ticket to have a unique number and an inspiration quote. This is all possible through Publisher and a data source, e.g. an Excel Spreadsheet.
[Archive] Printing tickets with sequential numbers from Illustrator or similar General Questions. I can pull this into Illustrator, Publisher or any other software that these files Download the template Raffle tickets 4 per page
For those who would prefer a standalone program with even more features, you can get the commercial version ($10) of Numbergen from MacroMonster. You’ll note that the sequence of numbers can be formatted for either CorelDRAW or Microsoft Word. If you do any numbering, you’ll find the commercial version well worth every penny.