/iknow-pic.cdn.bcebos.com/8b82b9014a90f6039431a63a3612b31bb151edce"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/8b82b9014a90f6039431a63a3612b31bb151edce?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/8b82b9014a90f6039431a63a3612b31bb151edce"/>
2、在打开的设置界面中找到个性签名选项,并点击添加个性签名。
/iknow-pic.cdn.bcebos.com/bd315c6034a85edff225c45e46540923dd547525"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/bd315c6034a85edff225c45e46540923dd547525?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/bd315c6034a85edff225c45e46540923dd547525"/>
3、在跳转的新建个性签名中,在输入框中编辑需要设置的邮箱后缀。
/iknow-pic.cdn.bcebos.com/10dfa9ec8a1363276f6df84e9e8fa0ec09fac7ce"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/10dfa9ec8a1363276f6df84e9e8fa0ec09fac7ce?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/10dfa9ec8a1363276f6df84e9e8fa0ec09fac7ce"/>
4、编辑完成后,点击右下角的确定,保存后缀即可。
/iknow-pic.cdn.bcebos.com/0df3d7ca7bcb0a46d7a2b1446463f6246a60afce"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/0df3d7ca7bcb0a46d7a2b1446463f6246a60afce?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/0df3d7ca7bcb0a46d7a2b1446463f6246a60afce"/>
1、打开qq邮箱,在界面上找到设置选项,并点击打开设置。/iknow-pic.cdn.bcebos.com/8b82b9014a90f6039431a63a3612b31bb151edce"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/8b82b9014a90f6039431a63a3612b31bb151edce?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/8b82b9014a90f6039431a63a3612b31bb151edce"/>
2、在打开的设置界面中找到个性签名选项,并点击添加个性签名。
/iknow-pic.cdn.bcebos.com/bd315c6034a85edff225c45e46540923dd547525"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/bd315c6034a85edff225c45e46540923dd547525?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/bd315c6034a85edff225c45e46540923dd547525"/>
3、在跳转的新建个性签名中,在输入框中编辑需要设置的邮箱后缀。
/iknow-pic.cdn.bcebos.com/10dfa9ec8a1363276f6df84e9e8fa0ec09fac7ce"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/10dfa9ec8a1363276f6df84e9e8fa0ec09fac7ce?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/10dfa9ec8a1363276f6df84e9e8fa0ec09fac7ce"/>
4、编辑完成后,点击右下角的确定,保存后缀即可。
/iknow-pic.cdn.bcebos.com/0df3d7ca7bcb0a46d7a2b1446463f6246a60afce"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/0df3d7ca7bcb0a46d7a2b1446463f6246a60afce?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/0df3d7ca7bcb0a46d7a2b1446463f6246a60afce"/>
方法一、设置单元格格式法:1、选择需要添加上邮箱后缀的单元格,单击鼠标右键,选择设置单元格格式。
2、在弹出的菜单中,选择数字,而后找到自定义,将输入法转换成英文输入法模式,选择G\通用模式,在类型中在字符后面输入邮箱的后缀名,这里输入”@163.com”。这串文本的意思是,在原本的字符后面加上邮箱后缀,点击确定,就会发现邮箱后缀已经被批量添加上了。
方法二、函数法:
1、准备好表格。
2、将电脑输入法转换为英文输入法,之后在单元格内输入等号,之后点击前面的邮箱地址单元格,输入&,再输入邮箱后缀,这段字符的意思是,在这个单元格内容后加上邮箱后缀,填写完毕之后选择确定,就会发现邮箱后缀已经被添加上了,选择向下填充即可。
欢迎分享,转载请注明来源:夏雨云
评论列表(0条)