EXCEL中VBA及WORD邮件合并功能在批量处理报表中的应用  

The Application of VBA and WORD Mail Merging Functions in Batch Report Processing

作　　者：何振娟[1] 王玮[1] 刘海[1] 龚小燕 刘小欣 汪新杰[1] 纵翔宇 HE Zhen-juan;WANG Wei;LIU Hai;GONG Xiao-yan;LIU Xiao-xin;WANG Xin-jie;ZONG Xiang-yu(The Fourth Institute of China Nuclear Power Institute,Chengdu 610041,China)

机构地区：[1]中国核动力研究设计院第四研究所,四川成都610041

出　　处：《电脑知识与技术》2021年第6期212-214,共3页Computer Knowledge and Technology

摘　　要：EXCEL是目前应用最为广泛的办公室表格处理软件之一,它具有强大的数据处理和分析功能。在EXCEL中使用VBA编程进行二次开发,能实现数据处理的自动化。WORD的邮件合并可以实现多条记录在同一格式报表中批量呈现,WORD域的开发与EXCEL的结合,是关系型数据库和数据表的综合应用。本文以职称评审工作中涉及的任职资格评审表为例,展现EXCEL中VBA批量提取数据的强大功能及WORD邮件合并对报表的批量一次性呈现功能,为用户从简单而重复的数据处理工作中解脱出来、提高办公效率及实现办公自动化提供了借鉴思路。EXCEL is one of the most widely used office table processing software.It has powerful data processing and analysis func⁃tions.VBA programming is used for secondary development,which can realize the automation of data processing.WORD mail merging can realize the batch rendering of multiple records in the same format report.The development of WORD domain and the combination of EXCEL are the comprehensive application of relational database and data table.Based on the title appraisal work involved in the qualification of table,for example,show the EXCEL VBA batch extraction to the powerful features of the data and WORD mail merge for reports of batch one-time rendering functions,from simple and repetitive data processing for the user work freed,improve office efficiency and offers a reference way to realize office automation.

关 键 词：EXCEL VBA编程 邮件合并 批量提取 办公自动化 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]