Daily Sql based message

[cshaul]

Hi,

Is it possible, to send a daily email to a list that is a query from a mysql table?  I want to populate a year's worth of daily information into a database and then send the daily info to people on the list.  

How might I accomplish this?  I looked at the custom fields and didn't see how I might do this.

Thanks,

Chris

[DW]

Hi Chris,

Is it possible, to send a daily email to a list that is a query from a mysql table? I want to populate a year's worth of daily information into a database and then send the daily info to people on the list.

Could you use followups for this?  A simple custom script could insert 365 followups, sent each day starting from when the user subscribes.  The date on each message could be 'personalized' to the current date with a message code. Or are you wanting to 'schedule' individual email for particular days, which would allow for specialized holiday mailings, etc.?  Each of these could be accomplished with a custom script.  I could help out for about $40.

How might I accomplish this? I looked at the custom fields and didn't see how I might do this.

Custom fields are for storing individual data for a user beyond first name, last name and email address.  You can use the values in these fields with the 'User Selection' feature to facilitate sending to parts of your list(s).  I think this is a separate issue from the sending of messages.

Regards