Hey, Im new to this forum. I want to know is it possible to generate automatic emails:

For example if a project completion date has passed an email is generated

Thanks

Hi there and welcome to the forums

First of all it is possible to generate an email from within FM using the script line 'Send Mail'.

Searching for 'email' in the online help file will tell you all you need to know to get you started.

Sending an e-mail if a completion date has been passed can be done by running a script that first does a find on all records for completion date < Get(CurrentDate) and then looping through the found set and gathering such data together as you need for your email and sending it.

How this programme is triggered rather depends on your setup. If your system is shutdown every night then the overdue e-mail routine can be included in your startup script (which can be nominated to run each time you startup).

If however your system runs 24/7 you will have to have a button somewhere that someone will have to click to run the script because as far as I am aware there is no way for FM to natively run a script on a daily/hourly basis

HTH

Phil

OK cheers for the feedback Phil,

Ill give that a go now.

I've a funny feeling Im going to be on these forums quite a bit for this project.

Thanks Again

Decy

Anytime Decy B)

I have no problem with the email. I don't know which post I had that you are talking about, since I have never set up an automatic email.

You can set it up so that you email a group of people with one click, but I don't know if you can have that email generated automatically when a condition is met with Filemaker.

I do know one thing for sure, someone on here will know the answer.

Do you have an example of what you are rying to do?

Dave