Can we send automatic pre-scheduled client reminders emails?

[chabotjc]

Hello everyone!

Is there anyone here who knows how to send automatic email reminders with FM? I have a client database and I want to be able to pre-write a message that will be automatically be sent to some specific clients on a specific date.

Can FM actually do this? Are there any plug ins that would do that? I tried downloading the free version of mailit, scriptfire and I don't know how to use them... or even load them for that matter.. There's a java JRE problem that seems to be happening and I have NO CLUE whatsoever as to how to deal with this... I need help!!

And if it's too complicated to explain, I would be willing to pay someone to help me through this.. I've spent 4 hours trying to figure it out, and I'm zonked now.. phew!!! I hope there's a generous soul in this community who will be able to help me!

Thanks in advance for your time!

JC :)

[comment]

How about making this a part of your startup script?

[bcooney]

I'll assume that you don't have a FileMaker Server, since you don't mention it, and that you are the developer. As comment said, you can write a script that runs every time you open your file, a "startup script," that'll find all clients that are due* an email, and send them the email. You don't need any plugins for plain text emails. Html emails and more than one attachment requires a plugin.

*How you define "due" is up to you. I would have a field in the client record, flag_NeedsEmail, that calcs to 1 if they are due. Then, your startup script will find those clients and send them the email. The body of the email can come from a text field in a preference table.

This is simple, if you know what you're doing...perhaps a call to a prof dev is worth your time? FMI has a listing of consultants on their web site.

[comment]

FMI has a listing of consultants on their web site.

Are you on it?

[bcooney]

Yes, the company I work for is. I only sub-contract.