We need to automate a daily email that we send to 400 subscribers. This email is sent every day at 9 am PST. Each daily email is sent using the same recurring template, and it includes 8 changeable fields (7 text and one image). We currently use [login to view URL] to deliver these emails, but this requires a lot of manual entry.
We would like to have a special database developed with a web-based front end. It will be capable of storing hundreds of these records that each contain the different data for the 8 fields noted above. The web-based entry system will allow easy changes and edits of the data.
Each day one of these records will be set to export into our Mailchimp account and populate the 8 fields in a standard Mailchimp template. Mailchimp will then be set to automatically send that message and we will have all of the standard delivery statistics their software offers.
You will need to study the Mailchimp API to determine implementation. Please advise if this is a project you can handle.