Receive multiple email address change emails when mass updating User records using a CSV file that contains an incorrectly formatted username
Last updated 2022-02-10 ·Reference W-3248522 ·Reported By 14 users
Summary
When mass updating User email addresses using a CSV file that contains at least one incorrectly formatted username value (such as onetest.com instead of one@test.com), three identical notification emails will be sent to both the previous and new email addresses of Users whose email addresses are changed.
Repro
1- In a test org create three Users (A, B, and C) and set each User’s email address to your own address.
2- Manually create or export a CSV file for those three Users with the following columns:
ID, Username, Email
3- Edit the CSV in line with the following:
 - User A – change email address to your alternate email address
 - User B – leave as-is
 - User C – remove @ symbol from username
4- Save CSV file.
5- Using Workbench, Data Loader, or any other bulk tool, update the three User records using the edited CSV file.
6- Observe the following:
 - User C’s row will fail with the error ‘Username must be in the form of an email address (for example, john@acme.com): Username’
 - You will receive three emails notifying you of User A’s email change, to both the old and new email addresses (6 emails in total).
 - You will receive no emails on User B’s behalf.
7- If you correct User C’s username in the CSV file and repeat step 5, you will only receive one email each for User A’s email address change.
Workaround
Ensure that all email addresses in the CSV file are correctly formatted before mass updating User records.
Update 11/21/2016: Please be aware, we have noticed that this behavior can also manifest if your CSV file includes an update to usernames that would result in duplicate usernames. The update will for this duplicate username will return in error, but those users that had their emails correctly update will receive multiple confirmations via email.
Is it Fixed?
Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.