The problem of email merging between excel and word.

Firstly, it is divided into two parts: 1 is the data source of excel equivalent to merged mail, and the processed information details need to be classified and maintained in the table; 2.word prints or produces mail merge results after merging, so the items to be merged should be reflected in the corresponding position in word first, and the format should be adjusted.

2. The mail merge process (taking a simple work permit as an example) is roughly divided into four steps: starting mail merge, selecting recipients, inserting merge fields, and completing merge.

1. Start mail merge: Select mail at the top of the toolbar →→→ Start mail merge → Email.

2. Select a recipient: click Select a recipient → Use an existing list → Find the file and select it → Open it → Select a worksheet.

3. Insert the consolidated field: in word, the mouse stays at the position where the table data needs to be referenced → Insert the consolidated field → select "Work Number" (the same as other project processes);

The effect of all references to the maintenance number is:

4. Complete the merger:

After the merger is completed, you can apply. Here, you can choose to edit and modify a single file, batch print and send mail;

You can preview the results before you finish, or click the left and right buttons on both sides of the page number to confirm the single page.

End.