Sequential numbering for tickets?

G

Guest

How do I create sequential numbering for draw tickets? I don't want to have
to type in a different number on each ticket?
 
D

Doug Robbins

Create your ticket as a catalog type mailmerge maindocument - Best to use a
one row table for the purpose - and use an Excel spreadsheet contain a
column of numbers (easy to create by putting the first number in the second
cell of the column and in the third cell insert a formula that adds 1 to the
number in the cell above and then copy that formula down as many rows as you
want to create tickets. Add a field name to the first row of the column in
the spreadsheet and use that field name on the tickets where you want the
number to appear.

When you execute the mailmerge, a separate ticket will be created for each
number in the datasource.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top