📝 Lesson 6.2: Mail Merge — Personalized Letters, Labels & Emails

Here's a small piece of magic that has saved offices millions of hours: write one letter, point Word at a list of people, and get back a personalized copy for every single one — "Dear Maria," "Dear James," each with the right address, amount, and details filled in. That's mail merge. It's how holiday cards, invoices, event invitations, membership renewals, and mailing labels get produced at scale without retyping anything. In this lesson you'll learn the three moving pieces, run a real letter merge, and — just as important — learn honestly where mail merge lives (the desktop app) and where it doesn't (Word for the web).

📚 What You'll Learn

By the end of this lesson, you will be able to:

Explain what mail merge is: one main document + a data source = many personalized documents
Identify the three pieces — the main document, the recipient list, and the merge fields that connect them
Use the Mailings tab and the Step-by-Step Mail Merge Wizard to produce letters, envelopes, labels, and emails
Insert merge fields, add Rules like If…Then…Else, use Preview Results, and choose Finish & Merge
Recognize the honest limit — full mail merge is a desktop feature; Word for the web can't run it

⏱️ Estimated Time: 50 minutes

🎯 Project: Build a simple personalized-letter merge from a small recipient table, preview it, and complete the merge.

In This Lesson

What Mail Merge Is

Mail merge is one of those features that sounds technical and turns out to be beautifully simple. The whole idea is a single equation:

One main document (the template) + a data source (the list) = many personalized documents.

You write the letter once, but instead of typing "Dear Maria," you type a placeholder — a merge field — that says "put the first name here." You keep the list of people (and their details) separately, usually in an Excel spreadsheet. When you run the merge, Word walks down the list row by row, and for each person it stamps out a copy of the letter with their details slotted into the placeholders. One hundred rows, one hundred personalized letters, in one click.

This is the same "separate content from presentation" thinking that runs through the whole course, applied to data: the wording of the letter is one thing, the details that change per person are another, and mail merge is what marries them. Once you see documents this way — a fixed part and a variable part — you'll spot merge opportunities everywhere: invoices, certificates, name badges, renewal notices, and the classic mailing labels.

graph LR A["📄 Main document
the letter with
merge fields"] --> C{"🔀 Mail merge"} B["📊 Recipient list
Excel sheet or
typed list"] --> C C --> D["✉️ Personalized copy
for each row"] D --> E["Print · save · email"]

🧠 Mindset

Don't picture "an advanced feature." Picture a rubber stamp and a stack of forms. The stamp is your letter; the forms are your list; mail merge presses the stamp once per form and fills in the blanks. Everything else in this lesson is just where the buttons are.

The Three Pieces

Every mail merge, no matter how fancy, is made of exactly three things. Get these clear and the rest is mechanical.

Piece	What it is	Where it lives
Main document	The fixed part — the letter, label, or email — written once, with placeholders where personal details go	A Word document (this is what you have open when you run the merge)
Recipient list (data source)	The variable part — a table where each row is one recipient and each column is a piece of info (first name, address, amount)	Usually an Excel worksheet; can also be a list you type in Word, an Outlook contacts list, or a CSV
Merge fields	The placeholders in the main document that say "put this column's value here" — e.g. `«First_Name»`	Inserted into the main document, one per column you want to use

The recipient list — and why Excel is the natural home for it

The cleanest data source is almost always an Excel spreadsheet: the first row holds column headings (First Name, Last Name, Address, City, Amount), and every row below is one recipient. Word reads those headings and offers each one as a merge field. If you've taken the Excel course in this series, this is exactly the "one row per record, one column per field, headers on top" table discipline you learned — mail merge is one of the big payoffs for keeping data tidy. You can also type a small list directly in Word (Mailings > Select Recipients > Type a New List), which is fine for a handful of names.

⚠️ Clean data in, clean letters out

Mail merge is only as good as your list. A blank cell becomes a blank in the letter ("Dear ,"); a stray space or an inconsistent column name causes fields to go missing. Before you merge, sanity-check the sheet: clear headers in row one, no blank rows in the middle, and consistent formatting (especially for numbers, currency, and dates, which can need extra care to display the way you typed them).

The Mailings Tab & the Step-by-Step Wizard

Everything mail merge lives on one ribbon tab in the desktop app: Mailings. There are two ways to work there — the guided wizard (great while you're learning) and the ribbon buttons (faster once you know the flow). They do the same thing.

The Step-by-Step Mail Merge Wizard (recommended first time)

Go to Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard. A panel opens on the right and walks you through six steps, in plain language:

Select document type — Letters, E-mail messages, Envelopes, Labels, or a Directory.
Select starting document — usually the current document.
Select recipients — browse to your Excel file (or type a new list). Pick the worksheet, then tick/untick recipients and sort or filter if you like.
Write your letter — type the fixed text and insert merge fields where personal details go (Address Block, Greeting Line, or individual fields).
Preview your letters — flip through actual recipients to check it looks right.
Complete the merge — print, or edit individual letters into a new combined document.

The ribbon buttons (the same steps, quicker)

Button	What it does
`Start Mail Merge`	Choose the document type (letter, label, envelope, email…)
`Select Recipients`	Connect your data source — an existing Excel list, a new typed list, or Outlook contacts
`Edit Recipient List`	Sort, filter, and tick who to include
`Address Block` / `Greeting Line` / `Insert Merge Field`	Drop a placeholder into the letter — a whole formatted address, a greeting, or a single column (three separate buttons in the Write & Insert Fields group)
`Rules`	Add logic like If…Then…Else to vary the wording per recipient
`Preview Results`	Toggle between placeholders and real data; step through recipients
`Finish & Merge`	Print, create a merged document, or send as email

Inserting Fields, Rules, Preview & Finish

These four steps are the heart of every merge, so let's slow down on each.

Inserting merge fields

Put your cursor where a personal detail should appear and click Insert Merge Field to choose a column, or use the two smart helpers: Address Block (assembles a properly formatted mailing address from your columns) and Greeting Line ("Dear Maria," with sensible handling of missing names). In the document a field shows as its name in guillemets, like «First_Name» — that's the placeholder, not the final text.

Rules — If…Then…Else and friends

Sometimes the wording itself should change per recipient. Mailings > Rules adds simple logic. The most useful is If…Then…Else: for example, if the Balance column is greater than zero, then insert "Your account has an outstanding balance," else insert "Thank you — your account is settled." Other rules can skip records, ask for a value once, or number records. Rules are what take a merge from "same letter, different name" to "genuinely tailored per person."

💡 Preview before you commit — always

Preview Results swaps the «placeholders» for real data and lets you arrow through recipients. Never skip this. Step to the first record, the last, and a couple in the middle: catch the "Dear ," from a blank name, the address that wrapped oddly, the amount that lost its currency symbol. Fixing it now takes seconds; fixing it after you've printed 300 copies takes reams of paper.

Finish & Merge

When it previews cleanly, Finish & Merge offers three choices: Edit Individual Documents (creates one big new document with every letter — best for a final review or to save a record), Print Documents (straight to the printer), or Send Email Messages (for an email merge — more on that next). Editing individual documents first is the safe habit: you get a document you can scan, spell-check, and keep before anything hits paper or an inbox.

Letters, Envelopes, Labels & Email

The same three-piece machinery drives four everyday outputs. The only real difference is what the "main document" looks like.

Output	What's different
Letters	The classic — one personalized page per recipient. This is the project below.
Envelopes	Word sets the page to an envelope size; you place the Address Block where the address should print. Choose the envelope size to match your stock.
Labels	You pick a label product (e.g. an Avery number) so Word lays out the grid to match the sheet, then merges one recipient per label. Great for mailing labels and name badges.
Email (merge to email)	Each recipient gets an individual, personalized email. Your list must include an email address column, and this route generally relies on Outlook on the desktop to actually send.

⚠️ Email merge etiquette & limits

Merge-to-email sends real, individual messages — so check the preview carefully, and be mindful of anti-spam rules and your mail provider's sending limits (blasting hundreds at once can get you throttled or flagged). For genuine bulk email — marketing newsletters with unsubscribe links and tracking — a dedicated email platform is the right tool, not Word. Word's email merge shines for modest, personal batches: a class, a team, a small membership.

Honest Scope: Full Mail Merge Is a Desktop Feature

This is the honest heart of the lesson, and it's worth being blunt about: full mail merge lives in the Word desktop app. The Mailings tab, the Step-by-Step Wizard, Rules, and Finish & Merge are not in Word for the web. If you open a document on the web, you won't find a Mailings tab at all.

💻 What this means in practice

To run a mail merge you need the desktop app (Windows or Mac), which comes with a Microsoft 365 subscription (or a one-time Office purchase).
Word for the web can't create or run merges. It can open and edit the resulting letters, but the merge engine itself isn't there.
Your data can still be free and cloud-based — the Excel list can live on OneDrive; you just do the merge step in the desktop app.
Prices, plan names, and exactly which features are subscription-only change often, so check Microsoft's current pages rather than trusting a number you read somewhere.

So how do you follow along if you're web-only? Two honest options. First, if you have any access to the desktop app — a work or school PC, a family member's Microsoft 365 — do the hands-on merge there. Second, if you don't, treat this lesson as planning: build your main document and your recipient list now (both doable for free on the web), understand exactly where each merge field would go, and you'll be ready to run the merge the moment you're on a desktop app.

💡 Google Docs comparison

Docs doesn't have a built-in mail merge either — people reach for add-ons (like "mail merge" tools) or Apps Script. So this isn't a Word weakness so much as a "this is a heavier job" reality across word processors: the most capable, built-in mail merge is Word's desktop app. If free-and-cloud is your only constraint, an add-on on Docs and Sheets may be the simpler route; if you have the desktop app, Word's is the most powerful.

🎯 Project: A Personalized Letter Merge

You'll build a real, simple letter merge from a tiny recipient list — just enough rows to see the magic without the fuss. If you have the desktop app, run it end to end. If you're web-only, build the two documents and plan the merge (the hint gives you a paper-merge version so you still see how it works).

🏋️ Merge one letter into several personalized copies

Objective: Produce personalized letters from a main document + a small recipient table using the Mailings tab.

Instructions (about 20 minutes):

(4 min) Make the recipient list: an Excel sheet with headers in row one — FirstName, LastName, City, Amount — and 3–5 rows of made-up people. Save it to OneDrive.
(4 min) Write the main document: a short letter (a thank-you or reminder). Leave the personal details as gaps you'll fill with fields.
(3 min) Desktop → Mailings > Start Mail Merge > Letters, then Select Recipients > Use an Existing List and pick your Excel file and worksheet.
(4 min) Insert fields: a Greeting Line ("Dear FirstName," — the default format is often "Dear Mr. Randall," so pick the first-name-only format such as "Dear Joshua" in the dialog) and individual Insert Merge Field placeholders for City and Amount where they belong.
(2 min) Optional Rule: Rules > If…Then…Else — if Amount is greater than 100, add a "thank you for your generous support" line.
(2 min) Click Preview Results and step through every recipient. Fix anything odd.
(1 min) Finish & Merge > Edit Individual Documents to produce one document with all your personalized letters. Read them.

💡 Hint — a starter letter (and a web-only "paper merge")

Dear «FirstName»,

Thank you for being part of our community here in «City».
Our records show a contribution of $«Amount» this year —
[IF Amount > 100]: and we're especially grateful for your
generous support.

We look forward to seeing you at next month's event.

Warm regards,
[Your name]

--- Web-only? Do a "paper merge" to learn the idea ---
1. Keep the letter and the table side by side.
2. For each row, copy the letter and hand-replace the
   «placeholders» with that row's values.
3. You'll produce the same result by hand — and you'll
   understand exactly what the merge engine automates.

Keep the list tiny (3–5 rows). The point is to see one letter become several personalized copies and to preview before finishing — not to mail anything real.

✅ Project Completion Checklist

You made a recipient list with clear headers and a few rows
You wrote a main document with the fixed wording
You inserted merge fields (a greeting line + at least one column field)
You used Preview Results and stepped through every recipient
You completed the merge (or, web-only, planned/paper-merged it) and read the personalized copies

🎯 Quick Quiz

Question 1: What are the three pieces of every mail merge?

Question 2: You only have Word for the web. What's the honest situation with mail merge?

Best Practices for Mail Merge

✅ Do's

Keep your data clean. One row per recipient, clear headers, no blank rows — the tidy-table discipline from the Excel course pays off directly here.
Always Preview Results. Step through the first, last, and a middle record before you finish — catch blanks and odd wrapping while they're cheap to fix.
Finish to a document first. Use Edit Individual Documents to review and keep a record before printing or emailing.

❌ Don'ts

Don't hunt for mail merge on the web. It isn't there — save yourself the frustration and use the desktop app for the merge step.
Don't blast bulk marketing email via Word. For newsletters with unsubscribe/tracking, use a proper email platform; Word email merge is for modest, personal batches.
Don't ignore number and date formatting. Currency and dates can display differently than in your sheet — check them in preview and format the field if needed.

💡 Pro Tips

Save your main document connected to its data source — reopening it lets you re-merge an updated list in seconds.
Use Rules > If…Then…Else sparingly but well — one or two conditional lines make a merge feel genuinely personal rather than mass-produced.

📓 Learning Journal

Keep a learning journal as you work through this course — a separate document, a note, or even a second Word file right beside the one you're building. After each lesson, take a few minutes to write down:

Key concepts you learned
Techniques that clicked for you
Questions or confusion points to revisit
Ideas you want to try in your own documents
Your progress and feelings about learning this — including where your confidence grew

✍️ This lesson's prompt: What's one real task in your life where mail merge would save you time — invitations, invoices, thank-you notes, labels, renewals? Sketch the three pieces for it: what's the fixed letter, what columns would your list need, and where would the merge fields go? And honestly — do you have access to the desktop app, or will this be a "plan now, run later" skill for you?

📝 Lesson Summary

🎓 Key Takeaways

Mail merge = one main document + a data source = many personalized documents; you write once and Word stamps out a copy per recipient.
The three pieces are the main document, the recipient list (usually an Excel sheet — cross-reference the Excel course), and the merge fields that connect them.
Work from the Mailings tab or the Step-by-Step Mail Merge Wizard: select recipients, insert fields, add Rules (If…Then…Else), Preview Results, then Finish & Merge.
The same machinery produces letters, envelopes, labels, and personalized emails — only the main document changes.
Honest scope: full mail merge is a desktop feature. Word for the web has no Mailings tab — you can build the letter and list for free online, but the merge itself needs the desktop app.

🎉 What You've Accomplished

You now understand one of Word's genuine power features — and you saw past the intimidation to the simple stamp- and-form idea underneath. You know the three pieces, the buttons that connect them, and, just as valuable, the honest limit of where mail merge lives. Whether you ran a real merge or planned one, you can now turn a list into a stack of personalized documents whenever you need to.

❓ Common Questions

Can I really not do mail merge in Word for the web?

Correct — there's no Mailings tab in Word for the web, so you can't create or run a merge there. You can build the letter and the recipient list online for free (the list can live on OneDrive), but the merge step itself needs the desktop app (Windows or Mac), which comes with Microsoft 365. Check Microsoft's current pages for what each plan includes.

What's the best data source for my list?

An Excel spreadsheet is the cleanest choice: headers in row one, one recipient per row. You can also type a quick list in Word or pull from Outlook contacts. The tidy-table habits from the Excel course — consistent headers, no blank rows — make merges behave; messy data produces "Dear ," and missing fields.

My merged amounts or dates look wrong — what happened?

Word sometimes pulls the raw underlying value rather than the formatting you see in Excel, so currency loses its symbol or a date reorders. Catch it in Preview Results, and if needed apply a format switch to the merge field (a desktop feature) or format the value as text in your source. Previewing before you finish is exactly what saves you here.

🔭 Looking Ahead

In the next lesson — Lesson 6.3: Dictate, Translate, Researcher & Add-ins — we shift from producing documents at scale to writing them with more help: voice typing with Dictate, translating a selection or a whole document, the Editor and Read Aloud, Researcher and Smart Lookup, and the world of Office Add-ins — with honest web-vs-desktop and free-vs-paid notes throughout.

✅ Before the Next Lesson

Build (or plan) at least one letter merge with a small recipient list
Note whether you have access to the desktop app for the merge step
Write your Learning Journal entry for this lesson

📚 Additional Resources

🌟 Encouragement for the Journey

Mail merge is one of those skills that quietly marks you as someone who knows Word — the person who can turn a spreadsheet into two hundred personalized letters while everyone else copies and pastes. You've got the whole picture now: three pieces, a handful of buttons, and an honest map of where it works. Next, we make Word help you write. 📝