Customer default Email Format Pref HTML

[solo_400]

God bless you my friend !

[powerzone]

Can anyone tell me if there is a way to bulk update all customers Email Format Pref to HTML as I never had this set as the default ( but now do) and want to sent all my emails in HTML format. I don't want to have to go into each individual record and update this individually as I have quite a few customers. Can anyone help me with this?
Steve

[transmobius]

Yes, updating the entire list of customers would be helpful. Anyone?

[stilarsen]

Anyone have come up with an good solution yet?

[schoolboy]

Can be done with a SQL patch...

... BUT...

Don't "assume" all customers want html emails. Many DO NOT.

It may even be against the law to alter this from the cutomer's initial preference.

Also, many companies configure their mail server to block HTML formatted mail.

best you can do is send your customers an email indicating that HTML emails are now possible, and if they want them, they can change the setting in their MY ACCOUNT area.