How to send monthly salary slips to everyone in groups?

With the popularization of paperless office, in daily work, as the boss of an enterprise, do you still use the paper-based payroll every time you pay your salary? Are you still sending out payrolls one by one by email?

It's troublesome for you to come out and make mistakes easily! Next, let me teach you a simple and quick way to fix it!

The complete payroll data is as follows:

First of all, we do a good job in word with the title table data consistent with the payroll as follows:

Next, under the Mail tab, click Use an existing list under the Select Recipients option.

Then select the completed payroll in the pop-up window of selecting data source, and import the payroll. The demonstration is as follows:

Then insert the table data in turn. First, under the Mail tab, click Insert Merge Area to insert the corresponding data into the table.

Next, there is only one last step left. Come on, you will succeed! ! !

We click Finish and Merge under the Mail tab, and then click Send Email. Then in the merged email window that pops up, select the email box in the recipient drop-down box, and the subject line is called payslip, then check the current record and click OK. In this way, the payroll is completed in groups!

After the Excel payroll is made, the format of the payroll is also a problem that puzzles many HR. If the traditional paper payroll is issued once a month, it will be a very heavy workload for large enterprises with many people. It is recommended to send salary slips in groups.