Sending clients due reminders

%3CLINGO-SUB%20id%3D%22lingo-sub-377546%22%20slang%3D%22en-US%22%3ESending%20clients%20due%20reminders%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377546%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20send%20clients%20periodic%20email%20reminders%20that%20certificates%20need%20updating.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20is%20the%20best%20way%20to%20automatically%20send%20clients%20reminders%20using%20office%20365%20apps%20near%20the%20due%20date%20(say%20one%20month%20and%2014%20days)%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-377546%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-378859%22%20slang%3D%22en-US%22%3ERe%3A%20Sending%20clients%20due%20reminders%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-378859%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F304325%22%20target%3D%22_blank%22%3E%40PaulJennings%3C%2FA%3E%26nbsp%3B%20if%20you%20have%20a%20machine%26nbsp%3B%20(a%20real%20or%20a%20virtual)%20that%20always%20run%2C%3C%2FP%3E%3CP%3Eyou%20can%20create%20a%20simple%20PowerShell%20script%20and%20start%20it%20using%20Windows%20Task%20scheduler.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-378539%22%20slang%3D%22en-US%22%3ERe%3A%20Sending%20clients%20due%20reminders%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-378539%22%20slang%3D%22en-US%22%3EThanks%20Cian.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-377553%22%20slang%3D%22en-US%22%3ERe%3A%20Sending%20clients%20due%20reminders%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377553%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F304325%22%20target%3D%22_blank%22%3E%40PaulJennings%3C%2FA%3E%26nbsp%3BMicrosoft%20Flow%20would%20be%20a%20candidate%20for%20this%2C%20this%20article%20has%20a%20run%20through%2C%20it%20may%20take%20some%20trial%20and%20error%20but%20I%20think%20it's%20close%20to%20what%20you%20are%20after%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FMicrosoft-Flow-Community-Blog%2FCreating-a-List-Reminder-Flow%2Fba-p%2F130025%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FMicrosoft-Flow-Community-Blog%2FCreating-a-List-Reminder-Flow%2Fba-p%2F130025%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20would%20use%20a%20SharePoint%20list%20to%20hold%20the%26nbsp%3Binformation%20on%20the%20client%20details%20which%20the%20Flow%20would%20use%20to%20check%20and%20send%20reminders%20accordingly%2C%20here%20is%20a%20quick%20guide%20on%20this%20-%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcreate-a-list-in-sharepoint-0d397414-d95f-41eb-addd-5e6eff41b083%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ECreate%20a%20list%20in%20SharePoint%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFinally%2C%20this%20might%20be%20of%20interest%20and%20a%20good%20place%20to%20start%20-%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.sharepointsiren.com%2F2018%2F03%2Fusing-flow-to-send-email-reminder-from-sharepoint-data%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EUsing%20Flow%20to%20send%20Email%20Reminder%20from%20SharePoint%20Data%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I need to send clients periodic email reminders that certificates need updating.

 

What is the best way to automatically send clients reminders using office 365 apps near the due date (say one month and 14 days)?

3 Replies
Highlighted

@PaulJennings Microsoft Flow would be a candidate for this, this article has a run through, it may take some trial and error but I think it's close to what you are after:

 

https://powerusers.microsoft.com/t5/Microsoft-Flow-Community-Blog/Creating-a-List-Reminder-Flow/ba-p...

 

This would use a SharePoint list to hold the information on the client details which the Flow would use to check and send reminders accordingly, here is a quick guide on this - Create a list in SharePoint.

 

Finally, this might be of interest and a good place to start -  Using Flow to send Email Reminder from SharePoint Data.

Highlighted
Thanks Cian.
Highlighted

@PaulJennings  if you have a machine  (a real or a virtual) that always run,

you can create a simple PowerShell script and start it using Windows Task scheduler.