✦Template Printable Ideas Insights

Effortlessly Print Excel Addresses on Word Envelopes

By

Printing addresses from an Excel spreadsheet onto envelopes is a task that can save you considerable time and effort, especially when dealing with large mailing lists. Microsoft Word makes this process straightforward with its Mail Merge feature. Here's how you can do it, step by step.

First, you need to have your recipient's addresses in an Excel spreadsheet. Each recipient should have a row, and the address details should be in separate columns: one for the recipient's name, one for the street address, city, state, and zip code. Save this spreadsheet in a location you can easily access.

Preparing Your Excel Spreadsheet

In an ideal scenario, your Excel spreadsheet should look like this:

How to Print Envelopes Using Word From Data in Excel | Techwalla
How to Print Envelopes Using Word From Data in Excel | Techwalla
Print address on A-7 envelope with Microsoft Word 2007
Print address on A-7 envelope with Microsoft Word 2007
How to Create Address Labels in Microsoft Word from an Excel File (PC & Mac)
How to Create Address Labels in Microsoft Word from an Excel File (PC & Mac)

| Recipient Name | Street Address | City | State | Zip Code |

Replace 'Recipient Name', etc., with your actual data. Ensure there are no blank rows in between your data.

an image of a screen shot of the excel spreadsheet
an image of a screen shot of the excel spreadsheet
How to Print an Envelope in Microsoft Word 📩
How to Print an Envelope in Microsoft Word 📩
Microsoft 365 Blog | Latest Product Updates and Insights
Microsoft 365 Blog | Latest Product Updates and Insights

Formatting Your Address Details

For the addresses to print correctly, they need to be formatted as Mail Merge fields in Word. This ensures that the addresses are filled in the correct spots on the envelope.

#1. In Word, click on 'Mailings' in the main ribbon.

#2. Under the 'Start Mail Merge' section, click on the dropdown and select 'Letters'.

How to Print Multiple Envelopes in Microsoft Word from an Excel File
How to Print Multiple Envelopes in Microsoft Word from an Excel File
a woman with glasses and a printer in front of her is the text how to print multiple envelopes in microsoft word from an excel file
a woman with glasses and a printer in front of her is the text how to print multiple envelopes in microsoft word from an excel file
How to mail merge and print labels from Excel to Word
How to mail merge and print labels from Excel to Word
How to Address Letters in Microsoft Word with Mail Merge from an Excel File (PC & Mac)
How to Address Letters in Microsoft Word with Mail Merge from an Excel File (PC & Mac)
Print Envelope Addresses with Microsoft Word Mail Merge
Print Envelope Addresses with Microsoft Word Mail Merge
Printing Envelopes From Excel
Printing Envelopes From Excel

#3. In the 'Select Table' dialog box, locate and select your Excel file, then click 'Open'.

Setting Up Your Envelopes

Before we start the merge, we need to set up our envelopes in Word. This step tells Word where to place the recipient's address.

#4. Click on 'Envelope Options' in the 'Mailings' tab.

a laptop computer with the words how to create address labels with images in microsoft word
a laptop computer with the words how to create address labels with images in microsoft word
How to Create Printable Address Labels with Images in Microsoft Word
How to Create Printable Address Labels with Images in Microsoft Word
How to Print Multiple Copies of an Envelope in Microsoft Word
How to Print Multiple Copies of an Envelope in Microsoft Word

#5. In the 'Envelope Options' dialog box, under 'Printer settings', click on the 'Format' dropdown. Select 'Full rédress' or 'Simple address, 3 lines'. This depends on whether you want the address to appear as one line (e.g., 123 Main Street, Anytown, NY 12345) or three lines (e.g., 123 Main Street / Anytown, NY / 12345).

#6. Under 'Presort', select the appropriate option if your envelopes will be sorted by machine. If you're unsure, just leave it on 'None'.

#7. Click 'OK' to close the dialog box. Your envelope should now be set up correctly.

Performing the Mail Merge

Now that everything is set up, it's time to merge your Excel data with your envelopes.

#8. In the 'Mailings' tab, click on 'Select Recipients' then 'Use an existing list'. In the dialog box that appears, navigate to your Excel file and click 'Open'.

#9. You should now see the first row of your spreadsheet in the 'Mail Merge Recipients' dialog box. Click 'OK'.

Previewing and Printing Your Envelopes

Before printing, it's a good idea to preview your envelopes to ensure the addresses are being inserted correctly.

#10. In the 'Mailings' tab, click on 'Preview Results'. You can use the left and right arrow buttons to navigate through your recipients. If an address isn't being inserted correctly, you may need to adjust your envelope settings or the formatting of your Excel file.

#11. Once you're satisfied with the preview, click 'Finish & Merge'. This brings up the 'Print Documents' dialog box. Ensure the printer set for 'Envelopes' is correct, change the number of copies if needed, then click 'Print'.

Remember to take your envelopes out of the printer as they print to avoid jamming, and to check each one to ensure the addresses are correct. And there you have it - addresses from Excel printed onto envelopes in Word!

Now that you know how to print addresses on envelopes in Word from Excel, you can streamline your mailing tasks, freeing up time to focus on other aspects of your project or business. Happy mailing!