A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Publisher
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Pub 2007 How to put incremental #'s on ticket - 8 per page



 
 
Thread Tools Display Modes
  #1  
Old August 5th, 2008, 07:31 PM posted to microsoft.public.publisher
JB
external usenet poster
 
Posts: 290
Default 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  
Old August 5th, 2008, 08:03 PM posted to microsoft.public.publisher
Mary Sauer
external usenet poster
 
Posts: 7,320
Default 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  
Old September 9th, 2008, 08:53 PM posted to microsoft.public.publisher
lk[_2_]
external usenet poster
 
Posts: 3
Default 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  
Old March 3rd, 2010, 10:56 PM posted to microsoft.public.publisher
Adrienne Koesterer
external usenet poster
 
Posts: 1
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:19 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.