【机器人-RPA-财务对账邮件应用自动化(客户对账机器人)】此文章归类为:[
"机器人",
"网络",
"运维",
"r语言",
"自动化"
]。
《财务对账邮件应用自动化》,将会使用邮箱的SMTP服务,小北把资源包绑定在这篇博客了
Uibot (RPA设计软件)———机器人的小项目友友们可以参考小北的课前材料五博客~ (本博客中会有部分课程ppt截屏,如有侵权请及请及时与小北我取得联系~)
紧接着小北的前两篇博客,友友们我们即将开展新课的学习~
RPA 培训前期准备指南——安装Uibot(RPA设计软件)-CSDN博客https://blog.csdn.net/Zhiyilang/article/details/135348488?spm=1001.2014.3001.5502https://blog.csdn.net/Zhiyilang/article/details/135348488?spm=1001.2014.3001.5502https://blog.csdn.net/Zhiyilang/article/details/135348488?spm=1001.2014.3001.5502https://blog.csdn.net/Zhiyilang/article/details/135348488?spm=1001.2014.3001.5502https://blog.csdn.net/Zhiyilang/article/details/135348488?spm=1001.2014.3001.5502https://blog.csdn.net/Zhiyilang/article/details/135348488?spm=1001.2014.3001.5502https://blog.csdn.net/Zhiyilang/article/details/135348488?spm=1001.2014.3001.5502https://blog.csdn.net/Zhiyilang/article/details/135348488?spm=1001.2014.3001.5502https://blog.csdn.net/Zhiyilang/article/details/135348488?spm=1001.2014.3001.5502
一、相关材料链接:
【免费】Uibot(RPA设计软件)培训前期准备指南-课前材料资源-CSDN文库https://download.csdn.net/download/Zhiyilang/88695809?spm=1001.2014.3001.5501https://download.csdn.net/download/Zhiyilang/88695809?spm=1001.2014.3001.5501https://download.csdn.net/download/Zhiyilang/88695809?spm=1001.2014.3001.5501https://download.csdn.net/download/Zhiyilang/88695809?spm=1001.2014.3001.5501https://download.csdn.net/download/Zhiyilang/88695809?spm=1001.2014.3001.5501https://download.csdn.net/download/Zhiyilang/88695809?spm=1001.2014.3001.5501https://download.csdn.net/download/Zhiyilang/88695809?spm=1001.2014.3001.5501
温馨提示:在接下来的学习过程中,大家请不要升级UiBot6.0.0,自动忽略升级~
Uibot (RPA设计软件)网页表单填写————课前材料三_uibot 列表 输入 选择-CSDN博客https://blog.csdn.net/Zhiyilang/article/details/135487069?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135487069?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135487069?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135487069?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135487069?spm=1001.2014.3001.5501
UiBot (RPA设计软件)网页表单填写整体过程展示
Uibot (RPA设计软件)股票板块行情抓取————课前材料四_uibot 股票-CSDN博客https://blog.csdn.net/Zhiyilang/article/details/135587294?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135587294?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135587294?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135587294?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135587294?spm=1001.2014.3001.5501
Uibot (RPA设计软件)Mage AI智能识别(发票识别)———课前材料五_mage ai uibot-CSDN博客https://blog.csdn.net/Zhiyilang/article/details/135591297?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135591297?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135591297?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135591297?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135591297?spm=1001.2014.3001.5501
UiBot (RPA)Mage AI智能识别——发票识别
Uibot (RPA设计软件)智能识别信息+微信群发助手(升级版)———课后练习1_uibot 微信消息推送-CSDN博客https://blog.csdn.net/Zhiyilang/article/details/135970224?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135970224?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135970224?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135970224?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135970224?spm=1001.2014.3001.5501
Uibot (RPA设计软件)智能识别信息+微信群发助手(升级版)———课后练习2-CSDN博客https://blog.csdn.net/Zhiyilang/article/details/136200438?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/136200438?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/136200438?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/136200438?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/136200438?spm=1001.2014.3001.5501
Uibot (RPA设计软件)财务会计Web应用自动化(批量开票机器人)-CSDN博客https://blog.csdn.net/Zhiyilang/article/details/136782171?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/136782171?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/136782171?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/136782171?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/136782171?spm=1001.2014.3001.5501
RPA-财务会计Web应用自动化(批量开票机器人)
Uibot6.0 RPA财务招聘信息抓取机器人案例实战
Uibot RPA-Excel操作自动化(学生信息汇总)
正文:RPA-财务对账邮件应用自动化(客户对账机器人)PPT
《财务对账邮件应用自动化》,将会使用邮箱的SMTP服务(资源包在博客开头)
点击“设置”
点击账号,往下拉
找到POP3/IMAP/SMTP/Exchange/CardDAV/CalDAV服务,点击“开启服务”
绑定手机
人工手动过一遍流程,发给自己:
1.邮箱地址是变动的
2.标题除了""应收账款对账"前面的公司是动态的
话术:"尊敬的"&value&":您好!\n贵公司本期的应收账款余额为:"&客户应收账款总额&"万元。请核查!\n本函仅为复核账目之用,并非催款结算。款项无论相符与否,仍请及时函复为盼。"
3.\n代表换行,正文除了公司和应收账款总额以外其余为固定语句
4.应收账款总额需要在Excel表格进行计算
交互式练习:客户对账
答案:
RPA流程开发界面:
SUMIF
=SUMIF(台账!A$10:A$71,A1,台账!B$10:B$71)
=SUMIF(台账!A$10:A$71,A2,台账!B$10:B$71)
=SUMIF(台账!A$10:A$71,A3,台账!B$10:B$71)
"=SUMIF(台账!A$10:A$71,A3,台账!B$10:B$71)" 原始格式
"=SUMIF("&所有工作表名[0]&"!A$10:A$71,A3,"&所有工作表名[0]&"!B$10:B$71)" 实现工作表名的动态变化
"=SUMIF("&所有工作表名[0]&"!A$10:A$"&总行数&",A3,"&所有工作表名[0]&"!B$10:B$"&总行数&")" 实现工作表数据行数的动态变化
"=SUMIF("&所有工作表名[0]&"!A$10:A$"&总行数&",A"&i&","&所有工作表名[0]&"!B$10:B$"&总行数&")" 使用i实现计算对应单元格变化
完整代码展示:
视频展示: