ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: cshaul on October 23, 2006, 03:34:02 pm

Title: Daily Sql based message
Post by: cshaul on October 23, 2006, 03:34:02 pm

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

Title: Daily Sql based message
Post by: DW on October 26, 2006, 12:00:30 am

Hi Chris,

Quote

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.

Quote

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