How to Mail Merge Attendee Data in MS Word (Double 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”.

To merge the names on both sides of the badge, create a “Next Record” rule for just the left badges.

You can now preview your merge and click “Finish & Merge” > “Edit Individual Documents”