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 susansalesharkins@gmail.com.
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
Simply copy the second page of the template by highlighting that page and pressing CTRL + C. Windows shortcut keys Windows Keyboard Shortcuts 101: The Ultimate Guide Windows Keyboard Shortcuts 101: The Ultimate Guide Keyboard shortcuts can save you hours of time. Master the universal Windows keyboard shortcuts, keyboard tricks for specific programs, and a few other tips to speed up your work. Read More are wonderful things. Then create a new blank page by pressing CTRL + Enter. Then paste the copied page using CTRL + V. Create a new blank page, and paste again. Keep doing this until you have the desired number of pages that you will need.

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.
I had wanted to create a file that didn't require Excel as the data source, so I created one using SEQ fields. It was terrible and too huge to mention (thanks Doug Robbins), so I recreated it using Word as the data source so that people who only have Word can use it. You can create up to 5,000 tickets without changing the data file. If you only have Word and need to create more than 5,000 tickets, please don't type the ticket numbers. Just drop me an email and I'll create another data file for you with the required numbers.
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. I then let InDesign CS4 do the merging. Here’s the formula.
Like a charm! I can choose how many zero how many out I need and if there are special versions I can separate them too! Thank you, I was just about to run screaming from the building! All the “solutions” mentioned on this page are great examples of a great irritation in the graphics industry: When offering solutions, PLEASE mention the platform you are using and save people some frustration; what works great for you on a PC may not work at all on a Mac. What options you see on your version of Indesign are NOT cross-platform and Corel is strictly a Windows application. Thus we get puzzled responses from those who can’t understand why someone cannot grasp what they see as a simple process.
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.
I had wanted to create a file that didn't require Excel as the data source, so I created one using SEQ fields. It was terrible and too huge to mention (thanks Doug Robbins), so I recreated it using Word as the data source so that people who only have Word can use it. You can create up to 5,000 tickets without changing the data file. If you only have Word and need to create more than 5,000 tickets, please don't type the ticket numbers. Just drop me an email and I'll create another data file for you with the required numbers.
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. how to number raffle tickets
×