How to Mail Merge Attendee Data in MS Word (Single Sided)

Ensure you have downloaded the correct template from the Templates section.

Set up your artwork using our MS Word Artwork Instructions.

Organise your data into columns in your Excel spreadsheet. If your data is in a Google sheet, download it as an Excel file.

With the template open, click “Mailings” in the top menu bar.

Click “Select Recipients” and from the dropdown menu chose “Use Existing List”, select your .xlsx spreadsheet.

Select your spreadsheet of data then in the pop-up, ensure the “First row of data contains headers” box is checked on. Then click “OK”.

Select “Insert Merge Field” to start inserting data fields.

a) Highlight “Your” then click the corresponding field.

b) Repeat for all merge fields.

For the remaining badges, highlight all the text on each badge and insert a “Next Record” rule.

To update the badges with the “Next Record” rule, click “Update Labels”

You can now preview your merged badges by clicking “Preview Results”. You can make any formatting changes required.

Select “Finish & Merge” > “Edit Individual Documents”.

You should now have a multi-page document with all your badges merged and ready to print! You can edit individual badges now too.