How to Use Mail Merge and Fields for Letters, Labels, and Certificates in Word

At the end of the fall program the Tutoring Club sends three things to every family: a letter with the student's attendance and final review score, a name certificate for finishing the 25-page Course Workbook, and a mailing label for the envelope. With 18 students, copying and pasting each name is slow. With 60 students next spring, it is a recipe for sending one family another child's score.

Mail merge solves this. You write each document once, connect it to the club's Excel roster, and Word produces one personalized copy per student. In this tutorial you will prepare the data, insert fields and rules, format numbers and dates with field switches, and check every record before anything is printed or sent.

How mail merge works

Every merge has three parts:

• The main document: the letter, label sheet or certificate, with the text that is the same for everyone.
• The data source: a list with one row per person and one column per detail, such as an Excel sheet or a Word table.
• Merge fields: placeholders like «FirstName» in the main document. Word replaces each one with the value from the current row.

All the commands live on the Mailings tab, and they run from left to right in the order you use them: start, choose recipients, insert fields, preview, finish. The first choice, Mailings› then Start Mail Merge› then Start Mail Merge, tells Word what kind of document you are making.

Prepare the data in Excel

Most merge problems start in the data, not in Word. Word reads the sheet as a database: the first row is the list of field names, and every row below it is one record. Anything that breaks that pattern breaks the merge. Before you connect, check the sheet against these rules:

• One header row, in row 1. No title, logo or empty rows above it. Use short, unique names without spaces, such as FirstName and ZIP. Word may change spaces and symbols in names to underscores.
• No blank rows or columns inside the list, no merged cells and no totals row at the bottom. Word treats a blank row as an empty record, and a totals row as a student called Total.
• One detail per column. Keep first and last names, street, city, state and ZIP in separate columns, so you can build a greeting from LastName alone.
• ZIP codes as text. Fort Lee's ZIP code is 07024. Stored as a number, it becomes 7024. Format the column as Text before you type, or type an apostrophe first ('07024).
• Save and close the workbook before you connect, so Word isn't blocked by a file that is in use.

Before

Fall roster (updated!!)

Student name	Zip	Score
Minji Park	7024	92.5
Daniel Kim	7024	88
Total		180.5

• ✕Title above the header row
• ✕Full name in one column
• ✕ZIP lost its leading zero
• ✕Blank row and totals row become records

→

After

FirstName	LastName	ZIP	Score
Minji	Park	07024	92.5
Daniel	Kim	07024	88
Sofia	Reyes	07024	95

• ✓Header row in row 1
• ✓One detail per column
• ✓ZIP stored as text
• ✓Every row is one student

Word reads the value in each cell, not the way Excel displays it. A score that shows as 92.5 in Excel may arrive as 92.5000000001, and a date may arrive as 12/17/2026 when you wanted December 17, 2026. Don't fight this in Excel. You will fix the display in Word with field switches later in this tutorial.

Connect and edit the recipient list

Open the family letter and choose Mailings› then Start Mail Merge› then Start Mail Merge› then Letters. Then connect the roster:

1. Choose Mailings› then Start Mail Merge› then Select Recipients› then Use an Existing List.
2. Browse to Fall Program Roster.xlsx and click Open.
3. In the Select Table box, pick the sheet that holds the list, such as Roster$. Keep First row of data contains column headers checked, and click OK.

FileHomeInsertDrawDesignLayoutReferencesMailingsReviewViewDeveloperHelp

Start Mail Merge

Select Recipients

Edit Recipient List

Start Mail Merge

Now open Mailings› then Start Mail Merge› then Edit Recipient List. The Mail Merge Recipients box shows every record with a check box. Clear a check box to leave one person out of this merge without deleting them from the roster. Under Refine recipient list you have more tools:

Filtering and clearing check boxes changes only which records this document merges. The Excel file stays the same. If you find a real mistake, such as a misspelled name, fix it in Excel, save, and in the Mail Merge Recipients box select the file under Data Source and click Refresh.

Insert merge fields, Address Block and Greeting Line

Click where a value should go and choose Mailings› then Write & Insert Fields› then Insert Merge Field, then pick a field name from the list. Word inserts «FirstName» with chevrons. Type spaces and punctuation around fields the same way you would around words: «FirstName» «LastName» needs the space between them.

FileHomeInsertDrawDesignLayoutReferencesMailingsReviewViewDeveloperHelp

Highlight Merge Fields

Address Block

Greeting Line

Insert Merge Field

Rules

Match Fields

Update Labels

Write & Insert Fields

Two composite fields save time:

• Address Block builds a full mailing address from several columns. In its box, choose how the name looks (Ms. Hana Park or Hana Park) and check the preview on the right.
• Greeting Line builds the salutation line, for example Dear Ms. Park, at the top of each letter. You choose the greeting word, the name format and the punctuation, and a fallback such as Dear Family, for records with no usable name.

If the preview in either box shows blanks, Word didn't recognize your column names. Click Match Fields and tell Word, for example, that its Postal Code is your ZIP column and its Last Name is your GuardianLast. Word remembers the match for this document.

«AddressBlock»

«GreetingLine»

«FirstName» attended «Sessions» of 24 sessions in the «Program» program and finished the Course Workbook with a final review score of «Score».

{ IF «Program» = "Math" ... }

Merged values keep the formatting you give the field, so format the chevron text like any other text: bold «FirstName» and every merged name comes out bold.

Rules and field switches

Mailings› then Write & Insert Fields› then Rules adds fields that make decisions. The two you will use most:

• If...Then...Else inserts one text or another depending on a field. Set Field name to Program, Comparison to Equal to, Compare to to Math, then type the Math advice in Insert this text and the Reading advice in Otherwise insert this text. Each family gets the sentence that fits their child.
• Skip Record If leaves out records that match a condition, such as Status Equal to Withdrawn. A filter in Edit Recipient List does the same job and is easier to see and undo, so prefer the filter when you can.

Behind every merge field and rule is a field code. Press Alt+F9 to show all field codes in the document, and press it again to hide them. Shift+F9 toggles only the field your cursor is in. With codes showing, the score field looks like { MERGEFIELD Score } and the rule like { IF { MERGEFIELD Program } = "Math" "Next term, try the Unit 6 challenge sets." "Next term, keep up the 20-minute reading log." }.

You can add a switch inside the braces to control how a value is shown. \# formats numbers and \@ formats dates. Click right before the closing brace, type the switch, press Alt+F9 to hide the codes, then press F9 or preview a record to see the result.

Preview, check for errors and finish

Click Mailings› then Preview Results› then Preview Results to swap the field names for real data. Use the arrows in the same group to move from record to record, and Find Recipient to jump to a particular student. Look at more than the first record: check the longest name, a two-line street address, a Math student and a Reading student, so you see each branch of your rule.

Next, use Mailings› then Preview Results› then Check for Errors. Choose Simulate the merge and report errors in a new document. Word runs the whole merge without producing anything and lists problems such as a field that no longer exists in the data source. Fix them before the real merge.

Finally, open Mailings› then Finish› then Finish & Merge:

All three let you merge All records, the Current record or a range From and To. Merging only the current record is a good test: print one letter and check it on paper before printing eighteen.

Labels and name certificates

Labels. Start a new blank document and choose Mailings› then Start Mail Merge› then Start Mail Merge› then Labels. In Label Options, pick the Label vendors and Product number printed on your label box, such as Avery US Letter 5160. Word fills the page with a table, one cell per label. Then:

1. Connect the roster with Select Recipients and filter it as before.
2. In the first label only, insert an Address Block.
3. Click Mailings› then Write & Insert Fields› then Update Labels. Word copies the layout to every label and adds a «Next Record» field to each one, so each label moves to the next student.
4. Preview, then Finish & Merge› then Edit Individual Documents, and print one test sheet on plain paper. Hold it against a label sheet to check the alignment.

If you can't see where the labels are, turn on Layout› then Table› then View Gridlines. For one label, or a full sheet of the same return address, you don't need a merge: use Mailings› then Create› then Labels instead.

Name certificates. A certificate is a one-page letter merge. Design the page once, in landscape, with a border and the club logo. Where the name goes, insert «FirstName» «LastName» and format it large, such as 36 pt. Add «Program» to the line for completing the «Program» Course Workbook, and a ceremony date field with a \@ switch. Filter the recipients to Status = Completed, then finish with Edit Individual Documents and print on card stock.

Tutoring Club · Fort Lee Community Center

Certificate of Completion

This certifies that

«FirstName» «LastName»

completed the «Program» Course Workbook, Fall 2026

«Ceremony»

Common mistakes

Practice

Practice

Merge family letters, labels and certificates

Guided practice

Download the example file above. It contains the family letter with bracketed placeholders, the certificate text, and the fall roster as a Word table on the last page. You will turn the table into a data source and merge all three documents.

1. Data source: copy the roster table into a new blank document and save it as Fall Roster.docx in the same folder. (Or paste it into Excel, check that ZIP codes keep their zero, and save Fall Program Roster.xlsx.) Delete the roster page from the letter file.
2. Connect: in the letter, choose Mailings› then Start Mail Merge› then Start Mail Merge› then Letters, then Select Recipients› then Use an Existing List and pick your roster.
3. Clean the list: in Edit Recipient List, sort by LastName, use Find duplicates to clear the student who appears twice, and filter Status to Completed.
4. Fields: replace the address placeholder with an Address Block, the greeting with a Greeting Line, and [First name], [Sessions], [Program], [Score] and [Ceremony] with merge fields.
5. Rule: replace [Advice] with an If...Then...Else rule that gives Math students the Unit 6 sentence and everyone else the reading log sentence.
6. Switches: press Alt+F9, add \# "0.0" to the Score field and \@ "dddd, MMMM d" to the Ceremony field, press Alt+F9 again and preview three records.
7. Check and finish: run Check for Errors (simulate), then Finish & Merge› then Edit Individual Documents. Read the merged letters and save them as a PDF.
8. Labels: in a new document, merge Avery 5160 address labels from the same roster using Address Block and Update Labels.

Independent challenge: Certificates and a directory

Build the name certificate from the certificate text in the practice file: landscape page, a large «FirstName» «LastName», the program and a formatted ceremony date. Merge only completed students. Then make a Directory merge that lists every student on one page as LastName, FirstName · Program · Sessions, for the volunteers' clipboard.

Reflect: which mistakes in your own lists, such as blank rows, combined names or numbers stored the wrong way, would have broken this merge, and how will you set up the next list to avoid them?

Check your understanding0 of 4 correct

Pick an answer to see whether it's right and why.

1. 1. Your merged labels show 7024 instead of 07024. Where is the best place to fix this?

   • Retype the ZIP in every label
   • Change the label size in Label Options
   • Store the ZIP column as text in Excel
   • Turn on Highlight Merge Fields

2. 2. Which field code shows a ceremony date as December 17, 2026?

   • { MERGEFIELD Ceremony \@ "MMMM d, yyyy" }
   • { MERGEFIELD Ceremony \# "MMMM d, yyyy" }
   • { MERGEFIELD Ceremony \# "0.0" }
   • { DATE Ceremony }

3. 3. You set up an Address Block in the first label of a label sheet. What fills the other labels?

   • Copy and paste the field into each label
   • Preview Results
   • Edit Recipient List
   • Update Labels

4. 4. You've finished the letter and want to read every merged copy before printing. Which Finish & Merge choice do you pick?

   • Print Documents
   • Edit Individual Documents
   • Send Email Messages
   • Check for Errors

You're ready to move on when

Tick each one off as you go. Your ticks are saved in this browser only.

• Your roster has one header row, no blank rows and ZIP codes stored as text
• You connected a letter to the roster and used sort, filter and Find duplicates
• You inserted merge fields, an Address Block, a Greeting Line and an If...Then...Else rule
• You formatted a number and a date with \# and \@ switches using Alt+F9
• You previewed several records, checked for errors and merged letters, labels and certificates