Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to create and print envelopes from the mailing list in Word?

If you have a client or customerlist, and you need to send an update leaflet to all the clients in the list, in many cases you have to write each customer's name and address on the envelopes for the sending. But if there are numerous customer information existing in the list, the writing work will be a huge project. Now, I introduce a trick for you to create and print envelopes from the list in Word.

Create and print envelopes from mailing list in Word

Step 1: Set envelopes style

Step 2: Import the list to Word

Step 3: Add information to the envelope

Step 4: Print the envelopes


arrow blue right bubbleCreate and print envelopes from mailing list in Word

Hot
Amazing! Use Efficient Tabs in Word (Office) like Chrome, Firefox and New Internet Explorer!

Read more Free download

Step 1: Set envelopes style

Firstly, you need to set the envelopes style.

1. Open a Word document and click Mailings > Envelopes. See screenshot:

2. Type the delivery address In the Delivery address box, and in the Return address box, type your return address. Then click Options button. See screenshot:

3. In the Envelope Options dialog, click Envelope Options tab to specify the envelope size, delivery address and return address. See screenshot:

4. Then click Printing Options tab to choose a way that the envelope will be loaded into the printer. See screenshot:

5. Click OK. And Click Print to print the envelope.

6. Then Word prompts a dialog for you to save the return address, click Yes. See screenshot:

7. Check if the envelope printed correctly.

If the envelope didn’t print correctly, try adjusting the Feed method options in step 4.


Step 2: Import the list to Word

Now, we need to import the customer list into Word document.

1. Click Mailings > Start Mail Merge > Envelopes.

2. In the Envelope Options dialog, click OK. Then the document is changed to an envelope with the default return address showing at the top left corner. See screenshot:

3. Click Mailings > Select Recipients > Use an Existing List. See screenshot:

4. A Select Data Source dialog is displayed for you to select the file which include the list you want to import, then click Open. Here I select an Excel workbook, after clicking Open button, a Select Table dialog pops up for selecting the sheet which the list existing in. See screenshot:

5. Click OK to close the dialog, and click Mailings > Edit Recipients List, you can see the customers list has been added. See screenshot:

6. Check the person you want to send the letter to in the pop-up dialog. Then click OK.


Step 3: Add information to the envelope

In this part, you need to specify the information appeared on the envelope.

1. Put the cursor on the middle of the envelope (which is a text box displayed), and then specify a position you want to insert the address. See screenshot:

2. Click Mailings > Address Block to show the Insert Address Block dialog. See screenshot:

3. In this dialog, select the recipient name format you want to insert under Insert recipient’s name in this format section, and you can preview the result in the Preview section after select a name format. See screenshot:

Tip: If you want to know whether the fields in your recipient list match to the required fields or not, please click Match Fields. In the Match Fields dialog, you can decide which fields can appear on the envelope. If you do not want the field showed, click (not matched) in the drop-down list. See screenshot:

4. Click OK, you can see the address block has been inserted into the envelope. See screenshot:


Step 4: Print the envelopes

Start to print the envelopes.

1. Click Mailings > Preview Results, and then click and buttons to preview and make sure the names and addresses on the envelopes are correct. See screenshots:

2. Click Finish & Merge > Print Documents. See screenshot:

3. Then the Merge to Printer dialog is displayed, please select a print records to meet your need and finally click OK. See screenshot:

The envelopes are printed.

Recommended Productivity Tools

shot kutools word kutools tab 1180x121
shot kutools word kutools plus tab 1180x120
 

Kutools For Word - More Than 100 Advanced Features For Microsoft Word, Save Your 60% Time

  • Complicated and repeated operations can be done a one-time processing in seconds.
  • Insert multiple images across folders into Word document at once.
  • Merge and combine multiple Word files across folders in to one with your desired order.
  • Split the current document into separate documents according to heading 1, section break or other criteria.
  • Convert files between Doc and Docx, Docx and PDF, collection of tools for common conversions and selection, and so on...
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.