Use the String Replace Formula in MassImpact to quickly update email domains on contacts and leads for a company that has gone through a domain change.
Example: XYZ Manufacturing recently changed their email domain from @xyzmanufacturing.com to @xyz.com. All contacts that currently have the old domain need to be updated.
Step 1: Select the MassImpact module and choose Contacts as the object to change. (Select Email Address and Account Name as fields to show in your results grid.)
Step 2: Use conditions to only pull down records where email address contains the value @xyzmanufacturing.com (e.g., email contains @xyzmanufacturing.com)
Step 3: Select 'email' as the field to update and in the formula tab select to apply the String Replace formula on the email field. Here is a sample of what a domain change String Replace formula might look like:
StringReplace( {email} , "@xyzmanufacturing.com", "@xyz.com")
See screen shot below for a visual. More information on MassImpact formulas can be found here.
Step 4: Review results and process. Note: This is just an example. Users testing this function should update conditions and formulas to meet their data needs and thoroughly review results prior to processing.
Need MassImpact training? View a previously recorded session.
