How to Print Envelopes Using Word From Data in Excel

rajamohanrajamohan
edited June 2023 in General

Step 1: Create Your Data List

  1. Open Microsoft Excel.
  2. Create a new spreadsheet with the following columns: Employee Id, Name, Present Days, Absent Days, PF , ESI, Total Pay. Adding this information in the corresponding columns. This document will become your master mailing list.
image.png


Step 2: Design Your Envelope:

Next, you need to prepare your envelope template in Microsoft Word. This is the document you will set up to populate with your recipient’s addresses when printing automatically.

image.png

After that click on "Envelopes"

image.png


Now specify what paper size your envelopes are to be. To do so, select the Preview Icon

image.png


In the Envelope Options tab, select the drop-down menu under Envelope size.

image.png

Choose the size your envelopes need to be. Word contains most common envelope sizes, but you can designate your own by clicking Custom Size.

image.png

After the Select the OK Button.

Step 3: Start the Mail Merge and Link Your EXCEL List

  1. In Word, click Mailings > Start Mail Merge > Envelopes.
image.png

Select the Start Mail Merge and click on envelopes.

image.png


Click Mailings > Select Recipients > Use an Existing List. If you’re only printing to a single envelope, select Type a New List. Likewise, if your contacts are already saved in Microsoft EXCEL.

image.png


Select your Microsoft Excel spreadsheet and confirm the choice.

image.png
  1. If any addresses need to be edited, you can select Edit Recipient List to change them.
image.png


Select the Insert Merge Field:

image.png


Step 4: Print the Envelopes

  1. Select then Select Finish & Merge, then Print Documents
image.png


Finally, make sure “All” is checked and select OK.

image.png

This is how we can print the excel data in envelopes.

Sign In or Register to comment.