# Is it somehow possible to force HTML format notifications for all users?

**URL:** https://www.finalbuilder.com/forums/t/is-it-somehow-possible-to-force-html-format-notifications-for-all-users/6688
**Category:** Feature Requests
**Tags:** continua-ci
**Created:** [December 26, 2019, 9:40am UTC](https://www.finalbuilder.com/forums/t/is-it-somehow-possible-to-force-html-format-notifications-for-all-users/6688 "2019-12-26T09:40:54Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![ktopaz](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/ktopaz/32/2390_2.png) [@ktopaz](https://www.finalbuilder.com/forums/u/ktopaz)
#### Post date: [December 26, 2019, 9:40am UTC](https://www.finalbuilder.com/forums/t/is-it-somehow-possible-to-force-html-format-notifications-for-all-users/6688/1 "2019-12-26T09:40:54Z")

</div>

If this isn’t possible straight forward - can this be added as an option? “Default email format: (plain/html)”

Also - if currently not possible - could you let me know what is the update clause I could possibly use with psql to change this option to HTML for all of my existing users?

---

<div class="post-metadata">

### Author: ![Sparky](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/sparky/32/10_2.png) [@Sparky](https://www.finalbuilder.com/forums/u/Sparky)
#### Post date: [January 6, 2020, 1:09am UTC](https://www.finalbuilder.com/forums/t/is-it-somehow-possible-to-force-html-format-notifications-for-all-users/6688/2 "2020-01-06T01:09:11Z")

</div>

Hi @ktopaz,

There is currently no way to set a default for this option. We will however add this to our to-do list.

You can use the following SQL to set the option to use HTML format for all existing users.

```auto
UPDATE core_usernotificationpreferences 
SET pluginvalue = REPLACE(pluginvalue, '<UseHtmlFormat>false</UseHtmlFormat>', '<UseHtmlFormat>true</UseHtmlFormat>') 
WHERE pluginname = 'Email'  

```

Shutdown the Continua CI Server service before making any updates to the database. Changes will be picked up when the server is restarted. Also ensure that you have an up-to-date database backup in case anything goes wrong.