Simultaneously edit Business Contact Manager records

You can easily edit the same field in multiple Account or Business Contact records with Bulk Edit. You can also bulk edit Opportunity and Business Project records with just a few clicks.

Bulk editing is useful if, for example, you want to assign a large group of Accounts to a new employee in your company, or update many records with information in a custom field that you created. You can also remove data from records using Bulk Edit.

Important    Bulk edits cannot be undone.

This article covers the various ways in which you can bulk edit records, and the limitations of the Bulk Edit feature.

In this article

Edit multiple records with Bulk Edit

What types of records can be bulk edited?

What information can’t be bulk edited?

Edit multiple records with Bulk Edit

You can edit many records and many types of fields using Bulk Edit, including your own custom records and user-defined fields.

If a field is editable, and if it can appear on the record type that you are editing, it is available for updates in the Bulk Edit dialog box. Just select the field, enter the information that you want, and then click OK.

Although you can't remove a field from a record with Bulk Edit, you can use it to delete the data entered in the field.

You can update only one field at a time using Bulk Edit.

Note    Not all fields that you can bulk edit will appear on each record. For example, the sample business database includes a custom field, Estimated Lead Value, on the Lead form. The field is also listed in the Bulk Edit dialog box when you have selected Business Contacts, because the Lead form is based on a Business Contact record.

For information about custom records or how to add or remove fields from a form, see Create and customize record types and lists.

Top of Page

In this section

Add, edit, or remove data in multiple records

Cancel a bulk edit

Add, edit, or remove data in multiple records

To edit a field in several records, you can choose a default data field, or you can choose a user-defined field.

  1. In the Navigation Pane, under Business Contact Manager, click one of the following folders to display the workspace:

Contact Management.

Sales.

Marketing.

Project Management.

  1. Click the tab that contains the records that you want to edit.

  2. Click the records that you want to edit.

    How do I select more than one record?

    To select records that are adjacent to each other, press the SHIFT key, and then click the first and last records of the group that you want to add. To select nonadjacent records, press the CTRL key, and then click the individual records. To select all records, click one, and then press CTRL+A.

  3. On the Ribbon, on the Home tab, in the Edit group, click Bulk Edit.

    bulk edit button on Ribbon

    Tip    You can also right-click the selected records, and then click Bulk Edit.

  4. In the Select the field box, click the field that you want to edit. The Bulk Edit dialog box lists all the editable fields that can appear on the form, including any user-defined fields. The fields are displayed in the list as User-defined Fields or Built-in Fields.

    bulk edit window

  5. To add or change data in a field, click the Set option, and then click or type the data that you want in the field for the selected records. If necessary, you can click Edit this list to add the data that you want. For information about how to add an item to a list, see Create and customize record types and lists.

  6. To remove data from a field in the selected records, click Clear the value.

Warning    Use extreme caution. This action cannot be undone except by opening each affected record and re-entering the deleted data. You can cancel a bulk edit that is in progress if you catch it in time, but some records will have been changed.

  1. Click OK to complete the edit, or click Cancel.

Top of Page

Cancel a bulk edit

If you change your mind while a bulk edit is in progress, it may be possible to cancel before all the records have been changed.

Important    If you cancel a bulk edit after it has started, some of the selected records will already be changed. There is no "undo" option. To undo a change that you made using bulk edit, you must open the individual records and manually change each field back to its original value.

  1. In the Applying Bulk Edit dialog box, click Cancel.

  2. Click Yes when prompted to cancel the process and close the dialog box.

Business Contact Manager for Outlook will immediately stop updating the selected records.

Top of Page

What types of records can be bulk edited?

Most of the fields on most of the record types can be edited in bulk. Marketing activities, project tasks, and communication history items cannot be edited in bulk.

In this record type…

You can edit every field except these

Accounts

  • Account name

  • Display as

  • This is the mailing address check box

Business Contacts

  • Full Name

  • File as

  • Display as

  • Business Card

  • This is the mailing address check box

Opportunities

  • Products and Services list

  • Any records with a Sales Stage of Closed Won or Closed Lost

Business Projects

  • No fields are excluded from bulk editing

Top of Page

What information can’t be bulk edited?

The bulk editing feature is quite powerful, but there are some things you cannot use it to edit:

  • Multiple fields    Bulk Edit cannot update multiple fields on the same form at once. However, you can use it to edit multiple fields on the same form sequentially.

  • Calculated fields    Bulk Edit can't directly set any calculated fields, such as the Expected Revenue field on the Opportunity form.

  • Unique fields    Fields that require unique values, such as names or phone numbers are not editable with Bulk Edit.

  • History items    You cannot add new communication history items to records using Bulk Edit.

  • Different record types    Bulk Edit can't change fields across different types of records. For example, you cannot edit the State field in Business Contact and Account records at the same time.

  • Attachments and pictures    Bulk Edit applies only to records, and can't be used for attachments or images.

Top of Page

Applies To: Outlook 2013, Outlook 2010



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language