How to Mail Merge from Excel to Word Envelopes (2 Methods)

Get FREE Advanced Excel Exercises with Solutions!

If you want to mail merge from Excel to Word envelopes, this article is for you. Here, we will walk you through 2 easy and suitable methods to do the task effortlessly.


What Is Mail Merge?

For many purposes, we have to send a bunch of mails to people with different addresses. In that case, mail merge acts like a handy feature. Mail merge helps to create a group of envelopes for each address, where every individual envelope carries an address on our mailing list.


The following table has First Name, Last Name, Street Address, City, and Zip Code columns. We will use this table to mail merge from Excel to Word Envelopes. To do the task, we will use 2 different methods. Here, we used Excel 365. You can use any available Excel version.

Mail Merge from Excel to Word Envelopes


1. Using the Envelope Option to Mail Merge from Excel to Word Envelopes

In this method, we will use the Envelope option from the Mailings tab of the Word document to mail merge from Excel to Word Envelope.

Steps:

  • First, we will open our Word document
  • After that, we will go to the Mailings tab >> from Start Mail Merge >> select Envelopes.

Mail Merge from Excel to Word Envelopes

An Envelope Options dialog box will appear.After that, you can change the envelope size by clicking on the drop-down arrow of the Envelope size box.

  • Here, we keep the Envelope size as it is.

Then, we click on the Font of the Delivery address.An Envelope Address dialog box will appear.

  • After that, we select Bold as Font style >> 14 as Font size.

You can select Font color, and Underline style by clicking on the drop-down arrow.

Along with that, you can choose an Effects.

  • Here, we keep the Font color, Underline style, and Effects as it is.

Next, you will see the Preview.

  • After that, click OK.

Mail Merge from Excel to Word Envelopes

  • Afterward, we click on the Font of the Return address.

Next, an Envelope Return Address dialog box will appear.

  • After that, we select Bold as Font style >> 14 as Font size.

You can select Font color, and Underline style by clicking on the drop-down arrow.

Along with that, you can choose an Effects.

  • Here, we keep the Font color, Underline style, and Effects as it is.

Next, you will see the Preview.

  • After that, click OK.

Mail Merge from Excel to Word Envelopes

  • Afterward, we click OK on the Envelope Options dialog box.

Next, you will see an Envelope has been created.

  • Then, we will click on the top left corner to write the Return address.

Later, we will see the Return address.

  • After that, we will click on the Envelope to insert the Delivery address box.

Next, we will see the Delivery address box in the Envelope.

Now, we will select our Excel file for the address recipients list.

  • After that, we will go to the Mailings tab >> from Select Recipients >> select Use an Existing List.

  • Afterward, we will navigate to our Excel file.
  • Then, we will select our Excel file named Mail Merge from Excel to Word Envelopes >> click Open.

A Select Table dialog box will appear.

Make sure the First row of data contains column header is marked.

  • Then, click OK.

Mail Merge from Excel to Word Envelopes

  • After that, we will select the Address Block option from the Write and Insert Fields.

An Insert Address Block dialog box will appear.

Here, we will see the address of the first recipient in the preview box. We can see the other addresses by clicking on the rightward arrow marked with a Red color box.

  • Then, click OK.

Later, you will see the address of the first recipient in the Envelope.

Mail Merge from Excel to Word Envelopes

  • After that, to see the preview of the address from Preview Results >> select Preview Results.
  • You can click on the rightward arrow marked with a Red color box to see the address of other recipients as well.

Therefore, we have created mail merge from Excel to Word Envelopes.

Now, apart from Address Blocks to create mail merge from Excel to Word envelopes, there is an Insert Merge Field option to insert the Delivery address in the Envelope.

  • Here, we have to click on the drop-down arrow of the Insert Merge Field option.

Next, you can see all the recipients address list options in your Excel file in that list.

  • After that, we will select First Name from that list.

You can see the inserted First Name in the DeliveryDeivery address box of the Envelope.

  • In the same way, we inserted Last Name from the Insert Merge Fields list.
  • After that, press ENTER to go to the next line, and in the next line, we will select other options from the Insert Merge Fields list.

Mail Merge from Excel to Word Envelopes

Here, you can see in the Delivery address box of the Envelope, the inserted recipient address.

  • After that, we will click on Preview Results to see the preview.

  • Afterward, you can click on the rightward arrow marked with a Red color box to see the preview of other recipient addresses as well.

Mail Merge from Excel to Word Envelopes

  • Afterward, from Finish & Merge >> select Print Document.

A Merge to Printer dialog box will appear.

Make sure All are selected as Print records.

  • Then, click OK.

Next, a Print dialog box will appear.

  • Afterward, click OK to print mail merge from Excel to Word envelopes.

Mail Merge from Excel to Word Envelopes

Read More: How to Make Address Labels in Word from Excel


2. Using “Step-by-Step Mail Merge Wizard” Option to Mail Merge from Excel to Word Envelopes

In this method, we will use the Step by Step Mail Merger Wizard from the Mailings tab of the Word document to mail merge from Excel to Word Envelopes.

Steps:

  • First, we will open our Word document
  • After that, we will go to the Mailings tab >> from Start Mail Merge >> select Step by Step Mail Merge Wizard.

Next, we will see a Mail Merge dialog box at the right corner of the Word document.

  • After that, select document type as Envelope >> from Step 1 of 6 and click on Next: Starting document.

Mail Merge from Excel to Word Envelopes

  • Afterward, select Envelope options from the Change Document layout.

  • An Envelope Options dialog box will appear.Mail Merge from Excel to Word EnvelopesAfter that, you can change the envelope size by clicking on the drop-down arrow of the Envelope size box.
  • Here, we keep the Envelope size as it is.

Then, we click on the Font of the Delivery address. An Envelope Address dialog box will appear.

  • After that, we select Bold as Font style >> 14 as Font size.

You can select Font color, and Underline style by clicking on the drop-down arrow.

Along with that, you can choose an Effects.

  • Here, we keep the Font color, Underline style, and Effects as it is.

Next, you will see the Preview.

  • After that, click OK.

Mail Merge from Excel to Word Envelopes

  • Then, we click on the Font of the Return address.

An Envelope Return Address dialog box will appear.

  • After that, we select Bold as Font style >> 14 as Font size.

You can select Font color, and Underline style by clicking on the drop-down arrow.

Along with that, you can choose an Effects.

  • Here, we keep the Font color, Underline style, and Effects as it is.

Next, you will see the Preview.

  • After that, click OK.

  • After that, in the Envelope Options dialog box, click OK.

Mail Merge from Excel to Word Envelopes

Next, you can see an Envelope has been created.

  • After that, from Step 2 of 6 click on Next: Select recipients.

  • Afterward, click on Browse to select our Excel file as recipient address list.

Mail Merge from Excel to Word Envelopes

  • Afterward, we will navigate to our Excel file.
  • Then, we will select our Excel file named Mail Merge from Excel to Word Envelopes >> click Open.

A Select Table dialog box will appear.

Make sure the First row of data contains column header is marked.

  • Then, click OK.

Next, a Mail Merge Recipients dialog box will appear.

You can unmark a Data Source from this dialog box, and along with that, you can Refine recipient list.

  • Here, we keep the recipient list as it is.
  • Then, click OK.
  • Mail Merge from Excel to Word EnvelopesAfter that, we type the Return address in the top left corner of the Envelope.
  • Then, we click on the Envelope to insert the Delivery address box.

Later, you can see the Delivery address box.

Mail Merge from Excel to Word Envelopes

  • After that, from Step 3 of 6 we will click on Next: Arrange your envelope.

  • Afterward, we will select the Address Block.

An Insert Address Block dialog box will appear.

Here, we will see the address of the first recipient in the preview box. We can see the other addresses by clicking on the rightward arrow marked with a Red color box.

  • Then, click OK.

Mail Merge from Excel to Word Envelopes

Here, you can insert the address to create mail merge from Excel to Word envelopes, by clicking on More Items as well.

If you click on More items, you will see the Insert Merge Fields list.

You can insert the address manually from this list.

  • Here, we inserted the address from the Address Block option.
  • After that, from Step 4 of 6, we selected Next: Preview your envelopes.

Mail Merge from Excel to Word Envelopes

Now, you can see the Preview of the address of the first recipient.

  • You can click on the rightward arrow marked with Red color box to see the preview of the other recipients’ addresses as well.

  • Afterward, from Step 5 of 6, we click on Next: Complete the merge.

  • After that, select Print from the Merge box.

Mail Merge from Excel to Word Envelopes

A Merge to Printer dialog box will appear.

Make sure All are selected as Print records.

Then, click OK. Next, a Print dialog box will appear.

  • Afterward, click OK to print mail merge from Excel to Word envelopes.

Read More: [Solved]: Word Mail Merge Not Working with Excel


Things to Remember

  • You can use either Address Block or Insert Merge Field to insert the recipient address in the Envelope.
  •  The Step by Step Mail Merge Wizard option is helpful when you want to unmark some Source data.

Practice Section

In the practice section of your sheet, you can practice the explained methods.

Mail Merge from Excel to Word Envelopes


Download Practice Workbook


Download Word Document


Conclusion

Here, we tried to show you 2 methods to mail merge from Excel to Word envelopes. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section below.


Related Articles

<< Go Back To Mail Merge Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo