A set of data. Through the mail merge function, each line of data will be filled into the specified position of the template document, and finally a document will be generated.

1. Find all the positions of the function first.

First open the template document, and then refer to Mail (a new tab appears) for mail merge.

2. Prepare data for batch generation

2. 1 Prepare the following data in the excel table first.

Name, position and gender

Zhang San, officer person

Lisi Escort Head

Wang Ba escort

Pockmarked robber

3. Insert data to generate documents in batches

3. 1 Mail Merge Open the database and find the excel prepared above (if the xlsx data cannot be opened normally, you can try to change it to xls).

1/4

If the data is loaded successfully, the buttons on the right are available:

3.2 Insert a data placeholder (field)

1. Place the cursor at the specified location (such as name), and then click Insert Merge Field to open the Insert Field window.

2. Switch to the database domain, and you can see the name, professional title and gender (corresponding to the header in the excel table) in the domain list.

3. Select the name field and click Insert.

4. Repeat the first step to complete the work and gender setting.

3.3 Check the effect

1. Click Activate to view the merged data. At this time, we can see that the placeholder inserted before has become real data. 2. You can browse the effect of each piece of data through navigation buttons (such as previous and next).

4. Batch generate documents

1. Click to merge into a new document and select all, that is, the above four pieces of data are all generated in the same new document (multiple pages). Just select a directory and save it.

Refer to other people's documents. If there is any infringement, please contact to delete it.