What is the easiest way of creating an automatic emailing system

[david385393]

What is the easiest way of creating an automatic emailing system to send an email to all users on the User Resolution SP database. The emails need to be sent every day at a certain time.

Second question... Is there any webassist solution which can be used to notify me if a user has already been registered and removed from the list previously. For example, I am allowing visitors to register free for a few weeks and then if they don't pay the small fee, have them removed. Would like to stop them from re-registering for the free time again. I understand this is easy if they try to use the same email address and other details again. What could be used if they were attempting to register the second time using a second email or new email address. Is it possible to track the IP address in this situation.

It is probably obvious I'm not an experienced programmer which is why I'm looking for the solution with the least amount of programming.

Would be grateful for any advise

[Eric Mittman]

When it comes to creating an automated mailer you could have a script page with Universal Email applied to it. On this page you would need to have a recordset that selects all of the people you would like to send the message to. Then with Universal Email you would just set it to send to everyone in the recordset. To get the page to run every day at a certain time you would use a cron job on a Linux OS or a scheduled task on a Windows machine.

The second part about limiting the free membership is a little tricky. You must determine what criteria you will use to tell if the user has signed up before. The ip address is probably not the best choice as you could have more than one legitimate user with the same ip, also the ip address can be faked or altered very easily if someone wanted to gain access still. When you offer an opened free trial system like this it is very difficult to limit who joins the trial unless it is an invite only situation where you need an access code. Then you can limit who you give the codes out to. Post back with any questions you have and we will be glad to help point you in the rite direction.