Hey Im new to this filemaker game, I ve got a DB setup now I require my DB to send automatic emails when the 'deadline date' = the current date.

Any help very much appreciated

Hi Dec

it all depends on what other criteria you mean to apply to your decision.

For instance do you want to send an email for all the records that meet the date deadline or some of them. And if some of them....which ones?

Really need that info before we can best advise you

Phil

Hey Phil

Cheers for the reply

I want to send an email for all records that meet the date deadline.

OK then

You will need to be on a layout that displays the field due date from the file that you want to get your records from. You will also need a script along these lines

Show all records

enter find mode

set field duedate;Get(CurrentDate)

Perform find

Go to record first

Loop

Send email

Go to record next;exit after last

end loop

Show all records

That is a very basic structure for a script that will find all the records where due date = the current system date of your computer and then starting from the top will go from one record to the next until it gets to the end of the found set. At each record it will send an email (which you obviously have to specify details for) and once it has gone through the lot it clears the found set.

This script, once developed can be attached to a button for manual triggering or you could include it as part of your startup script that can be nominated to run each time you open a file (under file options).

Either way you might want to think about marking records as 'email sent' so that in the case of the button being pressed twice a day or the file being opened more than once a day the same customers do not get more thatn one email

Hope that gives you some food for thought

Regards

Phil