Send bulk email from SQL Server 2008

Question

I am relatively new to databases,so please forgive me if my query sounds trivial. I need to send bulk email to all the contacts listed in a particular table. The body of the email is stored in a .doc file which begins as Dear Mr. _______. The SQL server will read this file, append the last name of the contact in the blank space and send it to the corresponding email address for that last name. Any thoughts on how to proceed with this?

Any insights,suggestions,tips will be greatly appreciated.

Thanks!

Answer 1

Database = data base. Storage of data. Please dont make your poor database send out thousands of emails. This is not waht it is made for.

Write an application that does this. Multi threaded. Using data from the database and storing results / status there.