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 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.
- Related articles
- Tangshan Limited Number Inquiry 20 19 Today Tangshan Limited Number Area Scope and Time 20 19
- Understanding customer behavior: how do people buy?
- Why is there always a WeChat payment verification code sent on the mobile phone? Is it poisonous?
- What are the teacher's day greeting copybooks?
- How to check the balance of the savings card of Shanghai Pudong Development Bank by SMS?
- I was a little confused about the movie Air Rescue, so I asked someone for advice.
- How to turn off the screen capture sound of iphone 13?
- A short message with a deduction of 1000 yuan.
- Asking for the predecessor 3: Goodbye to the hottest resource of the predecessor poster, HD is free, thank you! !
- Imported wood (expanding domestic building materials market)