Saturday, February 25, 2012

Managing Customer Email Communications via SQL Server

What is the best way for an internet business to manage its email

correspondence with all it customers, given that all customer data

including their email addresses is stored in a SQL Server 2005 table.

Is there a good way for Outlook (for example) to keep an address book

synchronized with a field in the database?

You can connect to sqlserver from outlook via VBA. So, it's just a matter of query the data and update outlook.

Here is outlook vba reference.

http://www.microsoft.com/downloads/details.aspx?familyid=A1CEAD80-23E2-456F-8618-4DA50CC2C38C&displaylang=en

No comments:

Post a Comment