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 stuffHere are your latest jobsJob Title                   Location             Salary            ApplyBespoke title1              Bespoke Location1    Bespoke Salary1   Link1Bespoke title2              Bespoke Location2    Bespoke Salary2   Link2Bespoke title3              Bespoke Location3    Bespoke Salary3   Link3More generic email stuffHow can I go about doing this?
Mailchimp dynamic content
mailchimp
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.