Mail Merge: Printing Guest Names onto Place Cards

Mail merge generates dozens or hundreds of place cards from a single guest list. It is faster than typing each name individually and catches data errors before they reach paper.

Preparing the guest list

Build the list in Excel or Google Sheets with one column per piece of data: First Name, Surname, Table, Meal Choice. Avoid merged cells, blank rows in the middle of the list, and notes in the data range — mail merge reads everything in the data area, including stray entries. Use plain text formatting; bold or italic styles in the source spreadsheet do not survive the merge. Save the file as .xlsx for Word merging, or keep it in Google Sheets for Docs-based merging.

Word + Excel mail merge

In Word, open the place card template. Go to Mailings > Start Mail Merge > Labels and confirm the label vendor and product number — Avery 5302 for 8-up tent cards is a common choice. Mailings > Select Recipients > Use an Existing List points Word at your Excel file. Click into the first card cell and use Mailings > Insert Merge Field to drop in First Name (or Surname, or both). Mailings > Update Labels copies the field setup across every cell on the sheet so each card pulls the next entry from the list.

Preview before committing. Mailings > Preview Results steps through the merged sheet card by card. Look for truncated names, missing entries, and double spaces. Mailings > Finish & Merge > Print sends the populated sheet to the printer.

Google Docs + Sheets alternative

Google Docs does not include native mail merge for labels. Add-ons from the Google Workspace Marketplace — Autocrat is the most established — read a Sheets file and populate a Docs template with each row’s data. The setup is more steps than Word’s built-in merge, but the workflow handles the same job: source data in a sheet, merge fields in a template, output as a populated document or PDF. For very small lists, copy-paste from a sheet into the Docs template is faster than configuring the add-on.

Pitfalls

The three most common merge problems: long names that truncate against fixed cell widths, special characters (hyphens, apostrophes, accented letters) that import incorrectly from older spreadsheet files, and inconsistent capitalisation in the source list. Standardise the list before merging — capitalise names consistently, decide whether middle initials appear, and shorten or abbreviate any name that exceeds the cell. The merge will print exactly what is in the data; cleanup happens before, not after.

For full event coverage including planning and printing logistics, see our wedding place cards walkthrough and free printable place card templates. For the same workflow applied to event badges, see the name badge mail merge guide.