Custom Format for DB Mail

There can be several requirements that can come through regarding HTML email. One of the recent requirements from one of our user required use of different font style, borders, slogan, images etc [More]

Tags: , , ,

SQL Server

Send Image in Email Body via Database Mail

Certain Business requirements may involve sending database mail that incorporates company's logo, and other formatting things like thick border, particular font etc...Below article describes how this can be done using Database Mail. [More]

Send Email to Multiple Recipient using msdb.dbo.sp_send_dbmail

While using msdb.dbo.sp_send_dbmail for sending email, we realize that @receipients parameter takes up only one email address, unless that email address is not pinting to a distribution list all receipient cannot get email. In case we want to accomplish sending email to multiple receipient we can do following: [More]

Send HTML Formatted Email Using Database Mail

When using database mail, it may be required to send email that is well formatted. Sometimes, we might want to send formatted data with proper header in the email. Below example describes as how we can send such email with table data in email body. For information on how to set up database mail refer to my earlier post here. [More]

Tags: , , , , ,

SQL Server | SQL Tricks

DataBase Mail

There are times when we want to send email using SQL server after a job has been accomplished. For instance, in a company every month on a certain date and time updates are to be made via web service and once that is accomplished a notification is sent to Database administrator. [More]

Tags: ,

SQL Server | SQL Tricks