Change 'from Email' In Email Templates In Bulk

[axiom]

Hello all,

 

We are now trialing blesta and are so far very happy with it.

 

Can anyone suggest an easy easy way to change the domain part in the 'From Email' address in all Email templates in bulk, instead of changing the email templates manually?

 

In my case, all email from addresses are: @billing.company.com

 

and wish to change them all to: @company.com

 

Thank you.

[Tyson]

Please see: How to change all the emails from subdomains?

 

You should update those queries to encapsulate the values in quotes, otherwise running them will generate a syntax error.

UPDATE `emails` SET `from`='billing@domain.com' WHERE `from`='billing@subdomain.domain.com';

[Michael]

Please see: How to change all the emails from subdomains?

[axiom]

Thank you Mike.

[Michael]

Thank you Mike.

 

You're welcome mate

[Michael]

 

You should update those queries to encapsulate the values in quotes, otherwise running them will generate a syntax error.

UPDATE `emails` SET `from`='billing@domain.com' WHERE `from`='billing@subdomain.domain.com';

Ah whoops merci mate.

[Paul]

Nice KB article Mike, I gave it a thumb! 

[Michael]

Nice KB article Mike, I gave it a thumb! 

Merci mate need to keep filling it up