✦Template Printable Ideas Insights

How to Print Envelopes from Excel with Mail Merge

By

Ever found yourself in a situation where you need to send out numerous identical letters, each addressed to a different recipient? Mail merge is a feature that streamlines this process, allowing you to create personalized letters, labels, or envelopes in bulk. Today, we're going to guide you through how to print envelopes from Excel using mail merge, a task that might initially seem daunting but is actually quite straightforward once you know how.

Before diving into the process, ensure you have the necessary tools: Microsoft Excel and Microsoft Word installed on your computer. Excel will organize your recipient data, while Word will act as the layout designer for your envelopes. Let's get started!

Preparing Your Data in Excel

First, you'll need to set up your recipient data in Excel. Each recipient should have their own row, with different fields like name, address, and postal code in separate columns. It's crucial to have headers for each column to identify the data fields later in Word.

Microsoft 365 Blog | Latest Product Updates and Insights
Microsoft 365 Blog | Latest Product Updates and Insights
Mail Merge Envelopes in Microsoft Word
Mail Merge Envelopes in Microsoft Word
How to mail merge print envelopes using MS Excel and Word
How to mail merge print envelopes using MS Excel and Word

For instance, your spreadsheet might look like this:

Name Address City Postal Code
John Doe 123 Main St Anytown 12345
Jane Smith 456 Oak St Cityville 67890

Microsoft 365 Blog | Latest Product Updates and Insights
Microsoft 365 Blog | Latest Product Updates and Insights
Mail Merge Envelopes with Microsoft Word by Chris Menard
Mail Merge Envelopes with Microsoft Word by Chris Menard
How to Mail Merge a Document in Word from Excel [Easy Steps] | IT4nextgen
How to Mail Merge a Document in Word from Excel [Easy Steps] | IT4nextgen

Named Ranges in Excel

Named ranges in Excel help you locate and reference data more efficiently. To create a named range for your recipient data, highlight the data then click on 'Formulas' in the ribbon, and select 'Name Manager'. In the pop-up window, name your range (e.g., 'Recipients'), and click OK.

Once your data is prepared and named, it's time to move to Word to start designing your envelopes.

Designing Your Envelopes in Word

Open Word and create a new document. Start with a blank page, and insert an envelope template from the text box on the 'Mailings' tab. You can choose between standard, gripped, and mini envelopes, among other formats, depending on your printing capabilities.

Print Envelope Addresses with Microsoft Word Mail Merge
Print Envelope Addresses with Microsoft Word Mail Merge
TikTok · April
TikTok · April
a close up of a business card on top of a computer keyboard with a mouse
a close up of a business card on top of a computer keyboard with a mouse
Use mail merge to personalize letters
Use mail merge to personalize letters
How to do a mail merge using Microsoft Word and Excel to quickly create personalized templates for imported data
How to do a mail merge using Microsoft Word and Excel to quickly create personalized templates for imported data
How to Print Labels with Mail Merge in Microsoft Word and Excel
How to Print Labels with Mail Merge in Microsoft Word and Excel

With the envelope template inserted, select 'E envelope' from the 'Envelope Options' box. Back in your document, you'll see a preview of your envelope. Now, let's insert your recipient data.

Mail Merging Your Envelopes

Click on the 'Mailings' tab, and select 'Select Recipients'. Choose 'Use an Existing List'. Browse to your Excel file, and click 'Open'. Word will automatically recognize the named range 'Recipients' and import your data.

Now, you need to match the data in your Word envelope template with the data in your Excel spreadsheet. Select the 'Merge' field button (it looks like a Greek sigma ∑) in the 'Mailings' tab, and click 'More Items'. In the 'Insert Merge Field' box, select the fields you want to include, and click 'Insert'. Do this for each data field in your envelope (Name, Address, City, etc.).

a computer screen with an open file on the left and a web page on the right
a computer screen with an open file on the left and a web page on the right
Use Mail Merge to Create ENVELOPES in Microsoft Word Using List From Microsoft Excel
Use Mail Merge to Create ENVELOPES in Microsoft Word Using List From Microsoft Excel
Mail Merge Address Template for Envelopes, Microsoft Word Excel, Printable Minimalist Instant Download Digital File A7, Wedding Christmas
Mail Merge Address Template for Envelopes, Microsoft Word Excel, Printable Minimalist Instant Download Digital File A7, Wedding Christmas

Sorting and Previewing Your Mail Merge

Before printing, ensure your merged data is sorted and previewed. In the 'Mailings' tab, click 'Edit Recipient List'. In the pop-up window, choose 'Sort Ascending' or 'Sort Descending'. Once sorted, click 'Preview Results' to visualize how your envelopes will look. If everything is in order, it's time to print!

Click 'Finish and Merge' in the 'Mailings' tab. Choose 'Print Documents' and select either 'Print All Records' or 'Print Current Item' depending on whether you want to print all envelopes at once or just the previewed one.

Updating Your Envelope Database

After printing, you can close the mail merge and return to your Excel file. To add or remove recipients for future mail merges, simply update your data and repeat the process.

Printing envelopes from Excel using mail merge saves you time and does away with repetitive tasks. By following this straightforward process, you can streamline your mailing operations, whether it's for business letters, invoices, or personal invitations. Happy mailing!