In the Mail Merge task pane, in the list under Prepare your publication, locate the field name that corresponds to the 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.
For years, I’ve applied an autonumbered style to the first cell I want to be sequentially numbered. When I add rows, the cells immediately below continue that same numbered style whether I add them by tabbing from the end of the last row or by using the commands to inserts rows above or below. Because the numbering is part of a style, it can continue from one table to another, but it can always be restarted. I can even skip a row by changing the style for the particular cell or by just toggling off the numbering. I also use it to show two levels of numbering in a single cell by creating two autonumbered styles in a hierarchy that works just like Heading 1 and Heading 2.
Also, I followed the nine steps (five steps by your count) — 1) Insert; 2) Quick Parts; 3) Field; 4) Seq [Name]; 5) Options; 6) Formatting; 7) Add to Field; 8) Field Specific Switches; 9) /n; OK; OK, but I keep getting Error! No sequence specified.
The ticket merges perfectly, prints multiple tickets per page and numbers them sequentially. The only problem is that Publisher won’t print the 3 digit number format. It prints 1, 2, 3, 4, etc. on the tickets.
The auto-indenting feature of bullets and lists has always frustrated me. EVERY time you apply a numbered or bulleted list, you’ve got to set the indents. I want my lists to be indented at the very left of the page, flush with the rest of the paragraphs. But no, Microsoft insists that you want them indented by 0.63cm and hanging at 1.27cm (WHY 0.63? Why not 0.7? Or 1.0cm? But that’s a question for a different session.) (I know, it’s because MS is American and still uses inches etc…)
I haven’t tried this… But according to the Microsoft instructions about field switches (http://office.microsoft.com/en-us/word-help/insert-and-format-field-codes-HA010338798.aspx), you can add text to a field code. The text must be in single quote marks, and displays as a constant for the field. The examples on that web page show the text at the end of the field, but you could try it earlier in the field by testing putting ‘120/’ in front of where the SEQ number will go.
Corporate PrintingCustom PrintingDigital PrintingDoor HangersEDDM® PostcardsEnvelopesFile FoldersFlyersFolded Business CardsFoldersFormsGreeting CardsHang TagsHoliday CardsInvitationsLabelsLarge Envelopes
Well, these “work arounds” are intended for use on your own officemachines. I doubt you would get a good price printing 2000 unique tickets in a real press. Even with 20-up that would mean 10 plates even for a simple black and white job.
Tip You can always reset your numbering formats back to Word’s defaults by clicking on the Reset button in the Bullets and Numbering dialog box. You will have to reset each numbering scheme individually.
Sequential/Serial numbering is available on many products such as business cards, flyers, and posters (at an additional cost) but can only be done with our Digital Output printing service (not available with Offset Output). This service is not included as standard on our products and requires a Custom Print Quote.
Storage/saving (by default) (I understand) was to “normal.dot” somewhere on “my” C:/drive. (I.e. Nobody else in the office could “get” to the effort. So, I (as attorney), and each secretary, lawyer, and paralegal, had to work in their own “silo” and “reinvent” any such Auto Text blocks). [I.e. Query – Is there any way to save a consistent set of such Auto Text blocks for MS Word to a shared “network” drive, or similar, in a law office?).
I normally use “Data Merge” in InDesign and use Excel (or something like it) to generate the list of numbers for me. You would copy the numbers into a text file so that InDesign can read them as the merge data source. Note that you would have one ticket on the page and then let InDesign set the other tickets on the page (you can tell the Data Merge control panel about spacing).
Open your Layers window. If it is not already open, open it by going to (Window > Layers). Rename the layer with the placed pdf ‘Background’ and then create a new layer and name it ‘Numbering’. Lock the ‘Background’ layer. Then select the ‘Numbering’ Layer.
1. Yes, after you click the output box of the frame with the pasted text you delete that frame while the cursor is still loaded. That is to make sure you got all the text loaded for the automatic adding of pages as needed. If you leave some of the pasted text in its frame, and delete it afterwards, you will not get new pages added automatically.
Thanks for the auto numbering info. I got it to work, well sort of. We have a set of interrogatories already set up without auto numbering. Do I have to change each interrogatory question in order to get them to auto number?
I understand what you are after and that is to have four piles of postcards in the stack so that once cut down, the four stacks can be put one on top of another and be in sequential order. This is commonly referred to as “cut and stack” imposition.
This kind of template is very easy and fast for creating a multitude of serialized tickets. You don’t have to change each number or manually update each field. That’s far too tedious. The lottery might be over before you’re done.
Next, we’re going to put in the two switches that are required to make this numbering sequence work. First, I’m going to use Arabic numerals (1, 2, 3, etc.), but you can use any of the number formats listed under Formatting on the left. Just click the number format you want, then click Add to Field to add that switch to the Field Codes:
Most changes you make to the top ticket are automatically made on all the other tickets, too. No tiring copying and pasting needed. The template shows just 5 tickets, but once you have them looking the way you want, just multiply them using copy and paste.
Roy’s little movie is very helpful. I have used Xenetech rotaries for years, and their software will do all of this, but only for rotaries. Of course, the laser is slowly taking over most of this type of work because it is so fast. One problem that I have is that I have never used spreadsheet programs much (not since the early 80’s! Remember Visi-calc?). Is there another way to easily create the data file mentioned without using spreadsheet software?
Contributing author Mary Lester leverages her deep experience with storytelling, design excellence, multi-platform publishing, and technology-focused content to help leading-edge businesses meet the challenges of today’s rapidly changing media industry.
This macro will only run on one computer. For another computer will need a new key. It is impossible to transfer the old key to another PC. For activation will be used the sequential numbering in coreldraw of your computer’s configuration. If you have a number of activations more than 1 you can leave them for future activations or use for other computers. If the limit of activations is ended you need to purchase this macro again. Macro updates are free (usually).
As far as I know this cannot be done directly through VDP but I have done this in the past using Publisher (yes Publisher – I know, but it does mail merge well) and an Excel file. I had my IT guy write an Excel program that asked for Qty, starting #, #up on sheet and # of parts then it would make a print ready numbers sheet.
Is there a way to have page numbering span multiple worksheets in a file? I would like to be able to print all the worksheets in a file and have the page numbers in the second worksheet pick up where the page numbers in the first worksheet ended without having to manually adjust the start point in worksheet 2. Please response back to the group. Thanks. JWeinberg I assume the page numbers are set up in your header/footer. If this is correct then all you need to do is select all the sheets you want to print by clicking on each sheet tab while holding down the control key. This will the…
Hi Scott, you directed me here from the experts blog for this topic. Thanks again for all your assistance. I want to build a test example of your Acme example before creating it in my donations database, as I mentioned this is all very new to me so please bear with me:
Warning Do not delete the number that appears in the Number Format box. If you do so accidentally, select a number style from the Number Style drop-down list to put it back. If the Overtype feature is active, this will cause the number to be easily deleted.
How do I get numbering like the attached image using text in photoshop? I have photoshop elements 9. Basically I just want to be able to type out numbers within boxes, or some other solution that will give me this desired effect easily.
These numbers are updated when you sort them with your data. The sequence may be interrupted if you add, move, or delete rows. You can manually update the numbering by selecting two numbers that are in the right sequence, and then dragging the fill handle to the end of the numbered range.
Hi – are you creating your own tickets using the instructions on this page? If so, you can of course change the font and everything else in your Word document. If you are using the Raffle Ticket Creator app (app.raffleticketcreator.com) then you can’t change the font size … you’ll just need to tinker with the exact words that you are including in order to get them to fit on the page. Hope that helps!
I work for a print shop and recently acquired CorelDraw X3 (previously used Quark). I have an order for 2,000 membership cards (3 to an 8 1/2 x 11 page which I will perforate), and I need them sequentially numbered. Is this possible on Corel? PLEASE tell me it is. I have messed with the Print Merge but apparently I’m doing something wrong.
There are a couple of ways you can set up Word 2007/2010 to use SEQ fields for numbering — you can set them up as AutoCorrect entries or as Quick Parts. Both ways work; the method you choose is up to you. This long article describes how to create the SEQ fields and the numbering style in your Normal.dotm template; how to save the SEQ fields as AutoCorrect entries in Word 2007/2010 (and how to use them); and how to save (and use) them as Quick Parts. The most consuming part of this process is settings up the fields and the style; once they’re set up, using them is super easy.
I have a file that displays the text “Page 1” in the center of the worksheet. I have not been able to find a way to stop the page number from displaying. There is no header/footer, no “background”, no other special items that I could find that would force the display of this. It does not appear during the printing so it’s not a “watermark”. It merely displays in my view when I’m working in the worksheet. Help… Hi you’re in page break preview view … choose view / normal from the menu Cheers JulieD “whalenohana”