1、首先准备好工资表,
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/cdbf6c81800a19d8440017df3dfa828ba71e46ed?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、然后打开Word建产一个工资条表格,
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f636afc379310a55f4ab4e2eb94543a983261058?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、然后点菜单栏的工具 -信函与邮件-邮件合并,选信函,下一步,使用当前文档 下一步,使用现有列表 点浏览选择Excel工资表,
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9f510fb30f2442a7ed006e7fdf43ad4bd01302d9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、选择有数据的表,确定,
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e7cd7b899e510fb33d87e44dd733c895d0430c49?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、然后在工具栏会出现邮件合并工具栏,点插入合并区域,
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d52a2834349b033bfa826f001bce36d3d439bde6?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、把对应的域名点到对应工资条对应的项目里,在工具栏点插入word域 选择下一记录,放到工资条表最下面,
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7af40ad162d9f2d325bab735a7ec8a136227cc45?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、然后再把工资条表格复制到下面,
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d1160924ab18972bf8b59310e8cd7b899f510a58?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
8、这样就基本做好了,下面就开始合并数据了,在工具栏点开合并到新文件,
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/cf1b9d16fdfaaf512f451265825494eef11f7a42?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
9、选择全部确定,
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/48540923dd54564e7d8e77e3bdde9c82d0584f05?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
10、完成效果图。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/30adcbef76094b366c998937adcc7cd98c109de5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)