I need a VB.NET windows application that reads a table from a MS SQL Server 5 Database.
The table is called "emails"
The Fields are:
email, user_name, list_name, email_message
The program needs to read the table and for each record do the following using the MailChimp API (found at [url removed, login to view])
1. check if user_name exists in the specified list_name on mailchimp.
2. if user_name does NOT exist, add the user to that list_name on mailchimp
3. if user_name exists (or program just created it), send the contents of email_message to that user via mailchimp.
At any point if mailchimp throws any errors, they need to be logged in a file.