Using MS Access or SQL Server to create birthday emails

[DeborahS16023]

We have lists of members with their birthdays and would like to send birthday wishes.  Not seeing this function in ConstantContact, I think we could code this in MS Access or T-SQL but need to know how to pass the recipient name to ConstantContact.  

[DaveBerard]

We don't offer a built in birthday email feature, as you mentioned.  You have a few options available to you:

• Export your email list monthly/weekly/daily for whever the birthdays are you want to schedule, import that list and send out a email manually for those people.
• Build an integration that does this importing for you using our public API.  Continue to manually create and send the email campaigns.
• Bulk an even more robust integration that also creates the email campaign and schedules it for you using our public API.