Loading

Salesforce Administration: How to Mass Update User Email Addresses and Usernames Using Data Loader

Publiceringsdatum: Jun 10, 2026
Beskrivning

Salesforce Administrators can mass update user email addresses and usernames in bulk using Salesforce Data Loader. This is useful when:

  • Your company changes its email domain (e.g., from @oldcompany.com to @newcompany.com).
  • You need to update usernames across multiple sandbox environments.
  • You want to make bulk user changes without requiring each user to update their own settings manually.

Example Scenario: A company undergoes a merger and changes its email domain. The Salesforce admin needs to update the email address and username for 300 active users. Using Data Loader, this can be accomplished in a single bulk update operation.
There are three distinct email-related fields on a Salesforce User record that can be updated:

  • Username — The login credential used to access Salesforce. Found under Setup > Manage Users > Users. Must be in email address format and unique across all Salesforce orgs, but does not need to be a real email address.
  • Email Address — The email address used to receive Salesforce notification emails. Found under Setup > Manage Users > Users.
  • Return Email Address (SenderEmail) — The email address that appears as the sender on outbound emails. Found under My Settings > Email > My Email Settings.
Lösning

Step 1: Export User IDs from Salesforce

  1. Log in to Data Loader.
  2. Click Export.
  3. Select the Users object.
  4. Select the fields to export. Include at minimum: Id, Username, Email, and SenderEmail (depending on what you need to update).
  5. Click Finish.

Step 2: Update the Exported CSV File

  1. Open the exported CSV file.
  2. Use the following column naming convention when preparing your update file:
    1. Username → column header: Username
    2. Email Address → column header: Email
    3. Return Email Address → column header: SenderEmail
  3. Update the values in the appropriate columns for each user.
  4. Save the CSV file.

Step 3: Perform the Bulk Update Using Data Loader

  1. Log in to Data Loader.
  2. Click Update.
  3. Select the Users object.
  4. Click Browse and select your updated CSV file. Click Next.
  5. Click Create or Edit a Map and map the columns to the appropriate Salesforce fields.
  6. Click Next and select a location to save the Success and Error output files.
  7. Click Finish.

Expected Behavior After Update

Field UpdatedWhat Happens
UsernameUpdated immediately. User receives an email notification of the change.
Email AddressA confirmation email is sent to the new address. The field is not updated until the new address owner confirms. An email is also sent to the old address.
Return Email Address (SenderEmail)A confirmation email is sent to the new address. The field is not updated until confirmed.
Note: To remove the email confirmation step for Email Address and SenderEmail updates, request the backend feature Disable Email Change Verification to be enabled for your org.
Note: If there is only one System Administrator user in the organization and you need to change their email, see Unable to change your Salesforce System Administrator.
Knowledge-artikelnummer

000387708

 
Laddar
Salesforce Help | Article