Solved

HTML Conditional Formatting dbmail

Posted on 2009-05-04
7
549 Views
Last Modified: 2012-05-06
I have a stored proc on sql 2005 server that sends out emails in html format.  It gets its data from a database view on the same server.  Everything currently works great and all emails get sent, however I would like to put some of the fields that it retrieves from my view in red if a condition is met.  

How can this be done?
0
Comment
Question by:H-SC
  • 4
  • 3
7 Comments
 
LVL 41

Expert Comment

by:ralmada
ID: 24295264
0
 
LVL 41

Expert Comment

by:ralmada
ID: 24295287
And for conditional formatting, check this other one:
http://www.arstdesign.com/articles/avs/conditionalformatting.html
 
0
 
LVL 1

Author Comment

by:H-SC
ID: 24295302
ralmada,

I currently have the email formated as html ad is working great.  I need to conditionally format that html to have the text be red if a condition is met on the field that gets pulled from the view.
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 1

Author Comment

by:H-SC
ID: 24295321
ok, just got your last posting after I posted my reply.  I will take a look at the link...
0
 
LVL 41

Accepted Solution

by:
ralmada earned 500 total points
ID: 24295358
0
 
LVL 1

Author Comment

by:H-SC
ID: 24295459
ralmada,

I am going to go with the last one....  Many thanks for your help with this one.
0
 
LVL 1

Author Comment

by:H-SC
ID: 24296209
ralmada,
Applied the code from the last site that you sent and worked perfect!  thanks for sending me in the right direction
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now