I'm working at an event. We have a list (Excel spreadsheet) of attendees. For each attendee, I need to produce a name badge and some sponsor tickets. The sponsor tickets will also have the sponsor's logo on them or the event logo for the name badge.

I'm trying to get this to work using some labels on perforated paper (Legal size, 3 columns, 8 rows for a total of 24 labels on each sheet). For this perforated paper, there are no margins between the paper edges and the start of the labels.

Using MS Word, I have found how to have multiple rows combine to where they go onto one mail merge result (usually in a letter format). But when working with labels, I only see how to create one label, and that one label is used across the entire data file.

Is there a way to have the mail merge be a block of columns/rows so that one row from the spreadsheet can drive multiple columns/rows for the mail merge output?

I'm not restricted to using MS Word. Anything else that could accomplish this (even PowerShell) will suffice.

Thanks!

I'm working at an event. We have a list (Excel spreadsheet) of attendees. For each attendee, I need to produce a name badge and some sponsor tickets. The sponsor tickets will also have the sponsor's logo on them or the event logo for the name badge.

I'm trying to get this to work using some labels on perforated paper (Legal size, 3 columns, 8 rows for a total of 24 labels on each sheet). For this perforated paper, there are no margins between the paper edges and the start of the labels.

Using MS Word, I have found how to have multiple rows combine to where they go onto one mail merge result (usually in a letter format). But when working with labels, I only see how to create one label, and that one label is used across the entire data file.

Is there a way to have the mail merge be a block of columns/rows so that one row from the spreadsheet can drive multiple columns/rows for the mail merge output?

I'm not restricted to using MS Word. Anything else that could accomplish this (even PowerShell) will suffice.

Thanks!

• ms-word
• mailmerge

• Is there a variable number of sponsor tickets per attendee? Do the labels for attendees and for sponsor tickets have different information on them (or could you use the same layout for all the labels?) Broadly speaking if you have variable numbers, generating a data source with one row per label would be preferable; if you have different layouts then you would need to use some item in the data to tell Word which layout to use, and use { IF } fields to let you define different layouts. If you know Excel and VBA, probably simpler to generate your layouts just using those. – jonsson Commented Apr 1 at 10:23

1 Answer 1

Assuming you need one name badge and two sponsor tickets per record, the simple solution is to use a letter merge with the name badge and two sponsor ticket labels on the same row. Then copy and paste that row's content to the remaining seven rows. Having done that, insert a NextRecord field at the start of the 2nd through 8th name badges.