Email Excel Reports with Power Automate & Office Scrips - One Click Automation 🤖
Автор: Chandoo
Загружено: 2023-03-21
Просмотров: 82290
Ever wanted to send an email of your Excel report to the relevant people with a single click? In this video, let me show you how we used Office Scripts & Power Automate to solve the problem.
You will learn:
▶ Email Automation concept
▶ How to use Office Scripts
▶ How to set up Power Automate Flows
▶ How to integrate Excel with Power Automate & Office Scripts
⏱ IN THIS VIDEO 👇
=================
0:00 - Email Automation - Quick demo
2:37 - Setting up the Email Contents in Excel
3:50 - Introduction to Office Scripts
8:07 - Sending Email - Office Script
20:23 - Setting up the Power Automate Flow
29:12 - Send Email Button in Excel
31:57 - Closing Remarks (what I think about Power Automate + Office Script option)
👩💻 CODE & RESOURCES
====================
Please visit URL to see the sample code and a demo file to play with.
👉 https://chandoo.org/wp/send-email-fro...
⚙ MORE ON EXCEL + AUTOMATION
=============================
If you like to speed up your work with the Automation features of Excel, check out below videos too.
How to use VBA in Excel - • Learn VBA & Excel Macros in 20 minutes - w...
How to use Power Query in Excel - • Power Query Tutorial - What is it, how to ...
How to use AI in Excel - • Built- in AI features of Excel (no need fo...
How to use Formulas in Excel - • Top 10 Excel Functions you should learn in...
🙋♂️ Want more?
Check out my full-length Excel course and become a PRO at work.
https://chandoo.org/wp/excel-school-p...
🙏 Thanks to Mark
================
Special thanks to @ExcelOffTheGrid Mark Proctor for the code inspiration. See his article here - https://exceloffthegrid.com/power-aut...
~
Do you ever think if an AI bot is working for another AI bot, would the first bot act busy when the boss bot is around 🤣
#powerautomate #excel
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: