Send a final grade notice to each student's parents. What are the orders?

Step 1: Enter the personnel list information in the Excel table, and then save and close the Excel file.

Step 2: Open the prepared Word invitation template.

Step 3: Click the "Select Recipients" drop-down button in the "Start Mail Merge" function group of the Mail tab, select "Use Existing List" from the drop-down list, and the "Select Data Source" dialog box pops up, then select the Excel worksheet of the "People List" just now and click "Open".

Step 4: Position the cursor at the position where information needs to be inserted in the Word document, click the drop-down button of Insert Merge Field in the writing and inserting field function group of the mail tab, and select the corresponding information from the drop-down list. In this case, select the name, click the Insert button, and then close the Insert Merge Field dialog box. At this point, the inserted field marker will appear in the corresponding position in the document.

Step 5: On the Mail tab, in the Write and Insert Fields group, click the "If … Otherwise …" command in the Rule drop-down list to open the Insert Fields dialog box.

Select gender in the domain name drop-down list box, select equal in the comparison condition drop-down list box, enter male in the comparison object text box, enter Mr in the insert text box, otherwise enter Ms in the insert text box, and then click OK.

Step 6: Click the "Finish and Merge" drop-down button in the "Finish" function group of the Mail "tab, and click" Edit Single Document …… "in the drop-down list to open the" Merge to New Document "dialog box. Select "All" and click "OK". At this point, a new document named "Letter 1.docx" will be merged into a new window, and "Letter 1" contains the invitation information of all the people.