邮件合并和if函数在高校成绩报告书中的应用

Application of mail merge and if function in higher schools in the report of the book

在实际工作中,高职学校的班主任经常会遇到批量制作成绩报告书、准考证、请柬等情况;这些工作都具有工作量大、重复率高的特点,既枯燥乏味又容易出错,有什么办法可以解决?结合使用Microsoft office Excel 2010中的if函数和Word 2010中的"邮件合并"功能,可以轻松解决上述问题。使用if函数,可以对数据源进行相应的编辑;使用"邮件合并"功能,可以对大部分固定不变的word文档内容进行批量编辑、打印。本文以打印并且邮寄学生成绩报告书为例,详细叙述邮件合并在管理、教学等方面的应用。

In practical work, vocational school teachers often meet mass production results report, certificate, invitation etc; these will have a heavy workload, high repetition rate features, is tedious and error prone, what method can be solved？ Combined with the use of Microsoft office Excel 2010 if function and Word 2010 in the ＂mail merge＂ function, can easily solve the problem. Use the if function, can make the appropriate edit data source; the use of＂mail merge＂ function, can on the contents of most fixed word document for bulk editing, printing. This paper to print and mail student achievement report as an example, describes the application of mail merge in management, teaching and other aspects of the.