How can I created numbered ballots using Publisher and excel?

[Pegsimer]

I'm trying to create ballots for an upcoming teachers union election. I want
to print the ballots so that each have a different number. I have already
created a ballot on Publisher. Is there someway to merge numbers from Excel?
My ballots are postcard size and two up.

 

[Ron Cohen]

I just posted the solution below in response to another users similar
question. Create the number list in Excel and use mail merge to import the
list of numbers. Then use the following to print the ballots.

Set the document so that the page size is equal to a single ticket. Then
under the print menu change the page options to print multiple copies on a
single sheet. From page options click custom options to adjust the spacing.
This is how it's done with Pub2000. For newer versions, the principle is the
same, but I think the wording is slightly different.

 

[Brian Kvalheim - [MSFT MVP]]

The following link has a tutorial for this:

http://www.publishermvps.com/Default.aspx?tabid=95
--
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.