✦Template Printable Ideas Insights

How to Print Envelopes from an Excel List

By

Ever found yourself with a list of addresses in an Excel sheet, needing to print them on envelopes? You're not alone. This common scenario can be efficiently managed using Microsoft Word's Mail Merge feature along with Excel. Let's guide you through this process, step by step.

Before we dive in, ensure you have both Microsoft Excel and Word installed on your computer. The process involves exporting your Excel list to Word, so let's begin there.

Preparing Your Excel List

First, make sure your addresses are in a single column and start with Column A, as we'll refer to these columns while setting up the Mail Merge.

How to Print Envelopes Using Word From Data in Excel | Techwalla
How to Print Envelopes Using Word From Data in Excel | Techwalla
Microsoft 365 Blog | Latest Product Updates and Insights
Microsoft 365 Blog | Latest Product Updates and Insights
Creating Labels from a list in Excel
Creating Labels from a list in Excel

Additionally, format your addresses in the standard order: Recipient's Name, Street, City, State, Zip Code. This format ensures your envelopes are filled correctly.

Splitting a Multi-line Address into One Column

If your addresses span multiple lines (e.g., street and city on separate lines), you can consolidate them into a single column for easier Mail Merge.

40+ FREE Envelope Templates (Word + PDF) ᐅ TemplateLab
40+ FREE Envelope Templates (Word + PDF) ᐅ TemplateLab
How to mail merge and print labels from Excel to Word
How to mail merge and print labels from Excel to Word
Word help & learning
Word help & learning

Here's how: Select all the cells containing addresses, then go to the 'Conditional Formatting' tab in the 'Home' menu. Under 'Top/Bottom Rules', select ' Format only cells that contain'. In the dialog box, pick 'Text that Contains' and enter a space (" "). Click 'Format' and under 'Number', change the category to 'Text'. Click 'OK' to split addresses and combine them into one column.

Making Your Addresses Uniquely Identifiable

To ensure each address is individually targeted during the Mail Merge, you need a unique identifier. This could be a column with ID numbers or any unique data point like a recipient's name.

If you don't have one, insert a new column (e.g., Column B) and fill it with numbers or names that correspond uniquely to each address.

two screenshots of the same window in windows xp and vista, each with different options
two screenshots of the same window in windows xp and vista, each with different options
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
How to Organize Wedding Guest List in Excel — Betty Lu Paperie
How to Organize Wedding Guest List in Excel — Betty Lu Paperie
Print Envelope Addresses with Microsoft Word Mail Merge
Print Envelope Addresses with Microsoft Word Mail Merge
Mail Merge Address Template for Envelopes, Microsoft Word Excel Printable Minimalist Retro Modern Instant Download File A7 Wedding Christmas
Mail Merge Address Template for Envelopes, Microsoft Word Excel Printable Minimalist Retro Modern Instant Download File A7 Wedding Christmas
[FREE] 141 Free Excel Templates and Spreadsheets
[FREE] 141 Free Excel Templates and Spreadsheets

Setting Up the Mail Merge in Word

Now that your Excel list is ready, it's time to set up the Mail Merge in Word. Launch Microsoft Word and choose 'Mailings' > 'Start Mail Merge'. Select 'Envelope' as your document type.

Inserting the Address Data

In the 'Envelope Options' dialog box, select 'Recipient's address' under 'From'. Click 'OK' to apply the changes. Now, it's time to insert your address data.

Go to 'Insert Merge Field' again and choose the column containing your addresses. Click 'OK'. Your addresses should now appear on the envelopes during the Mail Merge preview.

Adding a Return Address

To add a return address, place your cursor in the 'Sender's address' field in the document. Then, type or paste your return address manually. This address will appear on all envelopes in the Mail Merge.

Finally, preview your Mail Merge by clicking 'Preview Results and Print'. Check for any mistakes, and once satisfied, click 'Print' to print your envelopes.

And there you have it! Your mailing labels or envelopes are now ready to go out. Using this method ensures you can print envelopes for large lists efficiently and accurately. Happy printing!

an excel file with the words do a word mail merge with an excel file on it
an excel file with the words do a word mail merge with an excel file on it
Use Mail Merge to Create Mailing Labels in Word from an Excel Data Set
Use Mail Merge to Create Mailing Labels in Word from an Excel Data Set
141 Free Excel Templates And Spreadsheets
141 Free Excel Templates And Spreadsheets