If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pub 2007 How to put incremental #'s on ticket - 8 per page
Creating event tickets - need to incremental number the ticket and stub.
There are 8 tickets and 8 stubs per page. How can I put, #1 through 8 on the ticket and #1 through 8 on the stub. On the next page I want the xcel spreadsheet to continue the numbering. Curently, I'm getting the same number on all 8 tickets & stubs, on the second page, I get the next number on all 8 tickets & stubs. |
#2
|
|||
|
|||
Pub 2007 How to put incremental #'s on ticket - 8 per page
When you do a mail merge you can only have one ticket & stub on your screen. Be
certain when you go to File, Print Merge, you select multiple pages per sheet. There is a print preview on this screen. You do have a data base with the numbers, right? -- Mary Sauer http://msauer.mvps.org/ "JB" wrote in message ... Creating event tickets - need to incremental number the ticket and stub. There are 8 tickets and 8 stubs per page. How can I put, #1 through 8 on the ticket and #1 through 8 on the stub. On the next page I want the xcel spreadsheet to continue the numbering. Curently, I'm getting the same number on all 8 tickets & stubs, on the second page, I get the next number on all 8 tickets & stubs. |
#3
|
|||
|
|||
Pub 2007 How to put incremental #'s on ticket - 8 per page
I had a similar problem with Pub 2003 where I was printing 4 tickets to a
page, needed the same incremental numbering on both the ticket and stub. My solution was to create 4 columns in Excel with each column uniquely named as TickNum1, TickNum2, etc. Using Excel cell formula =A2+1, =B2+1, =C2+1 respectively in cells B2, B3, B4 and continue with similar formulas for Row 3 until you have all your numbers displayed; Enter your starting ticket number into B1, then saving. In Publisher 2003 I dragged the each of the 4 fields to the respective ticket, dragging a second TickNum1 to the stub of the first ticket, etc. It worked nicely. BTW since I sometimes have printer issues during big jobs, I prefer to do small batches. To do this, I limit my Excel sheet to 40 numbers, then reopen Excel and change the starting ticket number in cell B1, Save, Close. "Mary Sauer" wrote in message ... When you do a mail merge you can only have one ticket & stub on your screen. Be certain when you go to File, Print Merge, you select multiple pages per sheet. There is a print preview on this screen. You do have a data base with the numbers, right? -- Mary Sauer http://msauer.mvps.org/ "JB" wrote in message ... Creating event tickets - need to incremental number the ticket and stub. There are 8 tickets and 8 stubs per page. How can I put, #1 through 8 on the ticket and #1 through 8 on the stub. On the next page I want the xcel spreadsheet to continue the numbering. Curently, I'm getting the same number on all 8 tickets & stubs, on the second page, I get the next number on all 8 tickets & stubs. |
#4
|
|||
|
|||
Mail Merge just not working
I am using Publisher 2007. Have only one ticket on my page, have the excel spreadsheet with the correct numbers in a column. When I print I click on multiple pages per sheet it changes to 3 copies. I print it out and I have 3 tickets with number 1, 3 with number 2 etc. I have read all the directions and the only think I am noticing that is different is they say the mail merge has 5 steps and mine only has 3.
VERY Frustating! Adrienne Mary Sauer wrote: When you do a mail merge you can only have one ticket & stub on your screen. 05-Aug-08 When you do a mail merge you can only have one ticket & stub on your screen. Be certain when you go to File, Print Merge, you select multiple pages per sheet. There is a print preview on this screen. You do have a data base with the numbers, right? -- Mary Sauer http://msauer.mvps.org/ "JB" wrote in message ... Previous Posts In This Thread: On Tuesday, August 05, 2008 2:31 PM J wrote: Pub 2007 How to put incremental #'s on ticket - 8 per page Creating event tickets - need to incremental number the ticket and stub. There are 8 tickets and 8 stubs per page. How can I put, #1 through 8 on the ticket and #1 through 8 on the stub. On the next page I want the xcel spreadsheet to continue the numbering. Curently, I'm getting the same number on all 8 tickets & stubs, on the second page, I get the next number on all 8 tickets & stubs. On Tuesday, August 05, 2008 3:03 PM Mary Sauer wrote: When you do a mail merge you can only have one ticket & stub on your screen. When you do a mail merge you can only have one ticket & stub on your screen. Be certain when you go to File, Print Merge, you select multiple pages per sheet. There is a print preview on this screen. You do have a data base with the numbers, right? -- Mary Sauer http://msauer.mvps.org/ "JB" wrote in message ... On Tuesday, September 09, 2008 3:53 PM lk wrote: I had a similar problem with Pub 2003 where I was printing 4 tickets to a I had a similar problem with Pub 2003 where I was printing 4 tickets to a page, needed the same incremental numbering on both the ticket and stub. My solution was to create 4 columns in Excel with each column uniquely named as TickNum1, TickNum2, etc. Using Excel cell formula =A2+1, =B2+1, =C2+1 respectively in cells B2, B3, B4 and continue with similar formulas for Row 3 until you have all your numbers displayed; Enter your starting ticket number into B1, then saving. In Publisher 2003 I dragged the each of the 4 fields to the respective ticket, dragging a second TickNum1 to the stub of the first ticket, etc. It worked nicely. BTW since I sometimes have printer issues during big jobs, I prefer to do small batches. To do this, I limit my Excel sheet to 40 numbers, then reopen Excel and change the starting ticket number in cell B1, Save, Close. "Mary Sauer" wrote in message ... Submitted via EggHeadCafe - Software Developer Portal of Choice Get Started with SQLite and Visual Studio http://www.eggheadcafe.com/tutorials...-sqlite-a.aspx |
Thread Tools | |
Display Modes | |
|
|