All geek questions in one place

Create Multiple Encoded HTML / Text T-SQL Emails

For my first question, I have a typical web e-com scenario in which a user can order various products and then receive confirmation letters. I have searched many times for the best way to send emails for this application, and I hope someone can point me in the right direction.

I can send plain text confirming that email messages from an application or database are just fine, but now I want to change the situation by creating a series of HTML templates to use when sending emails. There will be several HTML templates and several email content. When the user makes an order, the order is recorded in the database, which then determines the product type / order through the stored process and selects the corresponding template file name, email content and replaces the entire key text with the user / order information.

At the same time, I would like the letter also to be encoded with a text version, so I can send one email containing both types and do it.

Is it possible to do this in SQL Server 2008 R2 or send content information back to the application and then send an email? The problem I'm worried about is that this may cause some delay on the site as it communicates with the database.

Also, I would like to upgrade to Amazon SES, which is easy to use with .Net, but I have not yet been able to configure SQL 2008 R2, so I'm not sure if this is a bug on my side or a compatibility issue.

Theory: Application: .Net 4.0 Database: SQL 2008 R2

+6
source share
1 answer

The key requirement here is to send HTML and text versions of the message in the same email. SQL Server Database Mail does not support sending multithreaded MIME messages - if you want to do this, you will need to send mail from your application.

Command reference for sp_send_dbmail - note that the @body_format parameter can be either HTML or text - not both.

+6
source

Source: https://habr.com/ru/post/907740/

More articles:


All Articles