Skip to main content The new Salesforce certifications experience is live! Visit Trailhead Academy to explore your new certifications homepage.
Is there a way to do a mass Address Standardization?  (Not the Mass Address Update as that only does state and Country.)

 

On each Acct, Contact, etc, is a button to run Address Standardization.  But with so many being added, I don't want to have to touch each record individually.

 

Thanks for your suggestions and thoughts.

 

Rhonda
1 answer
  1. Feb 4, 2012, 10:56 AM
    Hi Rhonda,

     

    Generally address standardisation is enforced through validation rules, preventing users from entering in ways that don't meed the organisation standard. So that should help you to prevent the situation getting worse but doesn't solve the problem with the existing records.

     

    To clean your existing data there are plenty of 3rd party tools that will help you to do this (check the Appexchange) or alternatively consider exporting the data and "cleaning" in excel or a similar tool then batch update the records.
0/9000