When your data is consistent, your reports and related metrics are more accurate and
easier to understand. For example, having different abbreviations for a country/territory or state
can skew your data. To make your addresses consistent, you can update country/territory and
state/province information in existing fields at one time.
Required Editions
Available in: both Salesforce Classic and
Lightning Experience
Available in: All Editions except for Database.com.
User Permissions Needed
To mass update addresses:
Modify All Data
To mass update addresses of contracts:
Modify All Data
AND
Activate Contracts
You can mass update addresses in contacts, contracts, and leads.
Tip To ensure data consistency in new records, consider using state and
country/territory picklists. Mass Update works with standard address fields, but doesn’t change
Custom Address Fields.
From Setup, enter Mass Update Addresses in the Quick
Find box, then select Mass Update Addresses.
Select Countries or State/Province. If you
chose State/Province, enter the country or territory in which to update the state or province.
Click Next.
Select the values to update and click Add.
The Selected Values box displays the values to update.
The Available Values box displays the address values found in
existing records. To find more addresses to update, enter all or part of a value and click
Find.
If your organization has large amounts of data, instead of
using the Available Values box, enter existing values to update in the text area. Separate
each value with a new line.
In the Replace selected values with field, enter the value with which
to replace the specified address data, and click Next. If your
organization has large amounts of data, this field is called Replace entered values
with.
The number and type of address records to update are displayed. If you have
large amounts of data, only the values to update are displayed.
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required Cookies
Always Active
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional Cookies
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising Cookies
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.
