I'm creating a "jobs by email" mailshot for our company and am investigating moving to MailChimp from our current marketing provider. We have a database containing locations, keywords and email addresses of people subscribed and run a script to match jobs recently added to our website to an email address. This generates an HTML table which is bespoke to each email address.
What I now want to do is import this section of bespoke HTML into a generic campaign so it looks something along the lines of
Generic email stuff
Here are your latest jobs
Job Title Location Salary Apply
Bespoke title1 Bespoke Location1 Bespoke Salary1 Link1
Bespoke title2 Bespoke Location2 Bespoke Salary2 Link2
Bespoke title3 Bespoke Location3 Bespoke Salary3 Link3
More generic email stuff
How can I go about doing this?
Best Answer
It could be done in straight MailChimp, but it wouldn't be pretty.
Basically, you would need to generate a large text file with each user's bespoke html results wrapped in
*|IF:EMAIL=user_x@email.com|* <!-- user_x content --> *|END:IF|*
conditional merge tags. This would get unwieldy in a hurry.Better for this would be to use the Mandrill service, where you would build your template in MailChimp with dynamic fields to hold your bespoke content, then use the Mandrill API to send individual emails to your subscribers either one by one or in batches.