Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Generating auto email from a date field


vancity
 Share

Recommended Posts

Hello,

Can anyone enlighten me how I can utilise a "follow up" date field to auto email a single specific email address when the date entered arrives

Thank you

Link to comment
Share on other sites

In FileMaker 8.5?

 

Buy a spare computer. Run a perpetual looping script on it.

 

Loop

Enter Find Mode []

Set Field [YourTable::Due Date; ≤ Get(CurrentDate)]

Set Field [YourTable::Email Sent; "="]

Perform Find []

If [Get(FoundCount)>0]

.. Go to Record [first]

.. Loop

.... Send Mail [To, From, Msg Body, etc specified]

.... Set Field [YourTable::Email Sent; "Yes"][

.... Go to Record [Next, Exit After Last]

.. End Loop

End If

Pause [specified number of minutes e.g., 30 minutes]

End Loop

Link to comment
Share on other sites

If I make an "email sent" filed in the CUSTOMER table, my script goes something like...

 

Loop

Enter Find Mode []

Set Field [CUSTOMERS::Follow up Date; ≤ Get(CurrentDate)]

Set Field [CUSTOMERS::Email Sent; "="]

Perform Find []

If [Get(FoundCount)>0]

.. Go to Record [first]

.. Loop

.... Send Mail [To abc@abc.com, CUSTOMER NAME]

.... Set Field [CUSTOMERS::Email Sent; "Yes"][

.... Go to Record [Next, Exit After Last]

.. End Loop

End If

Pause [specified number of minutes e.g., 30 minutes]

End Loop

 

Thanks for the assistance

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use