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

Pererva, Yehor 0 Reputation points
2023-01-30T12:45:19.36+00:00

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

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
733 questions
Outlook
Outlook
A family of Microsoft email and calendar products.
3,319 questions
Outlook Management
Outlook Management
Outlook: A family of Microsoft email and calendar products.Management: The act or process of organizing, handling, directing or controlling something.
5,035 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jordan Millama 1,306 Reputation points
    2023-01-30T16:08:27.2733333+00:00

    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.

    User's image

    Please accept as an answer if this was helpful.