auto generate emails based on date

[montyy]

Hi there:
I am using CCS,PHP, and MySQL.

Example:
I have a site with many users, based on UserID.
I have a editable grid that the user can in put there own data.
There is a date colum , so when the user sets the date, is it possible to send a email to the user from that date..

and also there is a list box, which comes from a table in the database, which has , Day,Month,Year.
so for example:
If the user selects a date and selects for example ,Month, I what them to recive an email .

Its like a reminder to the user,

my database has many tables, is it possible to make a list from more than one table?
 

thank you.. for anyone who can help..
Troy..

[montyy]

i am reading through the user selection help, i am thinking this could be the solution

[DW]

It sounds like you're doing some very complex operations.  I am not sure if all or any are possible or easy to do with ListMail.

There is a date colum , so when the user sets the date, is it possible to send a email to the user from that date..

This would be somewhat difficult.  Currently, it is possible only to schedule an email to a list or a 'user selection'.  What it would take to do this is to have a  custom script run just before dailymail each day.  The script would need to create a new user selection selecting just the one user and set up a scheduled email to the selection.  Eventually, your ListMail would become filled with user selections for individual users, so this would not be a very efficient method of doing it.  You might have/want to wait until sending to individuals is implemented into send email and the scheduler.

my database has many tables, is it possible to make a list from more than one table?

ListMail can only access it's own tables of users.  If you use the MySQL method to import users you can import more than one table into a single list with duplicates and bad email addresses being filtered out.

Regards