How to Mail Merge from Excel to Word: Step-by-Step Guide

Mail merge is a lifesaver when it comes to personalizing letters, labels, or emails without the hassle of doing it all manually. Whether you're making holiday mailing labels or sending out business emails in bulk, this tool makes the process faster and easier.

Here’s a straightforward guide to help you get started:

Step 1: Get Your Excel Data Ready

Your Excel spreadsheet is the backbone of your mail merge. Before starting, confirm that each column represents a piece of info—like “First Name” or “Email”—and each row should be a recipient. Think of this as the foundation for your mail merge—it’s where Word will pull all the personalized information to build your file.

• Create Your Data: Start with a fresh spreadsheet or an existing one. Make sure everything is complete and the column headers are clear (e.g., use “City” instead of “Place”).

• Double-Check Everything: Look out for typos or blank fields and clean them up.
• Save Your Spreadsheet: Save your file in a format that Word supports, like .xlsx or .xls.

Step 2: Start the Mail Merge in Microsoft Word

Now that your Excel file is ready to go, let’s move over to Word to set up the mail merge.

• Start The Mail Merge: Navigate to the "Mailings" tab. Then click "Start Mail Merge" and choose what you're creating (i.e., letters, labels, or envelopes).

• Choose Your Settings: For some projects, you will be prompted to provide your printer information and choose the paper size for your project. If you're not given this option, no worries. You can proceed to the next step.

• Link Your Excel File: In the top navigation bar, still under the "Mailings" tab, click Select Recipients > Use an Existing List. Find your Excel file and open it. Make sure the box for “First Row Contains Column Headers” is checked.

Step 3: Add Merge Fields

This is the magic step where Word pulls personalized data from your Excel file and places it into the document.

• Insert a Field: Navigate to the spot where you want to insert your first merged data field. Then click Insert Merge Field under the Mailings tab and choose the column name you want to add, like "First Name" or "Address." 

• Fill in All Field Locations: Repeat this process for all necessary fields until you have them in the correct position within the document, and be sure to add spaces or commas where necessary. Note: If you're printing sheet labels, you only need to add the necessary fields in the first label of the template. The other labels should say <<Next Record>>, which indicates that these areas will fill in later.

• Update Labels: If you're creating label sheets, you will need to select "Update Labels" in the top navigation bar. This will fill in the other labels with the information from your spread sheet. 

Step 4: Preview and Finalize

Now it’s time to check how everything looks before you send or print.

• Preview Your Results: Click Preview Results to see real data in place of merge fields. Use the arrows to scroll through different records and check for errors.

• Finish the Merge: Once everything looks good, hit Finish & Merge. From there, you can:
  • Edit individual documents.
  • Print them directly.
  • Send emails if that's your goal.

Troubleshooting & Tips

• Prepping Your Data: Always clean up your Excel file before starting to avoid headaches later.
• ZIP Codes and Numbers: Format them as text in Excel to prevent weird formatting.
• Run a Test: Always test on a small batch before printing or emailing hundreds of documents.

How Do I Print My Mail Merged File on Labels?

Printing your mail-merged file is pretty simple once everything is set up. Load your blank label sheets into your printer, making sure the labels match the template you used in Word. Check your printer settings—select "labels" or "heavyweight paper" for the best results—and preview everything before hitting print. With the right setup, you'll have perfectly aligned labels ready to go!

Looking for high-quality label sheets for printers? Shop our printable label sheets for low pricing, premium quality, and fast, free shipping to keep your projects running smoothly!

FAQs