ms-wordmailmerge

MS Word Mail Merge where each row of data will produce multiple columns


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!


Solution

  • 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.