Home Topics word Practical Word skills sharing: Use 'Mail Merge' to batch create envelopes

Practical Word skills sharing: Use 'Mail Merge' to batch create envelopes

Sep 05, 2022 am 10:09 AM
word

In the previous article " Sharing of Practical Word Skills: Solving the Background Problem of ID Photos in One Step", we learned how to solve the background problem of ID photos in Word. Today we will talk about Word mail merge examples and introduce batch envelope production methods and cases. Come and take a look!

Practical Word skills sharing: Use 'Mail Merge' to batch create envelopes

In our daily work, we often encounter this situation: producing documents with the same main content but different individual contents. For example, we previously shared articles such as "How to use the mail merge function to batch produce salary slips" and "Use mail merge to batch produce printed meeting cards".

They all have one thing in common, that is, their main content is exactly the same (frame structure), with only slight differences in the names or specific data of the people involved. Therefore, you will find that when producing this type of documents, we use the "mail merge" function of Word to quickly produce them in batches.

In addition to producing salary slips, meeting cards, work certificates and other types of documents, the Word mail merge function also provides a very convenient Chinese envelope production function.

For example, when you need to send letters and make envelopes to multiple customers that the company cooperates with, you can use this function to make standard envelopes very quickly, as shown in the figure.

Practical Word skills sharing: Use Mail Merge to batch create envelopes

Next, I will introduce to you how to make batch envelopes in Word.

(1) Prepare data source. In Excel, sort out the basic information such as the name, contact address, zip code and other information of the recipients who need to make envelopes in batches, as shown in the figure.

Practical Word skills sharing: Use Mail Merge to batch create envelopes

(2) Make Chinese envelopes in batches. Open Word and click the [Mail]-[Create]-[Chinese Envelope] button.

Practical Word skills sharing: Use Mail Merge to batch create envelopes

(3) Open the "Envelope Making Wizard" dialog box and click the "Next" button in sequence.

Practical Word skills sharing: Use Mail Merge to batch create envelopes

(4) In the "Envelope Style" drop-down list box that opens the dialog box, select the appropriate envelope style and whether to check the postcode box, writing line, stamp box, etc. element (can be selected according to the actual envelope condition), continue to click the "Next" button.

Practical Word skills sharing: Use Mail Merge to batch create envelopes

(5) In the dialog box that opens, select the method and quantity to generate envelopes. At this time, we select "Generate batch envelopes based on address book files", and then click "Next" button.

Practical Word skills sharing: Use Mail Merge to batch create envelopes

Tips: Here we need to make a lot of envelopes in batches, so select the "Generate batch envelopes based on address book files" option; if you only need to make 1 envelope, you can choose "Type recipient information to generate a single envelope" option.

(6) Click the "Select Address Book" button in the opened dialog box, select and open the Excel data source we prepared earlier from the file.

Practical Word skills sharing: Use Mail Merge to batch create envelopes

Practical Word skills sharing: Use Mail Merge to batch create envelopes

(7) Then in the "Match Recipient Information" column, specify the fields in the data source to the information corresponding to the recipient bar, click the "Next" button.

Practical Word skills sharing: Use Mail Merge to batch create envelopes

(8) Enter the sender information in the dialog box that opens, and then click the "Next" button.

Practical Word skills sharing: Use Mail Merge to batch create envelopes

(9) Click the [Finish] button.

1Practical Word skills sharing: Use Mail Merge to batch create envelopes

# (10) At this time, Word will automatically generate a new document containing multiple envelopes, as shown in the figure.

Practical Word skills sharing: Use Mail Merge to batch create envelopes

Practical Word skills sharing: Use Mail Merge to batch create envelopes

At this point, you have finished making the envelope. After saving it, you can send or print it. Isn’t it very simple and fast? How to make envelopes in Word, I wonder if you have learned it.

Recommended tutorial: "Word Tutorial"

The above is the detailed content of Practical Word skills sharing: Use 'Mail Merge' to batch create envelopes. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undress AI Tool

Undress AI Tool

Undress images for free

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Detailed explanation of how to display the ruler in Word and how to operate the ruler! Detailed explanation of how to display the ruler in Word and how to operate the ruler! Mar 20, 2024 am 10:46 AM

When we use Word, in order to edit the content more beautifully, we often use rulers. You should know that the rulers in Word include horizontal rulers and vertical rulers, which are used to display and adjust the document's page margins, paragraph indents, tabs, etc. So, how do you display the ruler in Word? Next, I will teach you how to set the ruler display. Students in need should quickly collect it! The steps are as follows: 1. First, we need to bring up the word ruler. The default word document does not display the word ruler. We only need to click the [View] button in word. 2. Then, we find the option of [Ruler] and check it. In this way, we can adjust the word ruler! Yes or no

How to add handwritten signature to word document How to add handwritten signature to word document Mar 20, 2024 pm 08:56 PM

Word documents are widely used due to their powerful functions. Not only can various formats be inserted into Word, such as pictures and tables, etc., but now for the integrity and authenticity of the files, many files require a manual signature at the end of the document. It sounds like this How to solve complex problems? Today I will teach you how to add a handwritten signature to a word document. Use a scanner, camera or mobile phone to scan or photograph the handwritten signature, and then use PS or other image editing software to perform necessary cropping on the image. 2. Select "Insert - Picture - From File" in the Word document where you want to insert the handwritten signature, and select the cropped handwritten signature. 3. Double-click the handwritten signature picture (or right-click the picture and select "Set Picture Format"), and the "Set Picture Format" pops up.

How to draw a table in Word How to draw a table in Word Mar 19, 2024 pm 11:50 PM

Word is a very powerful office software. Compared with WPS, Word has more advantages in detail processing. Especially when the document description is too complex, it is generally more worry-free to use Word. Therefore, when you enter the society, you must learn some tips on using word. Some time ago, my cousin asked me a question like this. I often see other people drawing tables when using Word, and I feel very high-level. I laughed at that time. It seemed like high-level content, but actually it only took 3 steps to operate. Do you know how to draw a table in Word? 1. Open word, select the place where you want to insert the table, and find the "Insert" option in the upper menu bar. 2. Click the "Table" option, and densely packed small cubes will appear.

Where is the shading setting in word? Where is the shading setting in word? Mar 20, 2024 am 08:16 AM

We often use word for office work, but do you know where the shading settings are in word? Today I will share with you the specific operation steps. Come and take a look, friends! 1. First, open the word document, select a paragraph of text paragraph information that needs to be added with shading, then click the [Start] button on the toolbar, find the paragraph area, and click the drop-down button on the right (as shown in the red circle in the figure below) ). 2. After clicking the drop-down box button, in the pop-up menu options, click the [Border and Shading] option (as shown in the red circle in the figure below). 3. In the pop-up [Border and Shading] dialog box, click the [Shading] option (as shown in the red circle in the figure below). 4. In the filled column, select a color

How to underline in Word How to underline in Word Mar 20, 2024 pm 03:16 PM

As a very commonly used word processing software, Word is used in our life, study and work all the time. Of course, if you want to make good use of Word to edit text, you must lay a good foundation. So today I will take you to learn how to underline in Word. You can do it together with the editor. It is very simple. 1. First, we open the file we need to edit. Here we take the following figure as an example. 2. Use the mouse to select the text we need to edit. In the pop-up tab, we select the [U] icon. The operation is as shown in the figure: 3. Let’s take a look at the effect: 4. In fact, we can use a more convenient and faster The method is to use the key combination [ctrl] + [U] on the keyboard to add and follow your text.

What should I do if the word interface becomes smaller? What should I do if the word interface becomes smaller? Mar 20, 2024 pm 09:30 PM

When we use computers to edit word documents, we often don't know where we touched, and the interface suddenly becomes very small. Sometimes the text in the word document cannot be seen clearly. Some people may panic when encountering such a problem, thinking that the computer is malfunctioning. In fact, it is just because you have encountered a certain setting and adjusted the display. So, if you accidentally change the size of the interface display, how should you restore and adjust it? What should I do if the word interface becomes smaller? Below, we will share several ways to solve it. I hope you can easily deal with it when you encounter such a problem. First, we create and open a Word document and perform simple editing operations to show the steps. In the picture below

How to insert automatic numbering or serial numbers into Word tables How to insert automatic numbering or serial numbers into Word tables Mar 20, 2024 am 09:30 AM

When we make tables, the first thing we think of is to use Excel software to make tables. But did you know that Word software is actually very convenient to make tables. Sometimes when we make tables in Word software, we need to enter serial numbers or numbers. , if you enter them one by one manually, it will be very troublesome. In fact, there is an operation in the word software that can automatically insert numbers or serial numbers. So let’s learn with the editor how to insert automatic numbering or serial numbers into Word tables. . 1. First create a Word document and insert a table. 2. Select the column or cell where you want to insert automatic serial numbers or numbers. 3. Click "Start" - "Number". 4. Select one of the style numbers. 5.

How to switch tables horizontally and vertically in word How to switch tables horizontally and vertically in word Mar 20, 2024 am 09:31 AM

Word software is indispensable to us and needs to be used frequently. I have learned how to edit tables using Word software before. However, if I accidentally edit the table in the horizontal and vertical directions, and I don’t want to waste time re-creating it, is it possible to change the horizontal and vertical directions of the table? Woolen cloth? The answer is of course yes. Next, the editor will introduce to you in detail how to swap tables horizontally and vertically in Word. Let us learn together. First, we need to swap the rows and columns of the Word table below. To do this, we need to first select the table entirely, then right-click and select the copy function. Step 2: After selecting copy, we minimize word, then open an Excel table, right-click, select paste, and paste it into Exc

See all articles