Building an Auto calendar invite system
Hello guys, I hope you are doing well today. So basically, here is what i want:
* Attendees fill the form (Microsoft form) the information mainly the mail is shifted to a excel sheet (this is done)
* The system should read from the list of webinar sessions and choose only the next 1 upcoming one
* It should use that tittle and create a calendar invite (mainly for outlook but also google if it is possible) each attendee should get a calendar separately
----
* I also require sending out reminder emails along with the flyer of each webinar session. but there are more than 300 attendees and i need to send the reminder email to each one separately due to confidentiality of the users email.
BTW - point to be noted - All of this on a organization's database as such there are prohibitions on some things.
THE MAIN POINT IS TO SEND THE ATANDEES PARTICUAL EMAIL SEPARAETLY SO THEY DONT GET ACCESS TO EACH OTHERS MAIL ADDRESS
If you have any question do let me know. I would appreciate the communities help on this matter