how to place 6 mail merge items on one page

August 24, 2010 at 20:52:16
Specs: Windows Vista
i have a page with 6 tickets on it ...all of them need to have a section, row and seat number on them

See More: how to place 6 mail merge items on one page

Report •

August 24, 2010 at 23:03:45
i found this...may be this will helpful to you...

edited by moderator: Created usable link

Report •

August 26, 2010 at 05:44:21

You haven't given any details about the database used for the mail merge, so I can't offer specific details on that.

However, in general, to get the data for 6 tickets onto one page, I created a new named range on an Excel worksheet that consisted of several rows, each containing information on 6 tickets - there were 18 columns, 3 items (section, row & seat) for each ticket.
The heading row for the named range used "T1_Section", "T1_Row", "T1_Seat", T2_Section", T2_Row", T2_Seat" and so on for all 18 columns.

In the Word document I was able to select the information for each of the six tickets, and insert each of the 18 fields (using the 'Insert Merge Field' drop-down) and mail merge then created a series of 6-ticket documents.


Report •

Related Solutions

Ask Question