While Microsoft Outlook itself includes no search and replace functions, you can use a grouped List view to help update a group of items. This example updates Contact items to a different Company Name, but you can use this technique to update any field other than Categories. (You can use this method to add categories to a contact.)
Using a Group By view
- In Contacts, create a List view grouped by Company Name if you don't already have one.
- Choose View | Expand/Collapse Groups | Collapse All.
- Expand the group that contains the company whose name you want to change.
- Open the first contact in the Group.
- Change the Company Name to the new name.
- Save the contact. It will end up in a new group.
- Collapse the group that you expanded, containing the remaining contacts you want to change.
- Drag the gray bar containing the original company name to the gray bar containing the new company name. If you hover briefly over the new company's group, you'll see a tip pop up, "Change Company Name to" whatever the group's name is.
- Release the left mouse button.
See Tools below for add-ins which can do a search and replace.
Using in-cell editing
Although not a true global search and replace, you can use in-cell editing to edit individual contacts while in a list view. In-cell editing is typically enabled by default and you just need to click in the Contact's field (cell) to edit it. If in-cell editing is not enabled, enable in-cell editing in View Settings, Other Settings (View ribbon) or using the Customize Current view on the View menu in older versions. You can also right click on the row of field names and choose Custom (or View Settings in Outlook 2010 and up) then Other Settings.
This procedure can be used for other fields as well. Right mouse drag will give you more options.
If you need more flexible search and replace, try exporting from Outlook to a comma-delimited file. Open the file in Excel, and perform the search and replace there. Then re-import it into Outlook.
If you use this method to try to change the Category field, the new value is added to the categories for the items. It does not replace the category. Instead of using the grouped technique, try selecting the items you want to change, then right-clicking them and choosing Categories.
Tools in the Spotlight
MAPILab Toolbox is a collection of 18 different add-ins for Outlook. You can use all or only necessary add-ins from the list. Schedule message sending; access files from your computer through email; autofill message fields upon creation; plan the quantity of messages to be sent within a specified time-frame; get reminders from Outlook via SMS; manage your mailing lists, contacts and conversation; redirect your messages and more. works with Outlook 2000-2007. Version 3.2
Easily update many contacts, appointments or tasks with this handy tool. Perfect for updating contacts after an area code split, or companies change names, even when a group of tasks must have all their due dates updated.
- Outlook Company Updater -- custom form
- OL2002 How to Programmatically Update Company Names -- via VBA