how do i place numbers in ticket template so that they increment?

i have downloaded a template for event tickets, that show only one ticket. I 
want to print more than 1 ticket to a page, and I want to have them numbered 
sequentially. Does anyone know how I can do this, with a macro perhaps?
0
9/22/2006 8:05:02 PM
publisher 21446 articles. 6 followers. Follow

2 Replies
486 Views

Similar Articles

[PageSpeed] 44

Use a mail merge. And print preview will fib to you - print a test page. 
;-)

-- 

JoAnn Paules
MVP Microsoft [Publisher]




"david peters" <davidpeters@discussions.microsoft.com> wrote in message 
news:720CC242-05A7-4552-80DB-6381E7E2A240@microsoft.com...
>i have downloaded a template for event tickets, that show only one ticket. 
>I
> want to print more than 1 ticket to a page, and I want to have them 
> numbered
> sequentially. Does anyone know how I can do this, with a macro perhaps? 


0
jl_paules (2769)
9/22/2006 8:55:38 PM
            Mail merge
            http://office.microsoft.com/en-us/assistance/CH010504371033.aspx

            Consecutive numbers using Excel (Access is about the same)
            Scroll down below the fish
            http://msauer.mvps.org/misc.htm



-- 
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com
http://officebeta.iponet.net/en-us/publisher/FX100649111033.aspx

"david peters" <davidpeters@discussions.microsoft.com> wrote in message 
news:720CC242-05A7-4552-80DB-6381E7E2A240@microsoft.com...
>i have downloaded a template for event tickets, that show only one ticket. I
> want to print more than 1 ticket to a page, and I want to have them numbered
> sequentially. Does anyone know how I can do this, with a macro perhaps? 


0
mary-sauer (6480)
9/22/2006 9:05:27 PM
Reply:

Similar Artilces:

Envelope Template
Anyone have or know where I can get a Word templates for a 6.5 X 9.5 envelope? Thanks in advance In Tools | Envelope, you can click on Page Setup to choose a different size (there are terms I don't understand in there, which may include a 6.5x9.5 envelope), or you can click on Custom to set up your own envelope. Once setup, click OK and save the resulting document as a template. mgauf wrote: > Anyone have or know where I can get a Word templates for a 6.5 X 9.5 > envelope? > > Thanks in advance > > In article <1180997480.783709.257530@m36g2000hse.googlegroup...

add number to existing text numbers
I have 2000 columns with accounting type text numbers in each cell, i.e. 0345999, 058956, ect. I want to add an "0" in front of each account number. Anyone know how to do this withount going into each cell and doing it by hand? Hi one way: use a helper column with the formula ="0" & A1 copy this down for all rows, copy this column and insert it with 'Edit - Paste Special - Values' -- Regards Frank Kabel Frankfurt, Germany Stacy wrote: > I have 2000 columns with accounting type text numbers in > each cell, i.e. 0345999, 058956, ect. > > I wan...

Phone field should allow for 5 digit extension number.
Many companies, including Microsoft, have 5 digit extensions for their phone numbers. i.e xxx-xxx-xxxx ext. xxxxx Dynamics is limited to 4. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/...

Moving elements in smaller increments
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel This may be a stupid question, but how can I move elements in smaller increments? As it is now, when I use the arrows to move an inserted object, it will snap past the position I would like it to be in. With text boxes I notice that I can hold down the option key and that will give me smaller steps in which to move the box, but this does not work with inserted elements. What am I missing here? ...

Number Problem #2
D'all, In a column, I hav 16 digits numbers. But when I add 4 digit number after last digit of that number becomes 4 zeros at last. e.g. 9503170011002910 (16 digit number) 1425 (4 digit number) becomes 95031700110029100000 whether it should be 95031700110029101425 Excel can only handle 15 digit numbers, after that everything gets shown as 0. If you want 20 digits you will have to hold it as text. -- __________________________________ HTH Bob "Sandeep Jangra" <SandeepJangra@discussions.microsoft.com> wrote in message news:8E87C8C7-8CBC-4CF8-9E0A-F222DD023255@mi...

Custom Workspace Template Not Linking to Projects
Experts, I publised a test project on PWA for Project Server 2007. I then went to that new Workspace and made several changes to the Issues and Risks columns and over all views. I then saved the site as a template, sent the .stp file to our sharepoint admin and she executed the STSADM command to load new the template. I then went to PWA Site Provisioning setting and switched the default template to the new one. so far so good? When I went to create a new project schedule and published, i created the schedule and workspace but they're not linked. Meanining that I dont see t...

Microsoft Excel Template
Sorry I don't see much discussion going on at Office community so pardon me for posting it here. I downloaded a template from office download center for excel. I saved the template in "c: program files>Microsoft Office>templates>1033" where other templates are. I tried opening it from excel by "File>New>template on my computer.." but don't see my newly added one. Please help. Danny "Danny" <Danny@discussions.microsoft.com> wrote in message news:1A265283-EED3-4EBA-AA0E-F55F3EA8460D@microsoft.com... > Sorry I don...

Numbering of duplicates
Hi. I need to do numbering of duplicate values and assign these numbers to a table. Example: Table: Field1 1 2 3 2 3 2 4 1 Reult I need: Field1::Field2 1::1 2::1 3::1 2::2 3::2 2::3 4::1 1::2 where "::" is a field separator. Additional assumptions: - Field1 is a text field - Updating is necessary (new data will appear in Field1 and should also be numbered) Thanks for help Kamil Something like SELECT (SELECT COUNT(*)+1 FROM P1 WHERE P1.ID < P.ID AND P1.FIELD1=P.FIELD1) AS ROWNUM, P.* FROM P HtH Pieter <kamil.jedrzejewski@gmail.com> wrote in message news:1193131909....

is there a template to use pc as cash register
i am just trying to figure it all out and cant seem to get it to do it properly so i was hoping someone already worked out all the bugs and have a template ...

Custome number format help
I have a series of cells that will hold values such as 350,000.00. This value is entered by the user and entire amount is used in calculations across the worksheet. I want the output to be 350k. This way, more columns can be viewed at a time and makes for easier reading than a number with all the zeros. I can't get the customer number format to "hide" the zeros. WB Thanks, yes it did. "Carmen" <hovendic@yahoo.com> wrote in message news:Od0aSCQrGHA.4356@TK2MSFTNGP02.phx.gbl... > WB, I put > > #,k > > in the custom formatting box and it looks ...

Is there an Excel template to reconcile business bank statments?
I am looking for a template that will simplify the bank reconciliation process? Acct Rep wrote: > I am looking for a template that will simplify the bank reconciliation process? How do you mean "simplify"? You will still need to manually tick off the bank statements against the cashbook entries. If you're looking for an AUTOMATED bank rec, then you're looking at comparisons of lists, and that gets complicated if (say) the bank has entered a cheque number correctly but with the wrong amount or vice-versa. It DOES happen - I've seen it. Also that assumes you can d...

Disable Typesetting Quotes in a Template
Is there any way to disable typesetting quotes in a template rather than globally? I have some templates where I would like there to only be straight quotes and others templates where I'd like typesetting quotes. You could use a macro to toggle between straight quotes and smart quotes, though the macro cannot account for missing quotes when straight quotes are converted to smart quotes and may thus produce incorrect results. http://www.gmayor.com/installing_macro.htm Sub ReplaceQuotes() Dim vFindText As Variant Dim vReplText As Variant Dim sFormat As Boolean Dim sQuotes...

Is it possible to change the "result of a formula" to a "number? #2
Is it possible to change the "result of a formula"... to a number? Hi yes, choose the cell(s) you want to do this to and copy them then choose edit / paste special - values this will change the formals to the result. Cheers JulieD "Renee R." <Renee R.@discussions.microsoft.com> wrote in message news:E99C248C-B6AC-416D-BA24-1302BC503B50@microsoft.com... > Is it possible to change the "result of a formula"... to a number? ...

numbering pages in footer
In the old excel, 1997, we could start a new page with a different page number rather than 1. I have many pages in one worksheet and many worksheets. I want the numbering footer to continue with each worksheet I prepare, and print them out at different times. I will finish one worksheet and print, and use this while working on a new worksheet, but want the next page to start where the last worksheet ended. I know you can do this by added all the worksheets together on a single worksheet and group them, however I work them at different times. On the 1997 version, you would simple ...

Office 98 workgroup templates tab
Hello, I was wondering if someone could please advise me on a problem I'm having. I'm trying to configure a set of workgroup templates on my Mac (office 98 & OS 9.1). I've successfully specified the network folder where the templates reside, however when I hit FILE - NEW in word there are no new tabs indicating my workgroup templates. Any help would be appreciated a lot. Thanks. ...

Page Numbering (Starting Number Other Than 1)
I am at a loss as to how to start page numbering with number other than 1. I am using Office Pro 2003 with Publisher 2002. When I go to Tools/Options, I do not find the familiar menu "Start Numbering With . . " menu. What to do?? Regards, Bill Go to Page 1, Insert|Section -- JoAnn Paules - MVP Microsoft Publisher "Bill" <russeng@kiowaonline.net> wrote in message news:09b701c4257b$9d972530$a601280a@phx.gbl... > I am at a loss as to how to start page numbering with > number other than 1. I am using Office Pro 2003 with > Publisher 2002. > When I ...

Number Format and percent
Dear all, 1. I am new to access program. I need to have 0.67 in a column in a table but when I put this into the column then it returns me 1. Is there a way to have it 0.67? 2. I need to have percent format in one of my columns, but instead of 5% it shows 500%, I want to have it as 5%. I will be thankful to receive feedbacks on the above issues. Thanks, Daoud 1. If your field is long integer it won't work. I use decimal 2. Don't multiply by 100 (the percent format does it for you) -- http://www.ready4mainstream.ny911truth.org/index.html "Daoud Fakhry" wrote: &...

Convert range of numbers to letter
Hello. I hope this makes sense. I have a spreadsheet that has columns with numbers ranging from 1 to 100. I would like to convert them to letters i.e. 90 - 100 = A 80 - 90 = B 70 - 80 = C 60 - 70 = D and so on Is this possible? Thank you JB "JB" <badspam@awyway.com> wrote in message news:OUlxDBVPGHA.3728@tk2msftngp13.phx.gbl... > Hello. > I hope this makes sense. > I have a spreadsheet that has columns with numbers ranging from 1 to 100. > I would like to convert them to letters > i.e. 90 - 100 = A > 80 - 90 = B > 70 - 80 = C ...

Word template used for emails?
Older versions of Office had an email.dot template used for sending emails using Outlook and Word as the editor. Cannot find the template using 0ffice 2003. Any ideas? Becky <anonymous@discussions.microsoft.com> wrote: > Older versions of Office had an email.dot template used > for sending emails using Outlook and Word as the editor. > Cannot find the template using 0ffice 2003. Any ideas? I think it just uses the Normal.dot template. -- Brian Tillman ...

Version Numbers in Product
Our product is software. How can we relate the version number as a child or dependant of the product name? Is this possible or am I destined to create a new product name for each release? IE Products- Widget Widget Pro Widgets For DOS Version. 4.1 4.2.1 5.0 5.01 or am I going to have to Widgets Pro V4.1 Widgets Pro V4.2.1 Widgets For Dos V5.0 etc? Any insight would be appreciated! jim ball jball@XXXaccu-med.com Remove XXX from email ...

Where do I find the option to change number format in a Word doc.
I simply want numbers in a particular document to display with 2 decimal places. But I can't find this function anywhere. Used to be able to right click to get this kind of function but no more. Are you perhaps confusing Word with Excel? Word has never had that capability from a right-click option. You can use a formatting switch if the number is in a field. Otherwise, you basically get what you type. (I suppose you might have had an add-in that provided numeric formatting, but I'm not familiar with any such add-in.) -- Herb Tyson MS MVP Author of the Word Bible B...

How do I get auto fill to do decending numbers in a column?
I am trying to get excel to do decending numbers from 50 to 1 in a column and no matter what I try it still will not do it. What am I doing wrong? Hi one way, type 50 in the first cell, underneath it type 49, then select both cells, now go to the fill handle on the 49 and drag down. Cheers JulieD "oesqueen" <oesqueen@discussions.microsoft.com> wrote in message news:082D4471-39F1-41E1-B50C-5420B18526BF@microsoft.com... >I am trying to get excel to do decending numbers from 50 to 1 in a column >and > no matter what I try it still will not do it. What am I doing...

Journal entry Number Reset?
I am about to close the year 2005, and out fiscal period start from MAY next month, can i start my Journal Entry number from 1 for the next year with out closing the year 2005. In short i want to have Journal entry to be resetted from 1 for my next fiscal year 2006. i wanna keep 2005 still open since adjustment entries could be entered after final auditing. Regards. You can post adjusting entries to the most recent closed year. "Akram" wrote: > I am about to close the year 2005, and out fiscal period start from MAY next > month, can i start my Journal Entry number fr...

Finding a character in an item number
This is really a sql question but; is there a way to find the position number of a specific character within an item number? We're experimenting with tracking revision info on items in GP by adding a new item number for each new revision. So the first item number was 12345.A then the next revision would be 12345.B, then 12345.C, etc. If we do this I know I'll need to be able to find all the 12345 items to summarize sales history. To do that I'm trying to find a way to group all of the 12345 items. I thought the PATINDEX function would do the trick but so far it's ...

Counting how many times a number appears in a list?(EXCEL)
hi, got a small problem in excel, situation as below: grade 1 2 3 1 2 1 2 3 4 1 1 what formula do I use to count how many times (e.g) 1 appears in th list? I thought I could do it with the Count function but haven managed to. Cheers -- Message posted from http://www.ExcelForum.com The "countif" formula should do! Dunca -- Message posted from http://www.ExcelForum.com =COUNTIF(A1:A15,1) -- Regards, Peo Sjoblom "sox >" <<sox.152stn@excelforum-nospam.com> wrote in message news:sox.152stn@excelforum-nospam.com... > hi, got a small problem in excel...