mailmerge - MS Word Mail Merge where each row of data will produce multiple columns - Stack Overflow

admin管理员组

文章数量:1352878

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

Share Improve this question Follow asked Mar 31 at 23:00 user2257746user2257746 1111 bronze badge New contributor user2257746 is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct. 1

• 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

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

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.

本文标签： mailmergeMS Word Mail Merge where each row of data will produce multiple columnsStack Overflow