Create name badges in Word: merge an Excel list and check the printout

Create name badges in desktop Word from an Excel list, reconcile every approved recipient and test the label alignment before printing. Follow the checks for menus, label stock and all merged records.

Author: EVENTODIT Editorial Team
Published: 2026-10-26T17:23:42+09:00
Updated: 2026-11-05T03:21:02.938Z
Original URL: https://eventodit.com/en/stories/event-name-badge-mail-merge-all-records.html

Practical summary

Key decision: Check that every approved person appears correctly once instead of approving only the first label’s appearance.

Responsible roles / intended readers: Conference and corporate-event registration and badge-printing teams

Record / next task: Selected recipient list, field-based Word file, complete merged output and print-test confirmation

Basis of information: Official Microsoft label-merge, nametag and Excel-source help. List approval, full reconciliation and reprint management are editorial recommendations.

Editorial review: 2026-11-05

Part 1. Registration and attendee-list lead

To make name badges, connect the approved Excel list to label mail merge in desktop Word for Windows or Mac, reconcile every intended recipient and check a plain-paper test print. Microsoft states that Word for the web cannot perform a mail merge or edit its settings, so this procedure uses the desktop application; check menu names for your version and language.

- Approve the print list and keep versions separate: Decide which cancellations, staff and other attendees belong in this badge run. Do not overwrite the original registration list; preserve the approved print list and its change history separately.
- Distinguish namesakes and duplicate registrations: Separate people with the same name but different organisations from duplicate registrations by one person. Record the confirmed print count and restrict list access to staff who need it for their work and set a retention period.
- Establish a blank-organisation rule: Do not insert an unverified company or invented placeholder when an organisation is blank. Have the data owner decide whether blanks are allowed and apply that rule to the print data.
- Reconcile individuals as well as the total: An equal count can still hide one omission and one wrong inclusion. Compare each person’s name, organisation and role in the approved list and merged output, and check for omissions and duplicates.

Part 2. Layout and label-merge lead

**“Do not trust the first cell alone. Match the actual label stock and create a merged document for review.”**

- Match the product number and dimensions: In desktop Word, use Mailings → Start Mail Merge → Labels and select the supplier and product number on the actual label packaging. If no product matches, use New Label and specify verified sheet, label and spacing dimensions.
- Structure and connect the Excel data: Put names, organisations and roles in separate columns and match the headings to the merge fields. Confirm the sheet and approved recipient rows in Word and resolve source-list errors before connecting it.
- Place fields and update all labels: Insert the required name, organisation and role fields in the first label. Select the columns the badge needs rather than automatically using an address block, then use Update Labels to propagate the layout. Check that subsequent labels retain the Next Record field and avoid manually copying or deleting it in ways that repeat or omit names.
- Generate all merged records: Do not stop at Preview Results. Use Finish & Merge → Edit Individual Documents, select All and create a new document. All covers the records currently included by recipient selection and filters, so first verify that these do not exclude anyone from the approved list. Check that the correct people continue through subsequent labels and page boundaries.

Part 3. Badge printing and on-site review

**“The screen and the sheet are different. Test on plain paper and correct the source of errors.”**

- Test-print on plain paper: Before loading label stock, print on plain paper with the actual printer and print settings. Compare the top, bottom and edge positions and any clipped text against the real label dimensions.
- Check page boundaries and long text: Verify that the first and last recipients and page transitions do not omit or repeat people. Review long names and organisations for clipping or overlap, and check whether blank organisations produce unwanted empty lines.
- Correct the source and merge again: Do not simply alter one instance in the output document. Determine whether the cause is the Excel list, Word field layout or recipient selection, correct the source, regenerate the full merge and review it again.
- Hand over print history and reprints: Retain the checked list, source Word file with merge fields, test-print result and reprint list for the on-site registration team. Limit access to the lists and output to staff who need them.

| Check | Required result | Where to correct errors |
| --- | --- | --- |
| First and last records and page boundaries | No omitted or repeated progression | Recipient selection and merge settings |
| Long names, long organisations and blanks | No clipping, overlap or unwanted empty lines | Field layout and paragraph settings |
| Every selected recipient | Correct approved name, organisation and role | Approved list and connected fields |

Use the original records and supporting templates

Keep the approved print roster and original merge document as the references. In the roster, record a stable registration ID, inclusion/exclusion, duplicate and same-name checks, print/reprint status and owner. In the job log, link the label product/dimensions, Word file, filters, all-record merge, printer/proof result and final version. Prefer review columns and file references in the restricted roster to repeated copies of personal information. Check missing and duplicate IDs and page boundaries as well as the total count.

If you still need to decide who receives a badge and when participation is confirmed, start with [Event audiences, capacity and recruitment conditions](https://eventodit.com/en/stories/event-audience-recruitment-capacity.html). Use [Event registration form keyboard access and error correction](https://eventodit.com/en/stories/event-registration-keyboard-error-recovery.html) to check whether applicants can correct names and organisations before incorrect information reaches the print list.

**Final check before use:** Before merging and printing name badges, cross-check the full approved list, label product dimensions and plain-paper alignment test.

Application conditions

Applies Microsoft desktop Word label-merge and Excel preparation guidance to badges. Menu names vary with version and language.

Unconfirmed information

No particular label stock, printer or event list has been physically tested.

Sources

Microsoft · Word label mail merge and individual review · Checked 26 October 2026
https://support.microsoft.com/en-us/word/training/print-labels-for-your-mailing-list

Microsoft · Nametag labels and plain-paper test printing
https://support.microsoft.com/en-us/word/create-a-sheet-of-nametags-or-address-labels-in-word

Microsoft · Preparing Excel data for labels
https://support.microsoft.com/en-us/excel/create-and-print-mailing-labels-for-an-address-list-in-excel

Microsoft · Set rules for a mail merge and Next Record
https://support.microsoft.com/en-us/word/set-the-rules-for-a-mail-merge

Microsoft · Mail merge and Word for the web limitations · checked 2026-11-05
https://support.microsoft.com/en-us/word/use-mail-merge-for-bulk-email-letters-labels-and-envelopes