I am trying to send an automated custom email (via Flow or directly via SharePoint; no SharePoint Designer, PowerApps, or anything of the like). We can only use SharePoint Online. These emails would be sent to a contact based on the list.
The list columns look something like this:
Operator First Name | Operator Last Name | Email | Entity Name | FEIN | Date
I would like for the email to pull each contact and its respected entity names, FEIN, and date (the red in the photo below).
The end goal is to have the operator confirm that this is the most recent info. If it is wrong, they would have the option of editing that list item. NOTE: since this email would be sent out to hundreds of people, it is vital that they do not have access to view other people's information.
This email would be sent on the same day every year (let's say January 15th). There would be a follow up email on February 1st.
If the email could look something like the below photo, that would be fantastic. Nothing fancy necessary at the moment. I just do not want to call/send emails to 500+ contacts.
Also, my department is very limited on what we can or cannot do in SharePoint (no PowerApps, no Microsoft Forms, no SharePoint Designer, limited use for Microsoft Access).
Thank you in advance!!