Use Retrieve data table column into list to get a list of email addresses. Then use Join text to join the email addresses with a semicolon as the delimiter. Then use the output of this in the Send email message through outlook action. Somewhat like this:
Here's a code snippet you can copy and paste directly into PAD to get all of these actions created for you. I just use a variable for the account in Send email message through Outlook, so you might need to adjust that after you paste this.
Excel.ReadFromExcel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData
Excel.CloseExcel.Close Instance: ExcelInstance
Variables.RetrieveDataTableColumnIntoList DataTable: ExcelData ColumnNameOrIndex: $'''Email''' ColumnAsList=> EmailList
Text.JoinText.JoinWithCustomDelimiter List: EmailList CustomDelimiter: $''';''' Result=> Recipients
Outlook.Launch Instance=> OutlookInstance
Outlook.SendEmailThroughOutlook.SendEmail Instance: OutlookInstance Account: Account SendTo: Recipients Subject: $'''Testing''' IsBodyHtml: False
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
