Group items tagged

How to configure SQL 2005 Database Mail sp_send_dbmail

How to configure SQL 2005 Database Mail sp_send_dbmail

The Mail workflow action extends the standard Sitecore email action which is included with the default installation. It is distributed as a standard Sitecore package. The package includes the actual template for this action (the Extended email action), which inherits from the Sitecore Standard template. The extended email action template contains the following fields, grouped in the Parameters section: To - the recipient's email address; From - the sender's email address; Subject - the subject of the email (allows using Velocity templates); Message - the body of the email (allows using Velocity templates); Mail server - the email server you'd like to use for sending emails; *Type - (the same as the Type field of the Sitecore Action template).

"' Set the mail server configuration Set objConfig=CreateObject("CDO.Configuration") objConfig.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing")=2 objConfig.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver")="localhost" objConfig.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25 objConfig.Fields.Update Set objMail=CreateObject("CDO.Message") Set objMail.Configuration=objConfig objMail.From = fromemail objMail.To = toemail objMail.Subject = "Test Email" objMail.TextBody = "Test Email" objMail.Send"

"For the best HTML e-mail delivery results, CSS should be inline. This is a huge pain and a simple newsletter becomes un-managable very quickly. This script is our solution. "

This website and its sample code creates a template of sorts, absent of design or layout, that will help you avoid some of the major rendering problems with the most common email clients out there - Gmail, Outlook, Yahoo Mail, etc. While not plug and play (you know, you'll have to do some work ;-), it will provide some helpful examples and snippets that will keep your email design rendering as true-to-form as possible.

ELMAH (Error Logging Modules and Handlers) is an application-wide error logging facility that is completely pluggable. It can be dynamically added to a running ASP.NET web application, or even all ASP.NET web applications on a machine, without any need for re-compilation or re-deployment.