can MailChimp send emails based on values in my database?

[David]

SITUATION - I have a database table with the following fields: [email]
[date_time] [subject] [message]

QUESTION - Is it possible to use MailChimp's API to send an email to
[email] at [date_time] with the subject = [subject] and message
content = [message]?

If so, what would be the best approach?

Thanks much,

David

[jesse]

Possibly, though that's not what we're setup for, so it's not as
straightforward as you may like.

The subject and message would be merge tags on your list. If the
message is over 255 characters, you'd need to chain together multiple
merge tags and split your content across them. You can have a max of
30, which could be a deal breaker if your content is larger than that.
You'd need to have a process on your side handle adding the subscriber
records and performing the send at the specified times using our
psuedo-transactional campaign.

Using Merge Tags: http://eepurl.com/f-M2
Psuedo transactional campaigns - http://www.mailchimp.com/api/examples/transactional-campaigns.php

The only other option would be to create a campaign with a
segmentation rule for the recipient and schedule it. That will not
allow stats to collect under one campaign and will likely junk up your
campaigns list quickly, even if you do use folders.
Segmentation - http://eepurl.com/f-Nh

jesse