Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Send bulk email from SQL Server 2008

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!

like image 749
dbnewbie Avatar asked Dec 05 '22 03:12

dbnewbie


1 Answers

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.

like image 112
TomTom Avatar answered Dec 21 '22 23:12

TomTom