Mail Merge in Word Browser: What Works and What Doesn’t

Mail Merge in Word Browser: What Works and What Doesn't

You can prepare a mail-merge document and recipient list in a browser, but Word for the web cannot run the merge. To create personalized letters, open the document in the desktop version of Word, connect it to your recipient list, preview the results, and finish the merge there. You will need desktop Word installed and a spreadsheet or other recipient list with one row per person.

What You’ll Need

A Microsoft account and access to Word for the web, plus the desktop version of Word for Windows or Mac. The desktop app is required to set up and complete the merge.
A recipient list, usually an Excel workbook. Give each column a clear heading, such as FirstName, LastName, Email, and Address, and put one recipient on each row.
A Word document for the message. You can draft and save it in Word for the web before opening it in the desktop app.
Permission to access the files. If they are in OneDrive or SharePoint, confirm that your account can open and edit both the document and the recipient workbook.

Step-by-Step

Prepare your recipient list. In Excel for the web or the desktop app, put field names in the first row and recipient details directly underneath. For example, columns might be FirstName, LastName, Street, City, and PostalCode. Keep each person’s information together on one row. Avoid blank rows within the list, merged cells, duplicate column headings, and extra notes above the headings. Check that postal codes, phone numbers, and ID values display as intended; Excel may remove leading zeros if those values are treated as numbers. Save the workbook as an .xlsx file in a location you can access from desktop Word.
Draft the message in Word for the web. Create a new document or open a suitable existing one. Write the parts that are the same for everyone, such as the subject-style heading, main message, sign-off, and your organization’s contact details. Leave obvious placeholders where personalized information should go, for example, a line at the start for the recipient’s name. Save the document to OneDrive or SharePoint so it is easy to find from the desktop app. Do not type a separate copy of the message for every recipient.
Open the document in desktop Word. In Word for the web, look for Editing or the document’s app menu and choose Open in Desktop App. The exact location can vary with the browser layout and account. If the option is not shown, download or sync the document and open it in Word on your computer. Sign in with an account that can access the file. The web version can display and edit the document, but the mail-merge commands needed for the next steps are in desktop Word.
Start a letter merge. In Word for Windows, open the Mailings tab, choose Start Mail Merge, then select Letters. On Mac, use the Mailings tab and choose Start Mail Merge or the equivalent letter-merge option shown in that version. Use letters for a document you plan to print or save as individual personalized documents. If you are creating labels or envelopes, choose that document type instead; the layout steps differ.
Connect the recipient workbook. On the Mailings tab, choose Select Recipients > Use an Existing List. Browse to your Excel workbook and select it. If Word asks which sheet or range contains the data, choose the sheet with the headings and recipient rows, and confirm that the first row contains column headers. If the workbook is open in Excel, close it and try again if Word cannot read it. Review the recipient list through Edit Recipient List if that option is available; remove or clear the selection for any rows that should not receive a letter.
Insert personalized fields. Click in the document where a variable value belongs. On the Mailings tab, choose Insert Merge Field and select the matching column heading, such as FirstName. Add punctuation and spacing around the field as needed. For example, type a greeting such as “Dear ”, insert the FirstName field, then type a comma. You can insert separate fields for the street, city, and postal code in an address block. Use the field list rather than typing a heading name as plain text: only inserted merge fields are replaced with each recipient’s data.
Preview and check several records. Choose Preview Results on the Mailings tab. Use the previous and next record arrows to inspect more than the first recipient. Check that names, addresses, spacing, punctuation, and line breaks look right, including records with long names or missing values. If the displayed information is wrong, turn off preview, correct the source workbook or field placement, and preview again. Do not assume that a good-looking first record means every record is complete.
Finish the merge and review the output. Choose Finish & Merge and select Edit Individual Documents to create a new document containing the merged letters. Choose all records or the intended range, then confirm. Review the resulting document from beginning to end, looking for blank fields, awkward lines, or unexpected page breaks. Save the merged document with a clear name. If you need paper copies, use Finish & Merge > Print Documents instead, but preview the print layout first. Keep the original template and recipient list so you can correct mistakes and run the merge again.

Common Mistakes

Looking for mail-merge tools in the browser. Word for the web does not provide the full controls to create and finish a merge. Drafting the letter online is useful, but switch to desktop Word for the merge itself.
Using inconsistent or unclear headings. A column named First Name may appear as “First Name” in Word, while a heading with trailing spaces or duplicates can be confusing. Use a single, clear heading for each type of information.
Putting two recipients on one row. Word treats each data row as a record. If a couple needs a joint letter, put their shared address and greeting in one row, or create separate records if they should receive separate letters.
Typing placeholders instead of inserting fields. A typed word such as FirstName remains unchanged in every letter. Insert the field through Mailings > Insert Merge Field.
Skipping the preview. Empty cells, long values, and unusual formatting can make some letters look different from the first one. Check several records before producing the full set.
Editing the wrong copy. After the merge, the combined output is a new document. Changes to it do not automatically update the original template or recipient workbook.

Tips

Use short, stable column headings such as FirstName and PostalCode. Clear headings make the field picker easier to use and reduce the chance of choosing the wrong column.
Keep the recipient workbook simple: one header row, one row per recipient, and no decorative title rows above the data. Put explanations or notes on a separate sheet rather than among the records.
Use Excel formatting for display-sensitive information. Set postal codes or account-like identifiers to Text before entering values if leading zeros matter, then check that the displayed values are correct in the workbook and merged letter.
Make a small test list with two or three records, including one with a long name or a blank optional field. Test the layout with it before using a large list. Remember to reconnect the final workbook when you are ready to make the real output.
For a one-off run, choose Edit Individual Documents and save the merged result separately. This gives you a chance to inspect or correct the final letters without changing your reusable template.

Troubleshooting

You cannot find Start Mail Merge. Confirm that the document is open in the desktop Word application, not in a browser tab. If the desktop app is open, select the Mailings tab. If the tab is hidden, widen the window or check the ribbon’s overflow options. The exact ribbon display can differ between Windows and Mac, but the browser version does not have the complete merge workflow.
Word cannot find or open the Excel list. Check that the workbook is saved as .xlsx and that you have permission to open it. If it is stored online, try opening or syncing it through OneDrive first. Close it in Excel and reconnect through Select Recipients > Use an Existing List. If a sheet-selection prompt appears, select the sheet that contains the actual headings and data.
The field list is empty or the wrong headings appear. Inspect the first row of the selected sheet. Move headings to row one, remove blank or merged header cells, and make each heading unique. Save the workbook, then use Select Recipients to reconnect it so Word reads the updated structure.
Every letter shows the same name or literal field text. Make sure Preview Results is on and use the record arrows to move between recipients. If the field name was typed into the document, remove it and insert the correct item using Insert Merge Field. If a field is inserted but the value is still repeated, verify that the source rows contain different values in that column.
Some names or addresses look wrong. Check for blank cells, extra spaces, inconsistent capitalization, or values stored in the wrong column. Correct the source data and reconnect or refresh the recipient list, then preview again. To avoid unwanted blank lines, place address fields carefully and inspect records that have missing address parts.
The merged document has unexpected page breaks or formatting. Review the template for manual page breaks and extra paragraph marks, then preview records with longer text. If the layout is correct in the preview but not in the final output, create the merged document with Edit Individual Documents and inspect its page layout before printing.

Frequently Asked Questions

Can I complete a mail merge entirely in Word for the web?
No. Word for the web can be used to draft or edit the document, but it does not include the full set of commands for selecting recipients, inserting merge fields, and finishing a mail merge. Use desktop Word for those steps.

Do I need to download my Word document first?
Not always. If Word for the web offers Open in Desktop App and the desktop app is installed, use that option. Otherwise, download the document or open a synced copy in desktop Word. Keep track of which copy you are editing.

Can my recipient list stay in Excel for the web?
You can prepare and save the list in Excel for the web, but desktop Word must be able to access the workbook when you connect recipients. If it cannot open the online file, sync or download an .xlsx copy and select that file in desktop Word.

Can I use the same steps for email?
The recipient-list and field concepts are similar, but email merges require an email address field and a compatible mail setup. In desktop Word, choose Start Mail Merge > E-mail Messages and follow the available prompts. Check your organization’s account settings before sending a large batch.

Can I make labels instead of letters?
Yes. In desktop Word, choose Mailings > Start Mail Merge > Labels, select the label vendor and product number, connect the list, and arrange the first label. Use Update Labels to copy the layout across the sheet, then preview before printing. Label sheets need the correct product size and printer settings.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.