An easy way to design the conference name tags
00 min
Aug 26, 2022
Aug 26, 2023
This post describes using Microsoft Word and Excel to generate conference name badges quickly. It is motivated by the blog.


In the first step, you need to have three files in your hand:
  • Background image: Photoshop-designed background .png or .jpeg image with all conference information that you would like to include except the attendee's name and affiliation. You can design your own image size, but a preferred size is height 5.08cm x width 8.89cm.
  • Attendee list (Excel): a .xlsx file with all attendees' details.
  • Name badges (Word): a .docx file with the template of name badges.

Create the template of name badges

Create the.docx file with Layout -> Margins -> Custom Margins and set the margins with the below values:
Create 2*5 blank tables:
notion image
And resize the Layout -> Height and Width to height 5.08cm x width 8.89cm to ensure each page will include ten badges.
notion image
Insert the background image into the first cell and set Wrap Text -> Behind Textthe Size and Position of the image as:
notion image
Then match the background image with the cell border. Choose suitable font position (Centre Text with 1.5 Line Spacing) and font size for name and affiliation.

Create the name badges

  1. Select Mailings -> Select Recipients -> Use an existing list and select the Attendee list in a specific directory.
  1. Insert Merge Field and set the <<Name>>. In the second line, select the <<Affiliation>> filed.
  1. Copy all content in the first cell, including the background image and paste it into the second cell.
  1. In the second cell, add rules to let the Word generate the second attendee name badge with Mailings -> Rules -> Next Record, and it will be like:
    1. Copy the second cell for all the rest cells.
    1. Preview and Mailings -> Finish & Merge -> Edit Individual Document.
    Way to rotatepage in LaTex
    Better way to add website search engine for Jekyll-based website

    • Twikoo
    • Giscus