SQL 2005 Database Mail - Format Question 1

[EriRobert]

Hi

Is it possible to change the default font and font size settings for emails sent using 'Database Mail' with 'Text' as the value for the @body_format parameter.

Many Thanks

 

[mrdenny]

No, text emails use the receivers default font. You'll have to use HTML if you want to change the font size.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[EriRobert]

Thanks Denny

 

[EriRobert]

One more question - Where is this receivers default font defined?

Thanks

 

[mrdenny]

It's defined per application. In notepad click on Format / Font. In Outlook it'll be in the options somewhere.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog