Anyone know of a chunk of code that will send out emails automatically each day?

Our site has a 7-day free trial period and we'd like the system to send out an email to everyone who took advantage of the 7 days at the end of their trial. Since there's a bunch of people signed up, doing it manually is too time-consuming.

Any ideas on how to do this? Obviously, there are fields with subscription expiration dates and email addresses in the database.

Thanks.

Maybe you can buy the Smart Mailer exention from DMXZone, connect the mailer to a database and create a code that counts the difference in days bewteen the date the customer has tried your system and today (now). Via an if, else construction you can send mails only when days = 7 or days > 7