First of all, we need to sort out the data we want to send. Because what we want to send is a salary slip, we need to prepare the salary slip. The salary slip must contain the email address corresponding to each person.
Then you need to log in to your outlook email account. Here we call outlook to send emails.
Then we close this excel, create a new word, then click on the table to insert a table with the same number of columns as the excel salary slip, and enter it into word according to the excel header.
We click on the email to find the selected recipient, then choose to use the existing list, find the salary slip we just sorted, click to open, check the first row of the data to include the title and click OK.
Then we click to insert the merged domain name and insert the corresponding domain name into the corresponding position.
Click to complete the merge and select send email, set the recipient to email, the subject can be sent according to your actual subject, here we write the salary slip, and then click OK, in this case the salary slips will be sent in batches .