What mail merge does and why you might want it

Mail merge in Word takes a list of names, addresses, or other information stored in a separate file and automatically fills those details into a template letter or document. Instead of typing each recipient's name by hand or copying and pasting the same letter dozens of times, you create one document with placeholders — Word pulls the real data in and generates a personalized version for each person on your list.

The most common use is sending personalized letters to many people at once: a landlord sending lease renewal notices to 50 tenants, a nonprofit thanking donors, or a small business following up with clients. You write the letter once, tell Word where to find the contact information, and it produces a separate document for each recipient.

The privacy angle matters here: your contact list stays in a separate file (usually a spreadsheet) that you control. Word doesn't upload it anywhere or store it on Microsoft's servers unless you explicitly save the merged document to OneDrive or SharePoint. If you keep both files local, the data never leaves your computer.

Key Takeaways

  • Mail merge requires two files: a template document in Word and a data source (usually an Excel spreadsheet or CSV file) containing the names and addresses you want to insert.
  • The data source stays on your computer by default — Word does not send your contact list to Microsoft's servers unless you save the final merged document to cloud storage.
  • You mark placeholder locations in your template using merge fields, which Word replaces with real data from your spreadsheet row by row.
  • The merged output creates a separate document for each person on your list, which you can then print, email, or save individually.

Setting up your data source before opening Word

Before you start the merge in Word, prepare your contact information in a spreadsheet. Open Excel or Google Sheets and create a table with column headers in the first row: Name, Address, City, State, Zip, Email, or whatever fields you need. Each row below the headers is one person. Make sure the headers have no extra spaces or special characters — Word uses these exact names to find the data.

Save this file as an Excel workbook (.xlsx) or as a CSV file (.csv). CSV is simpler and works with any spreadsheet program, but Excel files work just as well in Word. Keep this file on your computer in a folder you can find easily — you'll need to point Word to it in a moment.

If your data is currently in a Google Sheet, read it as an Excel file or CSV before starting the merge. Word can technically connect to online sources, but keeping the file local means your contact list never travels to the cloud during the merge process.

Creating your template letter in Word

Open a new Word document and write the letter or document you want to send to everyone. Type the body of the message exactly as you want it to appear. Where you need a person's name, address, or other information to appear, leave a blank space or type a placeholder like [NAME] or [ADDRESS] — you'll replace these with merge fields in the next step.

For example, a straightforward letter might read: "Dear [NAME], Thank you for your business this year. We look forward to working with you again in [YEAR]. Sincerely, Your Company." Save this template document with a clear name like "Renewal Letter Template" in the same folder as your data source file.

Inserting merge fields into your template

With your template open in Word, go to the Mailings tab at the top of the screen. Click Start Mail Merge and choose Letters (or Email Messages if you're sending emails instead of printed letters).

Next, click Select Recipients and choose Use an Existing List. Navigate to your spreadsheet file and open it. Word will show you a preview of the data and ask you to confirm which sheet contains your information — if you have multiple sheets in the workbook, select the right one.

Now go back to your template and click where you want the first piece of data to appear. Click Insert Merge Field (in the Mailings tab) and select the column header that matches what you want there — for example, select "Name" to insert the recipient's name. Word inserts a merge field that looks like <<Name>>. Repeat this for each piece of information you need: address, city, email, or anything else from your spreadsheet.

Previewing and completing the merge

Before you merge, preview how the final documents will look. In the Mailings tab, click Preview Results. Word shows you the first letter with real data filled in from your spreadsheet. Use the arrow buttons to scroll through a few examples and make sure the information is in the right places and formatted correctly.

If something looks wrong — a name in the wrong spot, a field missing — go back and adjust your template. Delete the incorrect merge field and insert the right one. Then preview again.

When everything looks correct, click Finish & Merge in the Mailings tab. You have three options: Edit Individual Documents (creates one Word document with all the merged letters, which you can then edit or print), Print Documents (sends them straight to your printer), or Send Email Messages (if you set up an email merge field and want to send emails instead).

Choosing between printing, saving, and emailing merged documents

If you choose Edit Individual Documents, Word creates a new document containing every merged letter, one after another. You can then print this single file, which prints all the letters at once. This is the simplest route if you're printing to paper.

If you want to save each letter as a separate file instead, you'll need to do that manually after the merge completes — Word doesn't have a built-in option to save each merged letter as its own document. Some users copy and paste each letter into a new file, but that's tedious for large lists. An alternative is to use a third-party tool or macro, though that adds complexity.

For email merges, set up a merge field for the email address column in your spreadsheet. Choose Send Email Messages from the Finish & Merge menu. Word uses your default email client (usually Outlook) to send personalized emails to each address. The email address field must be formatted correctly in your spreadsheet, and your email client must be configured on your computer.

Keeping your contact list private during and after the merge

The key privacy advantage of doing mail merge locally is that your contact list never leaves your computer unless you explicitly send it somewhere. The spreadsheet file stays on your hard drive. Word doesn't upload it to OneDrive, SharePoint, or any Microsoft service during the merge process.

However, if you save the final merged document (the one with all the letters filled in) to OneDrive or email it to someone, that document now contains all your contact information. Be careful about where you save the output. If you only need to print the letters, print directly from Word and then delete the merged document. If you need to keep a copy, save it to a local folder on your computer, not to cloud storage.

Also be aware that if you're using Word Online (the browser version), the merge process may behave differently and may store files in OneDrive by default. If privacy is a concern, use the desktop version of Word instead, which keeps everything local unless you explicitly choose otherwise.

Frequently Asked Questions

Can I do a mail merge with a Google Sheet instead of Excel?

You can, but you'll need to read the Google Sheet as an Excel or CSV file first. Word cannot directly connect to a live Google Sheet. read the file, save it locally, and then point Word to that file during the merge. If you update the Google Sheet later, you'll need to read it again and redo the merge.

What if I want to send emails instead of printing letters?

Create a merge field for the email address column in your spreadsheet, then choose Send Email Messages from the Finish & Merge menu. Word uses your default email client (usually Outlook) to send each email. Your email client must be set up on your computer for this to work.

Can I save each merged letter as a separate file?

Word doesn't have a built-in option for this. The easiest workaround is to merge into one document, then print to PDF or print to paper. If you need separate files, you can manually copy and paste each letter into new documents, but this is slow for large lists. Some advanced users write macros to automate this, but that requires some technical knowledge.

Does Word send my contact list to Microsoft if I do a mail merge?

No, not during the merge itself. Your spreadsheet stays on your computer. However, if you save the final merged document to OneDrive or SharePoint, that document (which contains all your contact information) will be stored on Microsoft's servers. To keep everything private, save the merged output locally or delete it after printing.

What happens if my spreadsheet has blank cells or missing data?

Word inserts a blank space where the data is missing. For example, if someone's middle name is blank, the merge field for middle name just produces nothing. This can look odd in the final letter. Before merging, review your spreadsheet and fill in any critical missing data, or adjust your template to handle blanks gracefully (for example, "Dear <<FirstName>> <<LastName>>" becomes "Dear John Smith" or "Dear Smith" depending on what's filled in).