We need to send reminders to people outside of QB

Question

Hi,

We keep multiple tables with creditialing information for our medical staff and have columns with dates when things need to be renewed. We need to be able to send date triggered reminders to out providers if a renew is coming up, however these providers are not QB users - how can we do this?

Thanks!------------------------------Meagan McOlin------------------------------

markshnier__you · Answer

No problem, pipelines to the rescue.&nbsp;
Make a clean checkbox formula field to indicate that an email is due to be sent but has not been sent.&nbsp;
Make a Date / Time field to be used to trigger the email.&nbsp;
Make a field called [Current Date / Time] with a formula of now().&nbsp;
ok, so now we are ready to build the Pipeline &nbsp;search records where the checkbox is yes and then do a For Each to populate the date time field with the current date time &nbsp;Schedule to run every day at a civilized time like 10:00 am &nbsp;
------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

markshnier__you · Answer

Also make sure you set up an OPEN type notification.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Forum Discussion

We need to send reminders to people outside of QB

2 Replies