Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Publisher / Programming / November 2004

Tip: Looking for answers? Try searching our database.

unique numbers on tickets

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
matt - 04 Nov 2004 20:35 GMT
i have event ticks designed, 6-up on a page in publisher.
i want to have each one numbered.

i thought the easiest way to do it would be a mailmerge.

i built an excel spreadsheet with 1-300 down the A1
column. i was successfully able to merge that data into
the publisher file, but....

when i preview the numbered tickets, all six on the page
have the same number.

(the way ive done it: in my excel file, i have the first
cell called "Ticket Number" and then rows 2-301 are
numbered 1-300. in publisher, ive placed text boxes on
each of the tickets, then, from the mailmerge wizard,
have done an "Insert Field" into each text box, and
placed the "Ticket Number" (the only option that appears
from that spreadsheet, naturally) ... but it's putting
the same number on all 6 tickets on the page)

any way to have tickets 1-6, then 7-12, and so on?
Brian Kvalheim [MSFT MVP] - 05 Nov 2004 13:13 GMT
> i have event ticks designed, 6-up on a page in publisher.
> i want to have each one numbered.
[quoted text clipped - 18 lines]
>
> any way to have tickets 1-6, then 7-12, and so on?

The preview will not display the merge accurately. Go to File > Print and
Print a TEST and you will see that the merge was indeed successful.

Signature

Brian Kvalheim
Microsoft Publisher MVP
http://www.publishermvps.com
~pay it forward~

This posting is provided "AS IS" with no warranties, and
confers no rights.

matt - 05 Nov 2004 17:55 GMT
>The preview will not display the merge accurately. Go to File > Print and
>Print a TEST and you will see that the merge was indeed successful.

thats a no-go.
i was hopeful, but the print is coming out just the same
as the preview. all the tix are the same number. :(
Brian Kvalheim [MSFT MVP] - 05 Nov 2004 23:49 GMT
>> The preview will not display the merge accurately. Go to File >
>> Print and Print a TEST and you will see that the merge was indeed
[quoted text clipped - 3 lines]
> i was hopeful, but the print is coming out just the same
> as the preview. all the tix are the same number. :(

See the Tutorial Section at my site listed below. There is a ticket
numbering tutorial.
Signature

Brian Kvalheim
Microsoft Publisher MVP
http://www.publishermvps.com
~pay it forward~

This posting is provided "AS IS" with no warranties, and
confers no rights.


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.