Batch send mail, you will not, colleagues said that using Excel and word can be done in three steps

Hello, everyone. Today, I’d like to share with you how to use Excel and word to send email in batches. We can use this function to send some invitation letters, notices or payslips in batches, which can greatly improve our work efficiency. The operation is very simple. Let’s have an operation < / P > < p > here, we will send workers For example, we need to add each person’s corresponding email to the payroll, as shown in the figure below. Secondly, we need to install outlook software in the computer and log in < / P > < p > here we need to use the mail merge function in word. First, we create a new word and click the email function group to find the option Select the recipient and then select to use the existing list, and a dialog box will pop up. Here, we can find the excel that stores the payroll and import it. Here, we need to check the first row of data to contain the title, and then click OK to < / P > < p > then we will copy the header and a row of data, delete the data under the header, where the width of word is not OK, we can change the format to horizontal. Then we can click the position of department, find the insert merge field in the email, select the Department, and once the class diagram, I can insert the corresponding field according to the header < / P > < p > then we click finish and merge, select Send e-mail, and then we set the recipient as the mail field, and set the subject line Set it as the salary slip of July, and the rest will remain by default. Click send to finish the < A= target=_ blank>Continue Readinggather and watch! Huawei P40 Pro evaluation: excellent mobile phone photography elegant design, do you like it?