Overview
Lists with Default From set to "login" in Utilities > List Settings > Web Created Content cause your mailings to go out with your Administrator's email address and for security purposes you want to use a different email address. You have 100s of Lists that need to be changed and you don't want to change the Administrator's account settings and email address so you need to change this in the database with a query.
Information
Constructing custom SQL queries is outside the scope of Support. However, the information in this section can be used to develop an update query to change the Default From for many Lists at once. The 'lists_' table stores the email address that is used for sending from a list in the DefaultFrom_ field. For additional field information see the Summary of the "lists_" fields in ListManager.
| Field | Description |
| DefaultFrom_ | The 'from' value that should be used as a default for this list. (varchar(200), NULL) Must be a valid email address. |
Priyanka Bhotika
Comments