Canva’s drag and drop design features makes it easy to add your organization’s brand assets like logos and colors easily. Simply go to the uploads pane and choose a JPEG, PNG or SVG version of your logo to add to your design. Drag your logo to where it needs to be and resize by clicking or dragging on its edges. Change the template color scheme to your brand palette by clicking the color tool on the Canva toolbar. Pick the correct hue from the color wheel or input your color hexcode into the box.
I'm not sure about using an open office version of excel would work the same but create a file with your numbers in it starting with 0000 or however many 0's you need then click and hold in corner of cell and drag down, should auto populate. Document must be Saved As "text (tag delimited)" keep clicking ok. Save it this way only when completed somewhere you'll remember. Now go to inDesign and create one ticket. Add a text box and open data merge, navigate to the number file you just created and click/double click (don't remember) and an "options" box will open. This is where you setup your page size, bleeds, etc., I know multiple pages has to be checked. I think you can preview from this too and make necessary adjustments.
Change all other existing text to reflect the correct date and prizes by highlighting the words and either editing or deleting the existing text. Font size and style can be adjusted using the font toolbar above the document. Images can be added by using the Insert menu in the toolbar and following the same process as inserting images to a Word document.
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.
Using a blank raffle ticket template is the most effective method to prepare the cards. Some people make raffle ticket from scratch but in a world where technology makes things easy, creating items from scratch is quite time-consuming and cost ineffective.With hundreds of templates already available, you can find attractive designs, which you can then use to create your tickets.You may also see Meal Ticket Designs

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.


CS2 (or earlier) “Cheesy” Numbering 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. 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. To ensure each number fills its own text frame, select the whole story (Command/Ctrl-A), open the Keep Options (Command/Ctrl-Option/Alt-K) and choose In Next Frame from the Start Paragraph pop-up menu.

If your organization often holds fundraisers, you probably won’t want to start your design from scratch. Every design you create in Canva can be re-opened and edited as many times as you like. You won’t need to hire a graphic designer to make small changes such as editing details like date, venue and event title. Simply make the changes to your original design and download it again.

The SEQ or Sequential Numbering Function in Word is the best and quickest way to number your tickets. Many raffle ticket templates use them, yet few sites explain how it works. To see if it uses the SEQ function, you need to download the template first. Then, open it in Word, click right in the middle of where a serial number is, and then right-click.

I've also been using NumberPress for about a year and it is awesome. You can easily position numbers as many up per form and as many up on a sheet as you will ever need. Easily change font, color, point size, angle, number of digits and can even customize prefix-ex: instead of No. you can print ABC or a form number. It also does variable data (I've only used a couple of times).Took a little while to learn but is now a piece of cake.

10 Pt. Cast Coat, C1S 80 Lb. Smooth Cover 67 Lb. Bristol Cover 65 Lb. TimberLine Cover 10 Pt. Hot Stock 13 Pt. Tag Stock 24 Lb. Bond 80 Lb. Digital Gloss Cover 80 Lb. Digital Matte Cover 90 Lb. Index 10 Pt. Manilla 110 Lb. Index 100 Lb. Gloss Text 11 Pt. Cast Coat, C1S 12 Pt. Smooth Cover 12 Pt. Cast Coat, C1S 2 Part Carbonless
Layout your ticket in InDesign, one on each page, using the Page Number function to number the tickets. If you have something like Imposer Pro (I know it doesn't work from InDesign CS3) you can, for instance, impose the pages 4up consecutive and get 4 tickets on an A4. Alternatively, make a PDF of the whole document and impose (manually, if you have to), the advantage here is that this can work as a template for other tickets, simply make a new PDF of the same size and update the PDF in the template document every time you have a new raffle ticket to do.
The EASY way to set up the text file is to use Excel to make a grid the number of sheets wide by the number of tickets per sheet deep. Put the first number in the upper left cell, then fill consecutively to the right until the number of columns is equal to the number of sheets you will print, then move down a row and do the same thing with the next numbers, and so on until you've finished the grid.
I am using your instructions to create a page of tickets - the design has been created as a picture so I added a text box to "hold" the mail merge instructions but I keep getting the error message "You cannot include DATA, NEXT, NEXTIF, or SKIPIF fields in comments, headers, footers, footnotes or endnotes." I have not included any of these but I'm wondering if it's because I've attempted to insert it in a text box. Is there an easy way to do this? TIA
×