Send bulk email from SQL Server 2008
- by dbnewbie
Hi,
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!