Use Word’s desktop mail merge to turn one cover-letter template and an Excel contact list into a separate, personalized letter for every selected row. Excel supplies fields such as the recipient’s name, company and address; Word supplies the layout, fixed text and final documents.
The dependable sequence is: clean the workbook, connect it through Mailings > Select Recipients, insert and preview the fields, then use Finish & Merge to create editable letters or print them. The steps below cover the setup, personalization choices, quality checks and the fixes for common failures.
As an Amazon Associate I earn from qualifying purchases.
What Word mail merge creates
Mail merge produces a batch of letters that share the same page design, formatting, wording and graphics while changing selected parts for each recipient. A single Word file can therefore generate a different salutation, employer name, job title, address or role-specific sentence for every selected Excel row.
The Tool Desk
Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Think of the two applications as having separate jobs:
#1 Best Overall
- Classic Office Apps | Includes classic desktop versions of Word, Excel, PowerPoint, and OneNote for creating documents, spreadsheets, and presentations with ease.
- Install on a Single Device | Install classic desktop Office Apps for use on a single Windows laptop, Windows desktop, MacBook, or iMac.
- Ideal for One Person | With a one-time purchase of Microsoft Office 2024, you can create, organize, and get things done.
- Consider Upgrading to Microsoft 365 | Get premium benefits with a Microsoft 365 subscription, including ongoing updates, advanced security, and access to premium versions of Word, Excel, PowerPoint, Outlook, and more, plus 1TB cloud storage per person and multi-device support for Windows, Mac, iPhone, iPad, and Android.
- Excel is the data source. Each row is a recipient and each column is a field that Word can insert.
- Word desktop is the document engine. It holds the cover-letter text, places merge fields and generates the individual output.
The merge document remains useful after the first batch. When you save it, Word retains its connection to the workbook, so you can reuse the same letter design with an updated recipient list when the data source is still available.
“Mail merge lets you create a batch of personalized letters where each letter is identical in layout, formatting, text, and graphics, except for personalized parts like the salutation.”
— Microsoft Support, Use mail merge to personalize letters
Recommended Free Tools
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Requirements and supported Word editions
Run the merge in the installed desktop application, not in a browser tab. Microsoft lists Word for Microsoft 365, Word 2024, Word 2021, Word 2019 and Word 2016 for supported Windows and Mac workflows.
| Application or edition | What it can do | Important limitation |
|---|---|---|
| Word desktop for Microsoft 365, 2024, 2021, 2019 or 2016 | Create, edit, preview and finish a letter merge on supported Windows and Mac installations. | The exact ribbon appearance can vary slightly by platform or update, but the Mailings commands remain the route to the merge. |
| Word for the web | Open a document that was prepared in desktop Word and preserve its merge settings. | It cannot execute a merge or edit merge settings. Open the file in desktop Word to connect data, preview records or finish output. |
| Excel workbook | Provide the rows and column fields used by the letter. | Keep the data in the first worksheet, use a contiguous table, and store the file locally or on a supported file share. An HTTP location is not supported as a mail-merge data source. |
Have the workbook and Word document available before you start. If more than one person will use the files, choose a shared location that Word supports rather than an HTTP address.
Prepare the Excel workbook before connecting it
Most merge errors originate in the source sheet, not in the letter. Finish additions and corrections in Excel before you connect the workbook. If you change the structure afterward, reconnect or refresh the data source as appropriate.
Use a clear header row
Put one header row at the top of the first worksheet. The headings become Word’s available merge fields, so name them for the information the cover letter actually needs. A practical set is:
Quick wins for a faster PC:
Repair Windows errors before they cause bigger problemsFix Now →Scan for outdated or missing drivers - takes under a minuteDriver Scan →| Excel heading | Typical use in the letter |
|---|---|
FirstName |
Personal salutation or opening sentence. |
LastName |
Formal greeting, addressee line or filing reference. |
Company |
Employer name in the greeting, body or address. |
JobTitle |
The role being targeted in a customized sentence. |
Address |
Street or complete address information used by an address block. |
Add other columns only when they support a real insertion point, such as City, State, PostalCode, ReferralSource or Location. Avoid headings that differ only by punctuation or spelling; consistent names make the field list easier to understand.
Rank #2
![Microsoft Office Home & Business 2024 | Classic Desktop Apps: Word, Excel, PowerPoint, Outlook and OneNote | One-Time Purchase for 1 PC/MAC | Instant Download [PC/Mac Online Code]](https://m.media-amazon.com/images/I/41H8B5iqO4L._SL160_.jpg)
- [Ideal for One Person] — With a one-time purchase of Microsoft Office Home & Business 2024, you can create, organize, and get things done.
- [Classic Office Apps] — Includes Word, Excel, PowerPoint, Outlook and OneNote.
- [Desktop Only & Customer Support] — To install and use on one PC or Mac, on desktop only. Microsoft 365 has your back with readily available technical support through chat or phone.
Keep the data contiguous and on the first worksheet
Place the header row and all recipient records in one uninterrupted block on the first worksheet. Do not put blank rows, explanatory notes or a second unrelated table inside that block. Word reads the selected sheet or table as the recipient source, and a clean rectangular range makes the available records predictable.
Format values for the way they must appear
- Format postal codes as text when leading zeroes matter. A code such as 01234 must not be converted to 1234 before Word reads it.
- Review dates, currencies and percentages in Excel before linking. Word uses the source values and formatting it receives, so decide whether a date, amount or percentage should appear with a particular display format.
- Check capitalization, punctuation and spaces in names and company names. A merge will reproduce an extra space or an inconsistent abbreviation in every affected letter.
- Leave a field genuinely blank when you do not have the information. Then design the letter so a missing value does not leave awkward punctuation.
Save in a location Word supports
Save the workbook locally or on a supported file share, and keep its name and location stable while you build the merge. Microsoft’s data-source guidance does not support an HTTP location for mail merge. If a shared file is moved, renamed or permission-restricted, Word may ask you to locate or reconnect the source.
Build the personalized cover-letter merge in Word
Use this sequence in the desktop Word application. The commands are shown with their current ribbon labels.
Windows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallOutdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware match-
Start a letter merge
Open Word and choose Mailings > Start Mail Merge > Letters. You can begin with a blank document or open an existing cover-letter template. The Letters type tells Word that each output should use the same letter layout while varying the inserted fields.
-
Write or paste the fixed cover-letter content
Enter the date line, sender details, subject, body paragraphs, closing and any graphics that should appear in every version. Keep wording that is common to all applicants as ordinary text. Leave deliberate insertion points for the recipient’s name, company, job title, location or referral source.
-
Connect the Excel list
Choose Mailings > Select Recipients > Use an Existing List. Select the prepared Excel workbook, then choose the appropriate worksheet or table when Word prompts you. Confirm that the sheet containing the header row and contiguous records is selected.
-
Choose who will receive a letter
Open Mailings > Edit Recipient List. Clear the check box for any row that should not receive a letter. Use the list controls to sort or filter when you need a particular order or a subset, such as one job title or one location. The selected rows, not every row in the workbook, become the merge population.
DriversOutdated Drivers Are Slowing You DownPerformancePC Slower Than It Used to Be?DriversCrashes, No Sound, or Screen Glitches?Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy. -
Insert a standard salutation
Place the cursor where the greeting belongs and choose Mailings > Greeting Line. Select the greeting style and punctuation, then inspect the result in preview. This is convenient when a consistent salutation is appropriate and the source contains suitable name fields.
Rank #3
Microsoft 365 Personal | 12-Month Subscription | 1 Person | Premium Office Apps: Word, Excel, PowerPoint and more | 1TB Cloud Storage | Windows Laptop or MacBook Instant Download | Activation Required- Designed for Your Windows and Apple Devices | Install premium Office apps on your Windows laptop, desktop, MacBook or iMac. Works seamlessly across your devices for home, school, or personal productivity.
- Includes Word, Excel, PowerPoint & Outlook | Get premium versions of the essential Office apps that help you work, study, create, and stay organized.
- 1 TB Secure Cloud Storage | Store and access your documents, photos, and files from your Windows, Mac or mobile devices.
- Premium Tools Across Your Devices | Your subscription lets you work across all of your Windows, Mac, iPhone, iPad, and Android devices with apps that sync instantly through the cloud.
- Easy Digital Download with Microsoft Account | Product delivered electronically for quick setup. Sign in with your Microsoft account, redeem your code, and download your apps instantly to your Windows, Mac, iPhone, iPad, and Android devices.
-
Insert address information when needed
Place the cursor in the recipient-address area and choose Mailings > Address Block. Select the address layout that matches your letter. Address Block is intended for address information; it is separate from the greeting and does not replace a custom company or job-title field in the body.
-
Insert custom fields
For a field that Greeting Line or Address Block does not cover, choose Mailings > Insert Merge Field and select the relevant column, such as
FirstName,Company,JobTitle,LocationorReferralSource. Type the surrounding words and punctuation as normal text. For example, a sentence can combine a fixed phrase with the Company and JobTitle fields. -
Preview every kind of record
Choose Mailings > Preview Results. Use the next and previous record controls to inspect the first, a middle and the last selected record, plus records with unusually long names or missing values. Check the greeting, address lines, company spelling, spaces, punctuation, line wrapping and page breaks before producing output.
Do these 3 things before closing this tab:
1Fix the driver behind crashes, sound loss and screen glitches2Repair Windows errors before they cause bigger problems3Scan for outdated or missing drivers - takes under a minuteSpecial offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy. -
Finish the merge
Choose Mailings > Finish & Merge. Select Edit Individual Documents when you want Word to create an editable document containing the personalized letters for a final per-letter review. Select Print Documents when the preview is correct and you are ready to send the selected letters to a printer. Save the merge document so its data-source connection remains available for the next batch.
Choose the right personalization method
Greeting Line for a conventional salutation
Greeting Line is the quickest way to create a repeated salutation such as a formal greeting. It keeps the greeting format consistent across records and is useful when your list has dependable first- and last-name data. Preview records with blank or unusual names; a standard greeting cannot fix a source row that lacks the information it needs.
Insert Merge Field for precise control
Use Insert Merge Field when you need exact placement or wording. A cover letter might insert FirstName in the opening, Company in a sentence about the employer, and JobTitle in a sentence explaining the applicant’s interest. Manual field placement also lets you separate a company name from an address block or include a referral source only where it belongs.
Rules for conditional wording
For genuinely different wording, use Mailings > Rules. A rule can customize text based on a value in the data source, such as adding one sentence for a particular location or referral source. Keep each branch short, make sure the underlying column has consistent values, and test every branch with Preview Results before finishing. Conditional text is powerful, but it adds another set of paths that must be proofread.
Control recipients and review the finished letters
Verify the recipient population
Open Edit Recipient List before previewing and confirm the selected count. Deselect people who have withdrawn, records outside the job search or rows that are incomplete. Sorting can make a review easier, while filtering can limit the batch to a defined group; neither changes the underlying workbook.
Rank #4
- Designed for Your Windows and Apple Devices | Install premium Office apps on your Windows laptop, desktop, MacBook or iMac. Works seamlessly across your devices for home, school, or personal productivity.
- Includes Word, Excel, PowerPoint & Outlook | Get premium versions of the essential Office apps that help you work, study, create, and stay organized.
- Up to 2 TB Shared Cloud Storage | Store and access your documents, photos, and files from your Windows, Mac or mobile devices.
- Premium Tools Across Your Devices | Your subscription lets you work across all of your Windows, Mac, iPhone, iPad, and Android devices with apps that sync instantly through the cloud.
- Share Your Family Subscription | You can share all of your subscription benefits with up to 6 people for use across all their devices.
Use a deliberate preview sample
Do not inspect only the first row. Check the first, middle and last records, and deliberately select rows with long names, missing fields, unusual punctuation or different address lengths. Look for a blank greeting, a doubled space, a comma left behind after an empty field, an address that wraps unexpectedly or a paragraph pushed onto a new page.
Decide whether to edit or print
| Finish option | Best use | What you receive |
|---|---|---|
| Edit Individual Documents | You need a final editable review or an occasional per-letter adjustment. | A new Word document containing the personalized letters for the selected records. |
| Print Documents | The preview is approved and no individual edits are required. | The selected personalized letters sent directly to the printer. |
Even when you plan to print, use Preview Results first. If a particular letter needs a human change, choose Edit Individual Documents, make the correction in that generated document and retain the original merge document for future batches.
Keep the merge reusable
Save the Word merge document after connecting the workbook and placing the fields. Keep it with the source workbook, using stable file names and a location that future users can access. The saved connection allows the same layout to be reused rather than rebuilt for every hiring round.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
When the list changes, make additions and corrections in Excel before opening the merge. If Word does not show the new structure or records, reconnect or refresh the data source as appropriate, then reopen Edit Recipient List and Preview Results. Treat the workbook as the authoritative list and the Word file as the presentation template.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Common problems and how to fix them
The merge fields list is empty or incomplete
Check that you selected Use an Existing List, chose the correct workbook and selected the worksheet or table containing the header row. Make sure headings are in the first row of a contiguous range and that the workbook was saved after the headings were added. If you changed columns after connecting, reconnect or refresh the source.
Word inserts the wrong value under a field
Inspect the Excel heading and the row values. A heading becomes the field name, so similarly named columns can be easy to confuse. Rename ambiguous headings in Excel, save the workbook and reconnect if necessary. Then use Preview Results to verify that each insertion point displays the intended column.
Postal codes lose leading zeroes
Format the postal-code column as text in Excel before connecting. Correcting the display in Word cannot restore a zero that Excel already removed from the stored value. Reconnect or refresh after changing the format and preview a record from the affected region.
Free tools Windows power users keep installed
One-click scans. No signup required.
New rows do not appear
Finish the additions in Excel, save the workbook and check the selected sheet or table. If the merge was already connected, reconnect or refresh the data source when appropriate. Then reopen Edit Recipient List and confirm that the new records are selected.
Best Value
- GREAT ALTERNATIVE - This Open Office Suite is a great alternative to MS Office and enables you to create beautiful and practical Documents, Spreadsheets, and Presentations.
- VERSITLE - This DVD includes both Windows and Mac installation files, just follow the steps included on installation guide.
- LICENSE - Perpetual License granted and when connected to the internet the Open Office Suite will check for uptades and will give you the option to install them.
- EXTRAS - Enjoy all the Extras- Installation Guides, User Guides, Clipart Library, Template Library are all included on the DVD.
- COMPATIBLE - Extensive compatibility across Windows 11, 10, 8, 7, Vista, XP and MacOS 10.7 to 10.15
A greeting or sentence has awkward blanks
Preview rows with missing data. A blank field can leave extra spaces, punctuation or a sentence that no longer makes sense. Adjust the fixed wording, move the field, or use a Mailings > Rules condition that supplies alternate text. Test both the populated and blank cases.
The source cannot be opened from its location
Move or copy the workbook to a local folder or a supported file share and reconnect it. An HTTP location is not supported for Word mail-merge data sources. Also verify that you have permission to open the file and that it has not been renamed since the merge document was saved.
The document works in a browser but will not merge
Word for the web can preserve settings in a document created in desktop Word, but it cannot run the merge or edit its settings. Download or open the file in the installed desktop version, then perform the connection, preview and Finish & Merge steps there.
Page breaks or spacing change between recipients
Use Preview Results on records with long company names, addresses and job titles. Check paragraph spacing, table widths and the placement of the address block. If a field can contain a long value, allow the surrounding layout to wrap naturally rather than relying on a fixed line length.
Example cover-letter layout
The following illustrates where fields can sit; the surrounding prose remains ordinary Word text.
Dear «FirstName», I am applying for the «JobTitle» position at «Company». My experience in [fixed skills or experience] would allow me to contribute to your team. I would welcome the opportunity to discuss how my background fits the role and your needs in «Location». Sincerely, [Applicant name]
Insert the displayed fields through Mailings > Insert Merge Field rather than typing angle-bracket text as ordinary characters. If a standard salutation is sufficient, replace the first line with Greeting Line. If a recipient lacks a location, use a rule or rewrite the sentence so the blank does not damage the paragraph.
Final pre-output checklist
- The workbook has a clear header row, contiguous records and all data on the first worksheet.
- Postal codes, dates, currencies and percentages display correctly in Excel.
- The workbook is saved locally or on a supported file share, not at an HTTP location.
- The correct worksheet or table is connected through Select Recipients > Use an Existing List.
- Edit Recipient List contains only the people who should receive a letter.
- Greeting Line, Address Block and custom fields appear in the intended positions.
- First, middle, last, unusual-name and missing-field records have been inspected with Preview Results.
- Conditional branches created with Mailings > Rules have been tested.
- You chose Edit Individual Documents for a final editable review or Print Documents only after approval.
- The merge document and source workbook are saved together for reuse.
With a clean first worksheet, a deliberate recipient selection and a full preview, Word can reliably turn one cover-letter design into a separate, personalized letter for every approved Excel row.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
