Mail merge uses an Excel spreadsheet as the recipient list and desktop Microsoft Word to create the personalized documents. For letters, prepare the list in Excel, then use Word’s Mailings tab to connect it, insert fields, preview recipients, and finish the merge. The steps below create a combined document for review and printing.
Step-by-Step Tutorial on How to Use Mail Merge in Excel
Use desktop Word for this workflow. Excel supplies the data; you do not start the merge from an Excel ribbon command.
Step 1: Prepare Your Excel Spreadsheet
Ensure that your Excel spreadsheet has all the necessary data for the mail merge, including column headers.
Put unique headers such as FirstName, LastName, Address, City, and PostalCode in row 1 of the first worksheet, with one recipient on each subsequent row. Remove blank rows and totals from the list. Format postal codes as Text before entering or importing them to preserve leading zeros, then save the workbook locally before connecting it to Word.
Step 2: Open Microsoft Word and Start a New Document
Open Word and create a new blank document to serve as your mail merge template.
Type the letter text that every recipient should receive. Leave the names, addresses, and other personalized details for merge fields.
Step 3: Go to the Mailings Tab in Word
Navigate to the "Mailings" tab in the Word ribbon to access the mail merge options.
Select Start Mail Merge > Letters so Word uses the appropriate document type.
Step 4: Select Recipients
Click on "Select Recipients" and choose "Use an Existing List" to import your Excel data.
Choose the saved Excel workbook and select the worksheet containing your list. Confirm that its first row contains column headers. Use Edit Recipient List to check which rows are included and exclude any unwanted recipients.
Step 5: Insert Merge Fields
In your Word document, click on "Insert Merge Field" to add placeholders for the data from your Excel spreadsheet.
Place the cursor where each value belongs, then choose the appropriate field from Mailings > Insert Merge Field. Insert fields using that menu; typing angle brackets around a column name does not create a working merge field.
Step 6: Preview Several Recipients
Select Preview Results and use the next and previous record arrows to inspect several letters. Check long names, missing address details, postal codes beginning with zero, and the spacing around inserted fields. Fix issues before producing the final document.
Step 7: Complete the Merge
Click on "Finish & Merge" in the Mailings tab, then choose "Edit Individual Documents" to generate the final documents.
This will create a new document with each personalized message, ready for review or printing.
Check the combined output before printing, and save both the main merge document and the generated result. This letter workflow does not send emails. Email merging is a separate setup that also requires a compatible email program.
Tips for Using Mail Merge in Excel
- Always double-check your Excel data for any errors before starting the mail merge.
- Use clear and concise column headers to make mapping easier.
- Test your mail merge with a small batch of data to ensure everything is working correctly.
- Save your Word template and Excel file in the same folder to avoid path issues.
- Customize your Word document with formatting to enhance readability.
Frequently Asked Questions
What is Mail Merge used for?
Mail Merge is used to create personalized documents, such as letters or emails, for multiple recipients efficiently.
Can I use other data sources besides Excel?
Yes, you can use various data sources like Access databases or Outlook contacts for mail merge in Word.
Do I need to install any additional software for Mail Merge?
You need desktop Microsoft Word for the merge commands shown here. Excel provides the spreadsheet. Word for the web does not perform this mail merge workflow.
Can I automate Mail Merge?
Yes, you can use VBA scripting in Excel and Word to automate the Mail Merge process further.
What should I do if the data doesn’t merge correctly?
Check the selected worksheet, column headers, and recipient list first. For lost leading zeros, correct the source postal codes as text; changing the format after zeros have already been removed will not restore them. Preview the result again after reconnecting the corrected data.
Microsoft References
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.