Setting Email Sender for all messages to a generic address

This is a way to workaround a mail server blocking emails where the sender and mail server domain do not match.

Before you do this, make sure you have a working backup copy of your database!
First step: make sure the admin email address is set to the generic address you want to use.

You can do this on the database by running this SQL update query:
update PPS_CONFIG set VALUE = ‘genericaddress@mailserverdomain.com’ where NAME=’config-system-email';

Next switch on the feature to send emails from this address:
insert into PPS_ACCOUNT_FEATURES (ACCOUNT_ID, FEATURE_ID, DATE_BEGIN, DATE_END, RECORDCREATED)
values (7, 84, GETUTCDATE(), ‘3000-01-01 00:00:00.000′, GETUTCDATE());

After setting this, emails should be sent in the format:

“genericaddress@mailserverdomain.com on behalf of user@othermailserver.com”

Comments are closed.