Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/you-jian-he-bing-ji-qiao-gao-xiao-pi-liang-sheng-cheng-gong-zi-tiao-zhi-nan.html
Mail Merge Tips: A Guide to Efficiently Generating Salary Slips in Batch
When a large number of pay slips need to be produced every month, it is easy to make mistakes in a single production due to too much data. Using the mail merge function of WPS documents can quickly complete this work. Here are the steps: First, prepare a data source table for salary content, as shown in the video. Next, prepare the salary slip template in the WPS document. Step 1: Click the "Mail" button under the "Reference" tab, choose to open the data source, and import the prepared salary slip data source table. Please note that the table with the suffix XLS format must be imported, otherwise an error message box will appear. Step 2: "Insert merge field" in the text box corresponding to each name and select the corresponding field name. Step 3: Add "Insert NEXT field" below the table. When inserting the NEXT field, make sure that View Merged Data is turned off, otherwise you will not be able to see the NEXT field code. Then, copy and paste the text above until it fills the entire page. Step 4: Select "Merge into new document" to view everyone's salary slips. The following is the relevant HTML and image address information: ```html
Like (810)
Reward
支付宝扫一扫
评论列表(196条)
测试