We would like to send our customers e-mail adverts from our new products every now and then. Our product data is available in one of our databases and the e-mail will be sent using MailChimp (which let's us to store the target email addresses on their server). All we need is the templates designed and generated for every type of e-mail/campaign.
The problem is, MailChimp's online editor would require a lot's of manual effort from us to always manually replace some parts of the template, like switching the products name or the image. However using MailChimp's API it is possible to upload a complete HTML e-mail, so if we had some kind of desktop application, where we design the e-mails and generate new ones, we could integrate it with MailChip in the end.
User designs a template (with variables, like {{product.name}}
) --> Software let's us generate the resulting e-mails using our data (from different sources, mainly SQL) --> Either we manually upload the template or make a simple service which uploads the htmls to MailChimp. --> MailChimp sends the e-mails to users we registered in some other way.
The software would be used by non-programmers, so It should be some kind of editor, like the old HTML editors (Adobe Dreamweaver), but with strong e-mail templating/generating capabilities.
Thank you for your suggestions!
Feel free to suggest me different approaches of services.