You’re offline. This is a read only version of the page.
21
In a single Office 365 Excel workbook, there are three sheets.
The first sheet "People" contains data about the recipients, including their names, emails and categories.
The second sheet has lookups, which link category with code.
And the final sheet has text of email to be sent.
What I would like to do using Power Automate/Office Scripts is to send emails only to people for whom the category is either 2 or 3. Emails should NOT be sent to those with category 1.
The mail merge bit is to:
I have even struggled to find any tutorials on how to use Office Scripts to send emails in Excel. So would greatly appreciate any guidance.
Hi @VPundir ,
Here's how I would approach this. For starters, I wouldn't over-complicate this with three separate tables, what you are doing can be collapsed into a single table, shown below. I didn't include the first name in my example.
Here's the flow. Note above, if you never intend to email category 1, simply don't include it or filter it out. In my example, I didn't include.
So here, I list all the non-category 1 rows in a table and then loop through each row and send an email. For me it is much easier to simply collapse the email distro into a semicolon separated email list in a column.
That said, you have enough framework here to help you get started!
Share
Report
All responses (
Answers (
