Remember that you must update the values in the sheet if you want to continue the numbering series with the next batch of tickets. For instance, if you want your next batch of tickets to start with 112, you'd open the workbook and change the value 100 to 112, and update the remaining values accordingly. Don't forget to save the workbook after updating the values.

There are three settings we need to embed in this field. The first is to tell it what kind of numbering we want to do (in this case, “First, Second, Third”), what case we want to use (upper case, title case, etc.), and a switch to tell Microsoft Word to increment the numbers. Click each of these settings as shown below, being sure to click Add to Field after each one:
© Corel Corporation. All rights reserved. The content herein is in the form of a personal web log ("Blog") or forum posting. As such, the views expressed in this site are those of the participants and do not necessarily reflect the views of Corel Corporation, or its affiliates and their respective officers, directors, employees and agents. Terms of Use / Privacy​ ​/ ​Cookies / Terms and Conditions / User Guidelines.
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.
Many Office programs will detect when you start a numbered or bulleted list and helpfully automate it, so that when you press Enter, new list items are automatically indented and bulleted or numbered. If this behavior isn’t actually all that helpful for you, and you’d rather control your own list-making without Office’s help, you can turn to your autocorrect options.
Michelle Castle began writing professionally in 2005. She has written technology news and tutorials for consumers, brochure and web copy for the Ehlers-Danlos National Foundation, and promotional materials for religious nonprofits including the International Pentecostal Holiness Church. Michelle has a Bachelor of Arts in English from Oklahoma State University.
- [Voiceover] If you're creating a multi-page document, there may be a need to use page numbering or create a master layer. Now, page numbering is fairly straightforward, but master layering may need a bit of an explanation. A master layer is a layer that will be displayed on all pages. What this means is that if I was to create a master layer, whatever I put on that layer will appear on all pages. I perfect an example of this is if I was creating a layout for a financial report and wanted a company logo to be on all pages, then I'd put it on a master layer. From my Object Manager, I'm going to left click on this black triangle, and then I'm going to select New Master Layer all pages. Now, if I go over to my tool box, I'm going to grab my rectangle tool. I'm gonna left click and drag. I'll create a small rectangle here. I'm going to give that a solid color, and let's just do another object here as well, and I'll give that a slight bit different color. So we can pretend this is…
12. To build the document, you will add the first merge field, the room number. To do this, choose Room from the Field list box, and click Insert Print Merge Field. This will place the variable on the document. Next, choose Subjectfrom the Field list box, and click Insert Print Merge Fieldonce more. Now both variables are inserted in the CorelDRAW 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.
×