Share
Report
21In 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:
- Append appropriate code for the recipient in the subject grabbed from Sheet3!A2. e.g. For Mack, the code would be GNG.
- Prepend "Dear recipient name" in the email body grabbed from Sheet3!B2. For Mack, this would be "Dear Mack,"
- To send emails to the correct email addresses. For Mack it should be sent to mack@company.com
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.
Categories:
I have the same question (0)
All responses (
Answers (
