How to Do a Mail Merge in Word
No time for long YouTube tutorials? Try Guidy and get it all done in 2 minutes. It sits right on your screen and points you to exactly what to do in real time. And it works on any software or browser, in any language.
Try for free
Sending the same letter, label, or invoice to 50 people shouldn't mean writing 50 documents. A mail merge handles it in minutes. Here's how to do a mail merge in Word step by step, including how to pull your list straight from Excel.
No time for reading a blog tutorial? Guidy is an AI assistant for work that sees your screen and walks you through this in real time in less than one minute, in any language. Try now.
How to do a mail merge in Word
A mail merge in Word needs three things: a main document (your template), a data source (your recipients), and merge fields (placeholders that get replaced). Start with a new Word doc, then go to:
Mailings → Start Mail Merge → Step-by-Step Mail Merge Wizard
The wizard walks you through six steps: pick the document type (letters, labels, envelopes, emails), use the current document, select your recipients, write the letter with merge fields, preview, and finish. That's how to do a mail merge in Word from start to finish.
How to mail merge from Excel to Word
The most common setup is mail merge Excel to Word. Your Excel sheet holds the contact data, and mail merge Word pulls it in row by row. Here's how to mail merge from Excel to Word.
Save your Excel file with one row per recipient and column headers in row 1 (e.g., First Name, Address, Order Total). In Word, go to:
Mailings → Select Recipients → Use an Existing List → (choose your Excel file)
Word reads the column headers as merge fields. Drop them into your letter (Dear «First Name», your balance is «Order Total»). Hit Preview Results to check the mail merge from Excel maps correctly before you click Finish & Merge.
How to mail merge labels from Excel
Printing address labels for an event or campaign? Mail merge from Excel to Word labels in five clicks. Open a new Word document and go to:
Mailings → Start Mail Merge → Labels → (pick label vendor and product number)
Click Select Recipients and point Word at your Excel file. Insert the merge fields (Name, Street, City, ZIP), and Word fills every label on the sheet. That's how to mail merge labels from Excel without retyping a single address. The same mail merge from Excel to Word labels process works for shipping labels, name tags, and seating cards.
Cool fact: Skipping tutorials is now possible! Get real-time help, right on your PC - in any language, for all software and browsers. Download Guidy now.
Common Microsoft Word mail merge issues
If merge fields show up blank or as weird codes, check that the Microsoft Word mail merge is linked to a saved .xlsx file (close Excel before linking). If numbers come through as 1234.5 instead of $1,234.50, use the Format Field option in Word to fix the display. How to mail merge without these surprises usually comes down to clean source data.
Important: Never edit the Excel source file while the Word merge is open. Microsoft Word loses the link and you have to re-import.
Key takeaways
To do a mail merge in Word, head to Mailings → Start Mail Merge and follow the wizard. To mail merge from Excel to Word, save your list, link it in the Mailings tab, and drop in merge fields. The same Microsoft Word mail merge process works for letters, emails, and mail merge labels from Excel.
If you want to skip learning all this, try Guidy. It lives right on your desktop and walks you through it inside Word like a good colleague of yours would.
