Uploaded May 2026 | Updated September 2026, 1 day ago
🔥 500,000+ enrolled in our courses. Join them 👉 link.xelplus.com/yt-d-all-courses
Stop wasting hours manually saving, naming, and emailing Excel reports! In this tutorial, we unlock the power of Office Scripts to automate your entire reporting workflow. You will learn how to build a 1-click button that converts specific sheets to PDF and sends them via Outlook instantly. All with the help of Office Scripts in Excel.
⬇️ DOWNLOAD the workbook with the code here: xelplus.com/office-scripts-pdf-email-excel/#download
Unlike traditional VBA macros, this solution is online-ready and works perfectly in Excel for the Web, Microsoft Teams and Microsoft 365 - and of course also on desktop. We’ll walk through the TypeScript code, set up a dynamic data table for your recipients, and show you how to customize the script for your own dashboards.
Microsoft Learn page: learn.microsoft.com/en-us/office/dev/scripts/resources/samples/save-as-pdf-email-as-pdf
What You'll Learn:
- How to use the convertToPdf and sendMail APIs in Office Scripts.
- Setting up a recipient table (Name, Email, Sheet Name) for bulk processing.
- Connecting a script to a "Run" button for a professional UI.
- Why Office Scripts are the modern, secure alternative to VBA for report distribution.
🕐 Timestamps
00:00 The Manual Reporting Problem (And the 1-Click Solution)
01:15 Setting Up Your Dashboard: The Data Table Structure
02:45 Introduction to Office Scripts & The Automate Tab
04:10 Script Walkthrough: Understanding convertToPdf & sendMail
06:30 Customizing the Code for Multiple Recipients
08:20 Adding the Automation Button to Your Sheet
09:50 Live Demo: Bulk Emailing PDF Reports
11:05 Troubleshooting & Common Script Errors
12:30 Final Tips: Moving from VBA to Office Scripts
📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
🔓 Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
🎬 LINKS to related videos:
Introduction to Office Scripts: youtu.be/fny4zUycp_w
Create Cool Buttons to Run Office Scripts from ANYWHERE: youtu.be/djf3tBIYmCw
👕 Get the Official XelPlus MERCH: xelplus.creator-spring.com
🧭 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🧰 Resources I recommend: xelplus.com/resources
🛒 More resources on my Amazon page: amazon.com/shop/leilagharani
📲 Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel #officescripts
🔥 500,000+ enrolled in our courses. Join them 👉 link.xelplus.com/yt-d-all-courses
Stop wasting hours manually saving, naming, and emailing Excel reports! In this tutorial, we unlock the power of Office Scripts to automate your entire reporting workflow. You will learn how to build a 1-click button that converts specific sheets to PDF and sends them via Outlook instantly. All with the help of Office Scripts in Excel.
⬇️ DOWNLOAD the workbook with the code here: xelplus.com/office-scripts-pdf-email-excel/#download
Unlike traditional VBA macros, this solution is online-ready and works perfectly in Excel for the Web, Microsoft Teams and Microsoft 365 - and of course also on desktop. We’ll walk through the TypeScript code, set up a dynamic data table for your recipients, and show you how to customize the script for your own dashboards.
Microsoft Learn page: learn.microsoft.com/en-us/office/dev/scripts/resources/samples/save-as-pdf-email-as-pdf
What You'll Learn:
- How to use the convertToPdf and sendMail APIs in Office Scripts.
- Setting up a recipient table (Name, Email, Sheet Name) for bulk processing.
- Connecting a script to a "Run" button for a professional UI.
- Why Office Scripts are the modern, secure alternative to VBA for report distribution.
🕐 Timestamps
00:00 The Manual Reporting Problem (And the 1-Click Solution)
01:15 Setting Up Your Dashboard: The Data Table Structure
02:45 Introduction to Office Scripts & The Automate Tab
04:10 Script Walkthrough: Understanding convertToPdf & sendMail
06:30 Customizing the Code for Multiple Recipients
08:20 Adding the Automation Button to Your Sheet
09:50 Live Demo: Bulk Emailing PDF Reports
11:05 Troubleshooting & Common Script Errors
12:30 Final Tips: Moving from VBA to Office Scripts
📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
🔓 Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
🎬 LINKS to related videos:
Introduction to Office Scripts: youtu.be/fny4zUycp_w
Create Cool Buttons to Run Office Scripts from ANYWHERE: youtu.be/djf3tBIYmCw
👕 Get the Official XelPlus MERCH: xelplus.creator-spring.com
🧭 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🧰 Resources I recommend: xelplus.com/resources
🛒 More resources on my Amazon page: amazon.com/shop/leilagharani
📲 Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel #officescripts
