RPA-财务对账邮件应用自动化(客户对账机器人)

 《财务对账邮件应用自动化》,将会使用邮箱的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.5502icon-default.png?t=N7T8https://blog.csdn.net/Zhiyilang/article/details/135348488?spm=1001.2014.3001.5502

Uibot (RPA设计软件)培训前期准备指南————课前材料-CSDN博客https://blog.csdn.net/Zhiyilang/article/details/135365357?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135365357?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135365357?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135365357?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135365357?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135365357?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135365357?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135365357?spm=1001.2014.3001.5501icon-default.png?t=N7T8https://blog.csdn.net/Zhiyilang/article/details/135365357?spm=1001.2014.3001.5501

一、相关材料链接:

【免费】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.5501icon-default.png?t=N7T8https://download.csdn.net/download/Zhiyilang/88695809?spm=1001.2014.3001.5501

温馨提示:在接下来的学习过程中,大家请不要升级UiBot6.0.0,自动忽略升级~1c791adadeb64ba9ace78719e4d93f2e.png​​

 二、视频展示:Uibot (RPA设计软件)微信群发助手机器人————课前材料二_uibot 怎么启动微信-CSDN博客https://blog.csdn.net/Zhiyilang/article/details/135453437?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135453437?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135453437?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/135453437?spm=1001.2014.3001.5501icon-default.png?t=N7T8https://blog.csdn.net/Zhiyilang/article/details/135453437?spm=1001.2014.3001.5501

UiBot微信消息轰炸

RPA微信群发助手机器人

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.5501icon-default.png?t=N7T8https://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.5501icon-default.png?t=N7T8https://blog.csdn.net/Zhiyilang/article/details/135587294?spm=1001.2014.3001.5501

UiBot RPA设计软件 股票板块行情抓取

RPAUiBot 股票板块行情抓取拓展(每日)

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.5501icon-default.png?t=N7T8https://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.5501icon-default.png?t=N7T8https://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.5501icon-default.png?t=N7T8https://blog.csdn.net/Zhiyilang/article/details/136200438?spm=1001.2014.3001.5501

UiBot6.0校网更新提示助手(初版成功)

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.5501icon-default.png?t=N7T8https://blog.csdn.net/Zhiyilang/article/details/136782171?spm=1001.2014.3001.5501

RPA-财务会计Web应用自动化(批量开票机器人)

Uibot6.0 (RPA财务机器人师资培训第2天 )采购付款——网银付款机器人案例实战-CSDN博客https://blog.csdn.net/Zhiyilang/article/details/136917700?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/136917700?spm=1001.2014.3001.5501https://blog.csdn.net/Zhiyilang/article/details/136917700?spm=1001.2014.3001.5501icon-default.png?t=N7T8https://blog.csdn.net/Zhiyilang/article/details/136917700?spm=1001.2014.3001.5501

网银付款机器人案例实战

Uibot6.0 (RPA财务机器人师资培训第3天 )财务招聘信息抓取机器人案例实战-CSDN博客https://blog.csdn.net/Zhiyilang/article/details/136966121?spm=1001.2014.3001.5501icon-default.png?t=N7T8https://blog.csdn.net/Zhiyilang/article/details/136966121?spm=1001.2014.3001.5501

Uibot6.0 RPA财务招聘信息抓取机器人案例实战

Uibot (RPA设计软件)​RPA-Excel操作自动化(学生信息汇总)-CSDN博客icon-default.png?t=N7T8https://blog.csdn.net/Zhiyilang/article/details/137010602?spm=1001.2014.3001.5502

Uibot RPA-Excel操作自动化(学生信息汇总)

正文:RPA-财务对账邮件应用自动化(客户对账机器人)PPT

​《财务对账邮件应用自动化》,将会使用邮箱的SMTP服务(资源包在博客开头)

点击“设置”

点击账号,往下拉

找到POP3/IMAP/SMTP/Exchange/CardDAV/CalDAV服务,点击“开启服务”

绑定手机

人工手动过一遍流程,发给自己:

1.邮箱地址是变动的
2.标题除了""应收账款对账"前面的公司是动态的

RPA实验 (honjoin.com)icon-default.png?t=N7T8https://zd.honjoin.com/#/viewProject?trainId=6d7940b0-7d51-11ee-ab25-819ec8d7cb4f&token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VyR3VpZCI6IjQ1YTVkZDkwLWFiOWMtMTFlZS05OWNlLWYzM2VhY2NkOGY3ZiIsInR5cGUiOiJzdHVkZW50IiwiaWF0IjoxNzExMzQ4NTYwLCJleHAiOjE3MTEzODQ1NjB9.varpq3GfldXToSmAFe1v21-9SN6n-Tu3gspily5jd78

话术:"尊敬的"&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实现计算对应单元格变化

完整代码展示:

视频展示:

RPA-财务对账邮件应用自动化(客户对账机器人)

最近更新

  1. leetcode705-Design HashSet

    2024-04-02 10:12:01       5 阅读
  2. Unity发布webgl之后打开streamingAssets中的html文件

    2024-04-02 10:12:01       5 阅读
  3. vue3、vue2中nextTick源码解析

    2024-04-02 10:12:01       6 阅读
  4. 高级IO——React服务器简单实现

    2024-04-02 10:12:01       5 阅读
  5. 将图片数据转换为张量(Go并发处理)

    2024-04-02 10:12:01       4 阅读
  6. go第三方库go.uber.org介绍

    2024-04-02 10:12:01       6 阅读
  7. 前后端AES对称加密 前端TS 后端Go

    2024-04-02 10:12:01       7 阅读

热门阅读

  1. OpenEuler/Centos制作离线软件源

    2024-04-02 10:12:01       3 阅读
  2. File类的解释与说明

    2024-04-02 10:12:01       3 阅读
  3. linux清空文件内容

    2024-04-02 10:12:01       4 阅读
  4. 联邦学习概述,让你了解联邦学习

    2024-04-02 10:12:01       4 阅读
  5. 竞赛常考的知识点大总结(四)高级数据结构

    2024-04-02 10:12:01       4 阅读
  6. MySQL|为什么不推荐用外键?

    2024-04-02 10:12:01       4 阅读
  7. 如何在微信小程序中使用less来编写css

    2024-04-02 10:12:01       6 阅读
  8. selenium

    2024-04-02 10:12:01       4 阅读
  9. 【C/C++】C语言实现数组(多维数组+稀疏矩阵)

    2024-04-02 10:12:01       10 阅读
  10. node.js常用命令

    2024-04-02 10:12:01       6 阅读
  11. Mysql的库函数

    2024-04-02 10:12:01       3 阅读