Hi all,

In my database have a field expire date(MM/DD?YYYY), and a email adress fiield.

1. how can we have a mailing remind which will be sent 3 days before my expiration date ?

2. If the same email address but I have 10 records, can I have one email send to me to remind instead of 10 of them at the same time ??

Please help me if you could. Thanks for reading

There are instructions for an "Auto Notify" which is a modification of the auto delete mod.

You can find this in the FAQ by searching for auto delete mod and looking at the variations of this or the original thread is:

Thread: http://gossamer-threads.com/p/100873
Subject: Auto Notify
Rob 16-Aug-00

if the url doesn't work, please search by the Subject.

Would each record have the same expiration date? The mod is setup to check for an expiration date. I'm not sure how it could be modified to check records by a specific user.

Hope this helps

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

Hi Lois,

But how can it mail only one reminder for each person? if we have 10 records which expire 12/10/2002 for britney@yahoo.com, I don't want 10 emails remind
or how it know when to mail ? use login method to send mail ? if we use loggin method then I may have tons of mails because we may log in 10 times in one day or may not login for a week how can it mail reminder

It is hard to explain, but I hope you unsderstand what I try to say

Thanks for reading.

I'm not sure how to answer your question. If it is used with the autodelete mod then it would be according to each record.

Your best bet is to read the original post to see how the feature was being applied to that database and then see if that will work for you.

You could also post within that original thread and bring it back up to the top and see if anyone has ideas on how you could modify it to suit your needs. Just specify exactly what you want to accomplish.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

Hi Lois,

right now I only think we can use crob job to execute the script to mail alert once a day. I wrote this code can you check what did i do wrong?

http://www.gossamer-threads.com/...;;page=unread#unread

Only $date should be $expiredate, some how It only can mail one record at a time ( a person may have more than 10 mail reminder , but i really don't know how to make it mail for each person one mail per a day. I think you have better idea than I do. I just learn like monkey see monkey do .

If you know I hope you can help me.

Thanks,

I'm not a programmer so I don't think I'm able to help.

But I still don't fully understand how you have your script setup. Are you using the autodelete mod? If so, you will need to say which one as there are variations of this mod.

The auto notify is setup to work in conjunction with the autodelete mod, so it will know which records are about to expire.

It really helps for others to have the full picture of what you are trying to do .. so they can clearly see what may need to be done to get it to work.

I noticed in your other post that you are requesting that people remove their records or update the expire date within their record. With the auto delete mod it would expire and delete the records without the users having to manually do this themselves.

You may want to do some searching in the FAQ for related threads.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/