Email Excel Reports with Power Automate & Office Scrips - One Click Automation 🤖

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