Word批量制作工资条原来这么简单，不会Excel函数的人受益了！
<img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/WB8piaYYKYfliavNAh83od6K4eOqLbs4tS87mV5Q3LiasZ0GC2e18kK9j1tJUAgDj4QdZb4bGDsAAtZxM8wXNU8pg/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMxZAP902kqL7wRke0cKLHSLvWnPKAIwSu2dh8u4EntIc9l0gdnXyj4xDjxb8icYsibLQYzZic32LTY2g/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">工资条的制作是每位HR的<span style="color: black;">必须</span>技能之一。<span style="color: black;">通常</span><span style="color: black;">状况</span>下，可能<span style="color: black;">大众</span>最先想到的是<span style="color: black;">运用</span>Excel来制作工资条，<span style="color: black;">况且</span>Excel中制作的<span style="color: black;">办法</span><span style="color: black;">亦</span>非常多，<span style="color: black;">例如</span>：<span style="color: black;">归类</span>汇总、函数、VBA、数据透视表、技巧排序法等等。</span><span style="color: black;">但其实，Word中<span style="color: black;">经过</span>邮件合并功能<span style="color: black;">一样</span><span style="color: black;">亦</span>能制作工资条，且<span style="color: black;">办法</span>非常简单快捷。接下来，<span style="color: black;">博主</span>就为<span style="color: black;">大众</span><span style="color: black;">仔细</span>讲解<span style="color: black;">运用</span>Word邮件合并快速制作工资条。</span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">详细</span>操作如下：</span></strong></span><span style="color: black;">（1）<span style="color: black;">首要</span>，<span style="color: black;">咱们</span>要准备一份Excel工资表数据表格，其中<span style="color: black;">包括</span>需要发工资的人员信息，如下图所示：</span><img src="https://mmbiz.qpic.cn/mmbiz_png/WB8piaYYKYfn7JXA6O34APx2FGon1SdMvNrib0tXjqF9loZr8biaYVg14T7iaNnmfTZj870gQtsZzM1n3P0Lo6TR9g/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">（2）关闭Excel，再<span style="color: black;">打开Word，<span style="color: black;">而后</span>输入相应文本并<span style="color: black;">插进</span>一个2行7列的表格，制作工资条模板（内容与Excel工资表相同），如下所示：</span></span><img src="https://mmbiz.qpic.cn/mmbiz_png/WB8piaYYKYfm7mUffsZ9AtudpCLIfGpcZsibtT0utxOKdBOwotmchcqpiaqT2uUTBTEoibU7Zoj9WkN8JicphbjFmuw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">（3）点击【邮件】-【<span style="color: black;">起始</span>合并邮件】按钮，在弹出的菜单中<span style="color: black;">选取</span>“目录”选项，邮件合并的类型<span style="color: black;">咱们</span>设置为目录。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/WB8piaYYKYfm7mUffsZ9AtudpCLIfGpcZLGdQm6ibMl3aCgE7A26rkibFrdZvQJrHqaHibia7wrgGmdXpJw0dGYdBiag/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">（4）点击【邮件】-【<span style="color: black;">起始</span>合并邮件】-【<span style="color: black;">选取</span>收件人】按钮，在弹出的菜单中<span style="color: black;">选取</span>“<span style="color: black;">运用</span>现有列表”选项。</p>
</span><img src="https://mmbiz.qpic.cn/mmbiz_png/WB8piaYYKYfm7mUffsZ9AtudpCLIfGpcZaTdqic4kFWia4onNaDEDO5I2iaOXofA3Sicb11CYqWntsJANOrQTpJdYMg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">（5）打开“<span style="color: black;">选取</span>数据源”对话框，找到<span style="color: black;">保留</span>数据源的位置，<span style="color: black;">选取</span>“工资表.xlsx”，单击“打开”按钮。</p>
</span><img src="https://mmbiz.qpic.cn/mmbiz_png/WB8piaYYKYfn7JXA6O34APx2FGon1SdMvnkSRiauHrwT6K5oichcsvSEkpCbAYQmaFIaM2aV7Tmkb9uE45vaibZxyg/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">（6）打开“<span style="color: black;">选取</span>表格”对话框，单击“确定”按钮。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/WB8piaYYKYfn7JXA6O34APx2FGon1SdMvTrzyRGgpdbiaJHBvgFOPyata7WlIquNQuicHnQnHJPIhQdVnW98Ccqow/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">（7）将鼠标光标定位到姓名下方的第1个单元格中，点击【邮件】-【编写和<span style="color: black;">插进</span>域】-【<span style="color: black;">插进</span>合并域】按钮，在弹出的菜单中<span style="color: black;">选取</span>“编号”选项。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/WB8piaYYKYfn7JXA6O34APx2FGon1SdMv7ufOogcbsGYfkOdYB7f8VuiaWzfnhiclz5yjqMicuR4Y5QU6ZBrsibt74Q/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">（8）<span style="color: black;">而后</span><span style="color: black;">根据</span>相同的<span style="color: black;">办法</span>依次在其他单元格中<span style="color: black;">插进</span>相应的域内容。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/WB8piaYYKYfm7mUffsZ9AtudpCLIfGpcZTw7GgUbkoIibW0ePib0mGF9zibfv6F02YpU4w2lW62s0Dv6QzYrSPuwVQ/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">（9）在【邮件】-【完成】组中单击“完成并合并”按钮，在弹出的菜单中<span style="color: black;">选取</span>“编辑单个文档”命令。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/WB8piaYYKYfm7mUffsZ9AtudpCLIfGpcZ6yGjzN673vQleuj1cS0tvKztLicHZUklocz1DpJ7d7bCTPhGNIA2eNw/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">（10）打开“合并到新文档”对话框，在“合并记录”栏中选中“<span style="color: black;">所有</span>”单选按钮，再单击“确定”按钮。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/WB8piaYYKYfn7JXA6O34APx2FGon1SdMvKEc3viaWEQWDanibIbCdzUvYJ7sCVTB4gydQF7xp8Iv7w4HG7gdwbTTQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><span style="color: black;">（11）此时，将自动新建一个名为“目录1”的Word文档，文档中将<span style="color: black;">表示</span>出所有人的工资条。</span></span><img src="https://mmbiz.qpic.cn/mmbiz_png/WB8piaYYKYfm7mUffsZ9AtudpCLIfGpcZ77BrDC7KUlUiaiclviaaqjCHYlTZia2icEfnfYMiafoHVCxyIpmkQBQsN20w/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">（12）<span style="color: black;"><span style="color: black;">工资条</span><span style="color: black;">已然</span>批量的制作好了，</span>确认无误后，将此文档<span style="color: black;">保留</span>，<span style="color: black;">而后</span>打印<span style="color: black;">就可</span>。</span><span style="color: black;"><span style="color: black;"><strong style="color: blue;">技巧提示：</strong></span><span style="color: black;">在制作过程中，<span style="color: black;">倘若</span>工资条中个别项目的小数位数<span style="color: black;">太多</span>，<span style="color: black;">咱们</span><span style="color: black;">能够</span>设置<span style="color: black;">保存</span>2位小数。</span></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">办法</span>：</span></strong><span style="color: black;">返回到Word主文档（即Word模板文档），按【Alt+F9 】组合键切换到域代码，在相应的数值后输入“\#"0.00””，<span style="color: black;">而后</span>再执行邮件合并，生成工资条。</span></span><img src="https://mmbiz.qpic.cn/mmbiz_png/WB8piaYYKYfm7mUffsZ9AtudpCLIfGpcZomwlF3bAXZnezazYWH5XFsbSnUy0WTDp5GziawZLDuCCz7Akdia9MswA/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">好了，今天的分享就到<span style="color: black;">这儿</span>，你学会了吗？</span><img src="https://mmbiz.qpic.cn/mmbiz_gif/CN8UjY2zsf8OQpuh16A6xk4ia1dhvtBMM99SRVK9GR3SLQHLY0xLeZxVGRpiab4FqMHXkBqpzpMVHdRCvrj7wjAQ/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">往 . 期 . 推 . 荐</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/WB8piaYYKYfl9CuFtJu9fQMQhymOZt50j2kTiayRtSbkRgNvK4Eub5jdy5lKqQLd3DjjAnKxxickZP1ibwDzvr7oxA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/WB8piaYYKYfl9CuFtJu9fQMQhymOZt50jkhB0yVNnsdsZNd7k7Pw9fiadsS0LVHZjCjZ5Fu0kDr6UiaeSp0xyVb2g/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/WB8piaYYKYfl9CuFtJu9fQMQhymOZt50jiaaibpSh3TEVyjU7QXot2yUgibibFx5nRd4etcofUUv7MTPxC2JlsrvC9Q/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></a></p><strong style="color: blue;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/WB8piaYYKYflUWfyibiaMJG6ZLsszN9XcEibVRRCPhp4QUkLBerqF9dicASqjC6cjZOGqxYzdyxJLb7aYiclokmPH1eg/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></strong><span style="color: black;">想学习<span style="color: black;">更加多</span>Word的知识，欢迎加入部落窝教育Word学习群。</span><span style="color: black;">QQ群号：</span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">584601721</span></strong></span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMzIgGt7DJAnbPm1Ynlrl7OIwBRTjDKr1mfkXxEtNGxkcLsX2xVJ9ooHPbD7qAWCOvP9oGTjhHK33w/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;">长按二维码添加QQ群</span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">点“</span><span style="color: black;">在看</span><span style="color: black;">”给我一朵小黄花</span><img src="https://mmbiz.qpic.cn/mmbiz_gif/lY7zDvL5Yvndgu3saDhMWD71T2R8fKicea1mHVAIr0pxYqFctHg8n7syOiaibp22cMaLt57HLBaKEAbIEfPfBcblQ/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p><img src="https://mmbiz.qpic.cn/mmbiz_png/lY7zDvL5Yvndgu3saDhMWD71T2R8fKice32dZbJltDVyKskPTIEibtLibHttPdsaXQfps15ofKjXvg2icCCUa9a5mg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
外链发布社区 http://www.fok120.com/ 论坛的成果是显著的，但我们不能因为成绩而沾沾自喜。
页:
[1]