How to Use excel batch print Payslip

Just use the mail merge function. Take office20 10 as an example, the steps are as follows:

1. Start excel and edit the payroll. Examples are as follows:

2. Start word and edit the fixed text of the payroll, as shown in the figure below:

3. Click the Mail tab, click the Start Mail Merge button, and select the letter from the pop-up menu;

4. Click to select recipients and use the existing list;

5. Browse and select the payroll. Before xlsx is established, click Open;

6. When the cursor reaches the employee's name, click Insert Consolidation Field to open a dialog box to select the name, and click Insert;

7. Also insert the job number and salary;

8. Click Finish and merge.