Answers.Body: <p>You can do a contact search for contacts with that email adress ending, and then bulk update with profile. And then manually copy/paste the correct ending on all 80 emails, before saving.</p>
  <p>It takes more time than the SQL, but on the other hand you do it in the UI and have full control of the result without having to do extensive testing (which you should do when using SQL-commands pasted from online)</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-06-10T08:11:19.400Z
Answers.Text: This is in fact what I ended up doing. With not many contacts involved it was workable. Clunky, but workable.
Answers.UserDisplayName: Graham
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-06-08T19:38:41.837Z
Answers.LastActivityDate: 2021-06-08T19:38:41.837Z
Answers.UserDisplayName: Flying
Answers.Body: <p>You could export the above 80 with their Contact ID, then do a find/replace in a s/sheet, then reimport them using 'update' and match on Contact ID</p>
  <p>(hmm having written this i now wonder if it would overwrite the existing email address or just add another one. will leave this here for now but delete if someone points out i am wrong)</p>
  <p>As Alan says below &quot;Using <a href="https://civicrm.org/extensions/api-csv-import-gui" rel="nofollow noreferrer">civicrm.org/extensions/api-csv-import-gui</a> [you can work] directly with the email entities&quot;</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-06-08T20:06:58.627Z
Answers.Text: This would also require same amount of testing as the SQL solution
Answers.UserDisplayName: Flying
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-06-09T00:34:53.227Z
Answers.Text: I think for a non-technical user this has a lower threshold for usage than the SQL hence putting it up as an option.
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-06-09T14:22:10.717Z
Answers.Text: I like this one the best! Using https://civicrm.org/extensions/api-csv-import-gui and working directly with the email entities would make this process a bit more bulletproof.
Answers.UserDisplayName: Alan Dixon
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-06-08T19:58:55.173Z
Answers.LastActivityDate: 2021-07-02T16:58:35.387Z
Answers.LastEditDate: 2021-07-02T16:58:35.387Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>Run a sql query on mysql table</p>
  <pre><code>UPDATE civicrm_email
  SET email = REPLACE(email, '@old-domain.org', '@new-domain.org')
  WHERE email LIKE '%@old-domain.org';
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-06-08T12:12:37.070Z
Answers.Text: That's really helpful, as I struggle with MySQL syntax. This sort of functionality would be great to have in the UI.
Answers.UserDisplayName: Graham
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-06-07T11:35:31.803Z
Answers.LastActivityDate: 2021-06-07T11:35:31.803Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>I've got about 80 records in my database for contacts who all work for an important organisation that we liaise with. They've just changed their email domain, but all of the front part of their email addresses don't change, e.g. bob@old-domain.org is now bob@new-domain.org.</p>
  <p>What's the simplest way to update all 80 addresses in CiviCRM?</p>
  
Tags: <contacts>
Title: How to bulk modify email addresses as a result of re-brand?
ThreadText: # How to bulk modify email addresses as a result of re-brand?
  
  (Asked by: username_0 on 2021-06-07)
  
  I've got about 80 records in my database for contacts who all work for an important organisation that we liaise with. They've just changed their email domain, but all of the front part of their email addresses don't change, e.g. bob@old-domain.org is now bob@new-domain.org.
  
  What's the simplest way to update all 80 addresses in CiviCRM?
  
  **Tags:** contacts
  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_4 on 2021-06-07. Score: 5 | Accepted answer
  
  Run a sql query on mysql table
  
  ```
  UPDATE civicrm_email
  SET email = REPLACE(email, '@old-domain.org', '@new-domain.org')
  WHERE email LIKE '%@old-domain.org';
  
  ```
  
  > **Comments:**
  > **username_0**: That's really helpful, as I struggle with MySQL syntax. This sort of functionality would be great to have in the UI.  
  
  ---
  
  ### Answer by username_1 on 2021-06-08. Score: 5
  
  You can do a contact search for contacts with that email adress ending, and then bulk update with profile. And then manually copy/paste the correct ending on all 80 emails, before saving.
  
  It takes more time than the SQL, but on the other hand you do it in the UI and have full control of the result without having to do extensive testing (which you should do when using SQL-commands pasted from online)
  
  > **Comments:**
  > **username_0**: This is in fact what I ended up doing. With not many contacts involved it was workable. Clunky, but workable.  
  
  ---
  
  ### Answer by username_2 on 2021-06-08. Score: 3
  
  You could export the above 80 with their Contact ID, then do a find/replace in a s/sheet, then reimport them using 'update' and match on Contact ID
  
  (hmm having written this i now wonder if it would overwrite the existing email address or just add another one. will leave this here for now but delete if someone points out i am wrong)
  
  As username_3 says below "Using [civicrm.org/extensions/api-csv-import-gui](https://civicrm.org/extensions/api-csv-import-gui) [you can work] directly with the email entities"
  
  > **Comments:**
  > **username_1**: This would also require same amount of testing as the SQL solution  
  > **username_2**: I think for a non-technical user this has a lower threshold for usage than the SQL hence putting it up as an option.  
  > **username_3**: I like this one the best! Using https://civicrm.org/extensions/api-csv-import-gui and working directly with the email entities would make this process a bit more bulletproof.  
  
  ---
  
  