Access Power Automate directly from the ‘Automate’ tab within Excel. To streamline the process, opt for a pre-existing template specifically designed for sending emails based on selected rows.

Getting Started with Power Query. 1. Open Excel and ensure that the Data tab is visible. If it is not, you can enable it by going to File > Options > Customize Ribbon and checking the Data box.

Or you could automate this using PowerShell by converting the file to a .CSV, then using Import-Csv to work through the data that way. If neither of those approaches does what you want -- perhaps you ...