Updating and Editing Multiple Records in Microsoft Dynamics CRM 4.0

Tips & Tricks


This is one of those handy features that still seems to get overlooked in Microsoft Dynamics CRM 4.0.

The situation is normally that a user needs to change one piece of data within several records. Maybe you have a dozen Contacts whose phone number all changed to (312) 555-1212. Updating the records individually would be time consuming.

To bulk edit/update multiple records:

  1. Select the entity/record type you would like to update (e.g. Accounts, Contacts, etc). Records can be updated from the main menu area (e.g. the Accounts list), from within a record (e.g. the Contacts list within an Account), or through Advanced Find. 
  2. Select the records you would like to update.  To highlight a list of records, hold the Shift keyboard key and click the start and end records. To highlight specific records, hold the Ctrl key and click the desired records.
  3. On the Actions menu click “More Actions” and select “Edit”
  4. On the Edit Multiple Records window that opens, enter the data you would like to change. This will add or update that data on all of the records you have selected.
  5. Click “Save”.
Updating and Editing Multiple Records in Microsoft Dynamics CRM 4.0
Updating and Editing Multiple Records in Microsoft Dynamics CRM 4.0
Updating and Editing Multiple Records in Microsoft Dynamics CRM 4.0, 5.0 out of 5 based on 1 rating
  • Share/Bookmark
4 Comments

4 Comments

  1. LoLoSea  •  Dec 3, 2008 @11:48 am

    Thanks for the post. I would love to be able to use this feature to update a group of opportunities from Open status to Closed status, but the field is greyed out. Have you been able to successfully use this feature for that purpose?

  2. Paul Velgos  •  Jan 22, 2009 @8:59 am

    If you’re referring to one of the fields on the Opportunity form, you should be able to do a bulk update. If you’re referring to the “Close Opportunity” function from the actions menu this could be done through workflow but there’s no user-based option for doing this. A company named c360 also makes a bulk update add-on but I haven’t tested it specifically for what you’re asking about.

  3. Sian Cameron  •  Feb 24, 2009 @10:07 pm

    Hi There,
    Thanks for the post, I want to be able to change the “Parent Account” for multiple contacts using the “Edit” selection. Do you know if this is possible ?

  4. Paul Velgos  •  Feb 25, 2009 @10:29 am

    Not using the edit function. Parent Customer is read-only. Other than workflow, if you need a user-based option for doing this I’d suggest looking at c360’s Record Editor

Leave a Reply

Allowed tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>