Merging to text box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Doug Thomson - 25 Aug 2004 19:16 GMT

I'm creating concert tickets using a merge from an excel
document. I have 5 tickets per page. I want to place seat
and row numbers into small text boxes in the main body of
the ticket (to highlight them); the ticket stub has the
same seat an row numbers, but does not place them in text
boxes. When I merge, the Row and Seat numbers merge
correctly in the ticket stub, but not in the text boxes
used in the main body of the ticket. For example the
first page should display Row A and Seats 1 to 5, but
merge is displaying Row A, Seat 5 for all tickets
(choosing only the last seat number on each page). Again
fields not placed in a text box are merging correctly.
Whats up?
Doug

Reply to this Message

Doug Robbins - 26 Aug 2004 01:51 GMT

Instead of using Text Boxes, use a catalog type mailmerge main document with
a single ticket set up on it as a table with borders around the cells in
which you want the row and seat number displayed. Adjust the height of the
table so that five (and only five) of them will fit on a page, though you
only want one in the mailmerge main document. When you execute the merge,
the table will be replicated for each record in the data source, five to a
page if you have it right.

Alternatively, use a label type mailmerge in which you split the cell that
represents each label in the requisite number of cells to achieve the layout
that you want.

Signature

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

> I'm creating concert tickets using a merge from an excel
> document. I have 5 tickets per page. I want to place seat
[quoted text clipped - 10 lines]
> Whats up?
> Doug

Reply to this Message

Doug Thomson - 26 Aug 2004 07:23 GMT

Thanks Doug
The tickets are already set up in a table, but because of
the ticket layout that our concert association wants, I
can't create the design using just table cells. I can do
a work around design that will please them, but I am
still curious why the merge doesn't work properly in text
boxes. Is it a bug or a limitation of text boxes? Just
kind of bothers me, I guess.
Cheers
Doug

>-----Original Message-----
>Instead of using Text Boxes, use a catalog type mailmerge main document with
[quoted text clipped - 25 lines]
>
>.

Reply to this Message