Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-01-2019, 12:39 PM
stevie19790 stevie19790 is offline Text Box Numbering Windows 10 Text Box Numbering Office 2016
Novice
Text Box Numbering
 
Join Date: Jul 2019
Posts: 1
stevie19790 is on a distinguished road
Default Text Box Numbering

Hello,



I'm creating simple event tickets, not from the tickets template as I wanted 8 to a page, credit card size tickets. Irrelevantly, the tickets are for a charity fundraiser. I need to create between 200 and 220 tickets and would like to number each ticket for prize giveaways and raffles etc.

So, using a text box, I've created the ticket which details all the essentials for the event, including simple logos.

My question is, how do I copy and paste this tickets multiple times to include sequential number?

Thanks.

SC
Reply With Quote
  #2  
Old 07-02-2019, 12:44 PM
Moonshine Moonshine is offline Text Box Numbering Windows 10 Text Box Numbering Office 2016
______________
 
Join Date: Apr 2018
Posts: 302
Moonshine is just really niceMoonshine is just really niceMoonshine is just really niceMoonshine is just really nice
Default

For me, the easiest way to achieve what you want is to use a two-stage process involving Excel along with Publisher.
First create a simple Excel Workbook that contains the ticket numbers 1 – 220 in this instance.
To do this, open Excel and in Column A/Row 1, input 1.
Input 2 in Column A, Row 2.
Highlight column A Rows 1 & 2 and when you see a small black square, drag it down to your chosen amount (220) to automatically populate the cells.
Save the Workbook with an appropriate name in a location of your choice. Folks often use a folder call My Data Sources in the Documents folder.

In Publisher, create/resize one page with the correct dimensions for your ticket.
In the Page Setup, check the page margins and adjust as required for your chosen amount of tickets per page. The preview should guide you.
Make sure the Layout type is set to Multiple pages per sheet.
Add content including a space for a number(s).

Now the numbering part:
Click the Mailings tab, then Select Recipients.
Opt to Use an existing list.
Navigate to new Excel 1 - 220 list and once located, D/click.
Uncheck First row of data contains column headers > OK.
Click OK to Mail Merge Recipients.
Now click the Insert Merge Field tab, then the F1Merge Field option.
Click the inserted F1 Merge Field and resize/change colour/font size etc, then position as required.
An easy way to copy an object (F1 Mail merge Field) is to press the Ctrl key, then click the perimeter and when you see a small plus / + sign, drag the ‘copied’ object to a position if required.
My, 10 tickets per sheet, example below uses two sets of numbers to identify it (2 part raffle ticket).

Now click the Preview Results tab to see actual numbering, then use the Left/Right arrow tabs to see additional numbers of ‘ticket numbers’.
Now click the Finish & Merge tab and opt to Merge to Printer.

The Print Preview will open where you can zoom in to see results.
The numbering is likely to be all the same – not what we want, so click the Multiple copies per sheet entry and change it to Multiple pages per sheet.
This will change the numbering for each ticket in a sequential manner as required.

Print when ready.
Click the image below to see a short video of how I have first created the Excel data file, then in Publisher see how I have used it to number the tickets.

Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Paragraph Numbering on the Right of Text Sontal Word 12 01-13-2019 09:29 AM
Text Box Numbering Word changing my body text to heading text when I apply paragraph numbering ddiemetric Word 1 01-17-2017 01:10 PM
Text Box Numbering List Numbering Set Numbering Value shows missing numbers as hidden text lostenfeld Word 9 01-03-2017 04:27 PM
Need to provide numbering to the text preeti Word VBA 4 01-22-2015 01:08 AM
Numbering issue gap bettween 1.1 and text lower and higer numbering leave no gap Turtlesrun Word 3 02-21-2014 04:48 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:10 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft