How to automate email sending using user-list from Word file?

Question

Hello!

I'm looking for the way to automate the sending of reminder to colleagues (either via Outlook or Teams) based on list in Word file (Microsoft 365 Apps for enterprise). Could you help me?

The list of users is in Word file and is structured as:

| week # | date of the first day of the week | Person 1 | Person 2 |

What I want is and automatic email, which is sent on the Monday of that week# at 8:00 with approx. the following content:

" Dear Person 1 and person 2!

This is an automated reminder that you've been assigned for a duties this week: from ______ till ______ (date of Monday and Friday of that week #).

Signature here. "

Is there a way to do that? I used to make those emails for a month upfront and use delayed delivery, but it works nicely only if people didn't swap the time slots.

P.S. This is repost from https://answers.microsoft.com/en-us/outlook_com/forum/all/how-to-automate-email-sending-using-user-list-from/a4b13163-1ebb-491e-8e8b-8cd97ffde5fd?messageId=7ce901a1-1399-4c2a-b98e-bdd9289a8f94

Answer 1

I suggest using a combination of Microsoft Power Automate and Excel. You can create an automated reoccurring workflow that takes info from an Excel file (like email addresses) and then sends an email or Teams message to them. Have a look at the Power Automate templates, there may already be one there you can use or at least modify to your needs, such as the Get a row from Excel (Business) and send an email template.

---

Please accept as an answer if this was helpful.