I have a followup table that has 6 fields in it. [MEMO], [CLIENT], [DATE_TO_FOLLOWUP], [TIME_TO_FOLLOWUP], [EMAIL_WHO],[FOLLOWUP_COMPLETE].
I want a Form using the On Timer function to look at a query that runs every minute to check if there is anything to followup with by looking at the [DATE_TO_FOLLOWUP] AND [TIME_TO_FOLLOWUP] and if the query has records then run a SendObject function sending me the the following:
EMAIL=[EMAIL_WHO]
SUBJECT=[CLIENT]
MESSAGE=[MEMO]
And i know at times i will have more then one record needing followed up on at the same date and time... any ideas on how to go about doing this? Your wisdom and insight is greatly appreciated.
I want a Form using the On Timer function to look at a query that runs every minute to check if there is anything to followup with by looking at the [DATE_TO_FOLLOWUP] AND [TIME_TO_FOLLOWUP] and if the query has records then run a SendObject function sending me the the following:
EMAIL=[EMAIL_WHO]
SUBJECT=[CLIENT]
MESSAGE=[MEMO]
And i know at times i will have more then one record needing followed up on at the same date and time... any ideas on how to go about doing this? Your wisdom and insight is greatly appreciated.
Last edited:
