The preliminary contest is answered online. In the answering system, the question bank is imported through excel template.
The rematch is an off-line competition, so it is necessary to output the excel question bank to word format for simple typesetting.
It is unrealistic to import one by one, and there are 100 questions in one * *.
So, I learned the function of word mailing list.
/post/422 19
Its format is roughly as follows
& lt& lt& gt& gt is equivalent to the variable name.
Serial number, title, options, etc. Is a column in excel, which can be understood as a series of constant variables, but stored in the column.
& lt& lt Next record & gt& gt means i++
This is easy to understand.
The specific operation is as follows:
1. Select recipients and use the existing list.
2. Import an excel file and select a worksheet.
Due to the need of work, my working machine can only use WPS 20 13, and the measured data can not be imported into xlsx, but can be imported into xls.
3. Insert the merge field
In fact, it is to insert variables.
4. Add fixed words and formats
Add some Chinese and punctuation marks, or constrain variables through table frames.