Joke Collection Website - Public benefit messages - How to send a batch salary email? How to operate?

How to send a batch salary email? How to operate?

First, the preliminary preparation

First of all, we need to sort out the data to be sent. Because we want to send a payroll, we need to make a payroll. The payroll must contain everyone's corresponding email address, as shown below. Then we need to log in to outlook email account, where we call outlook to send an email.

Second, mail merge.

Then we close this excel, create a new word, and then click the table to insert a table with the same number of columns as excel payroll, and input it into word according to the header of excel.

Then we click on the email to find the selected recipient, then choose to use the existing list to find the payroll we just sorted out, click Open, check the header in the first row of data, and click OK.

Then we click Insert Merge Domain Name to insert the corresponding domain name into the corresponding location.

Then click Finish Merge, select Send Email, and set the recipient as email. The theme can be sent according to your actual theme. Here we write the payslip, and then click OK, so the payslip can be sent in batches.