------ Register to get rid of these "In Post" ads! ------


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" <JB@discussions.microsoft.com> wrote in message
news:94B29994-55F5-4E78-9787-417A4568944E@microsoft.com...

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" <JB@discussions.microsoft.com> wrote in message
news:94B29994-55F5-4E78-9787-417A4568944E@microsoft.com...

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" <mary-sauer@mycolumbus.rr.com> wrote in message
news:%23Wru%233y9IHA.4952@TK2MSFTNGP03.phx.gbl...


Submitted via EggHeadCafe - Software Developer Portal of Choice
Get Started with SQLite and Visual Studio
http://www.eggheadcafe.com/tutorials...-sqlite-a.aspx