将EXCEL格信息打印到WORD固定模板.docVIP

将EXCEL格式的《学生信息模板》利用WORD邮件合并的操作步骤 新建一个EXCEL空白文档（编辑菜单中选－〉选择性粘贴，粘贴类型为数值） 粘贴后的样式 粘贴完成后保存一个新的文件名如：book1.xls 步骤二： 在WORD中编辑好固定模板样式，保存好模板，（模板已经上传文名为：学生基本信息表_打印模板.doc） 选项工具菜单中的信函与邮件－〉邮件合并选项 3、类型为信函，点击下一步：正在启动文档 4、设置信函：使用当前文档、下一步：选取收件人 5、选择浏览选项 6、选择保存好的数据源，也就是选择性粘贴后保存的EXCEL表，如BOOK1.XLS 7、选择数据存放的工作区：如sheet1$ 8、此时学生数据已经例出 9、可以根据需要在每个字段进行筛选 10、选择好后点击下一步：撰写信函 11将光标移动到相应的项目中如姓名： 12选择其他项目 13、选择与项目名称所对应的数据库域就可以了 14、全部设置完成后点击下一步：预览信函 预览效果如下： 点收件人可以查看： 数据没有问题可点击下一步：完成合并 点项就可以按模拟打印了 这是打印到虚拟打印机（Microsoft Office Document Image Writer） electricity at no cost, revenue from electricity sales. Poverty alleviation to the removal, to desperate farmers out of poverty, in conjunction with urbanization, new communities are centrally placed. Poverty in the enterprise, enterprise more powerful, more social responsibility, they should allow more people to enjoy the fruits of development. Conditions to encourage private enterprises to establish Charity Fund for poverty alleviation, employment, grants, financial aid and other forms of poverty alleviation activities, let poverty alleviation aid corporate social responsibility in the specific embodiment, the proper meaning of giving back to the community. Finally reveals to implement poverty alleviation policies, older age, incapacity, cannot be achieved through industry support and employment support, such as poverty, children and unable to support the poor, Lo-Fi policy reveals the role to play, eventually incorporated into the low range, and fundamentally solve the problem of poverty. (C) establishing and perfecting retreat mechanism. Poverty alleviation is a dynamic project, we must strengthen the farmers information management, dynamic management of poor, really poor no place to hide, poverty a timely exit, poor