Skip to main content
AmigoFish

Microsoft Quietly Added Email to Excel - Here's How to Use It

From Leila Gharani Β· Β· 13 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.

If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.

Watch on YouTube

Not rated yet

Description

πŸ”₯ 500,000+ enrolled in our courses. Join them πŸ‘‰ https://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: https://www.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: https://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: https://link.xelplus.com/yt-d-newsletter

πŸ”“ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

🎬 LINKS to related videos: Introduction to Office Scripts: https://youtu.be/fny4zUycp_w Create Cool Buttons to Run Office Scripts from ANYWHERE: https://youtu.be/djf3tBIYmCw

πŸ‘• Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

🧭 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

🧰 Resources I recommend: https://www.xelplus.com/resources/

πŸ›’ More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

πŸ“² Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.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

Back to Leila Gharani Β· Report a problem