Word Mail Merge Complete Tutorial: Generating Custom Letters & Emails with Excel Data

1. How Mail Merge Works

**Mail Merge** connects a master Microsoft Word template document to a data source (usually an Excel spreadsheet). It replaces placeholder tokens (<>, <>, <>) with individual record rows to produce hundreds of customized letters, envelopes, mailing labels, or automated emails in seconds.

---

2. Preparing the Excel Recipient Database

Before starting in Word, your Excel spreadsheet must follow these rules: 1. Row 1 must contain clean column headers without special symbols (FirstName, LastName, Email, AmountDue, DueDate). 2. Do not have blank rows or sub-total rows in the middle of your database. 3. Save and close the Excel file before linking it in Word (leaving it open in Excel can cause file-lock conflicts).

---

3. Connecting Excel to Word Mailings

1. Open your master template document in Microsoft Word. 2. Navigate to the **Mailings** ribbon tab. 3. Click **Start Mail Merge** and select your document type (**Letters**, **Email Messages**, or **Labels**). 4. Click **Select Recipients > Use an Existing List...** 5. Browse and select your Excel spreadsheet, then choose the specific worksheet sheet name containing your recipient data.

---

4. Inserting Dynamic Merge Fields

Place your cursor in your letter where the custom data belongs: 1. Click **Insert Merge Field** in the Mailings tab. 2. Select fields from the dropdown: <>, <>, <>. 3. You can also use the built-in **Greeting Line** feature to configure smart salutations (*"Dear Mr. Smith,"* with a fallback *"Dear Valued Customer,"* if names are missing).

---

5. Fixing Number & Currency Formatting with Switches

A notorious Mail Merge bug occurs when raw Excel numbers (like $1,500.00) or dates appear as unformatted text (1500 or 45678) in Word.

How to Fix Currency with Dynamic Picture Switches (\#):

1. In Word, click on the merge field <> and press **Alt + F9** (or Option + F9 on Mac) to reveal the underlying field code. 2. You will see: { MERGEFIELD AmountDue }. 3. Add the currency switch: { MERGEFIELD AmountDue \# "$#,##0.00" }. 4. For dates: { MERGEFIELD DueDate \@ "MMMM d, yyyy" }. 5. Press **Alt + F9** again to toggle back to normal view and press **F9** to refresh. Your numbers will now render with dollar signs, thousand separators, and decimal formatting!

---

6. Previewing, Filtering, and Executing the Merge

1. Click **Preview Results** in the Mailings tab to step through records and verify layout integrity. 2. Click **Edit Recipient List** to apply filters (e.g. only merge recipients where State = "CA"). 3. Click **Finish & Merge**: - **Edit Individual Documents**: Generates a single massive Word file containing all merged pages for final manual review. - **Print Documents**: Sends directly to your printer. - **Send Email Messages**: Automatically dispatches personalized emails through Microsoft Outlook.