• Outlook User
  • New Outlook app
  • Outlook.com
  • Outlook Mac
  • Outlook & iCloud
  • Developer
  • Microsoft 365 Admin
    • Common Problems
    • Microsoft 365
    • Outlook BCM
    • Utilities & Addins

How to perform a global search and replace

Slipstick Systems

› Outlook › How to perform a global search and replace

Last reviewed on September 16, 2019     9 Comments

Applies to: Outlook (classic), Outlook 2007, Outlook 2010

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.)

Notes | Tools | More Information

Using a Group By view

  1. In Contacts, create a List view grouped by Company Name if you don't already have one.
  2. Choose View | Expand/Collapse Groups | Collapse All.
  3. Expand the group that contains the company whose name you want to change.
  4. Open the first contact in the Group.
  5. Change the Company Name to the new name.
  6. Save the contact. It will end up in a new group.
  7. Collapse the group that you expanded, containing the remaining contacts you want to change.
  8. 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.
    Drag to a new category to do a global replace
  9. 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.

Notes

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

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

Tools

Global Search and Replace

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.

More Information

Alternative methods:

  • Outlook Company Updater -- custom form
  • OL2002 How to Programmatically Update Company Names -- via VBA
How to perform a global search and replace was last modified: September 16th, 2019 by Diane Poremsky

Related Posts:

  • Contacts are Grouping in Two Groups of (none)
  • Updating Outlook Fields the Easy Way
  • Keep Outlook from putting the wrong country in new addresses
  • click in the column to enable
    How to quickly change the values in Outlook fields

About Diane Poremsky

A Microsoft Outlook Most Valuable Professional (MVP) since 1999, Diane is the author of several books, including Outlook 2013 Absolute Beginners Book. She also created video training CDs and online training classes for Microsoft Outlook. You can find her helping people online in Outlook Forums as well as in the Microsoft Answers and TechNet forums.

Subscribe
Notify of
9 Comments
newest
oldest most voted
Inline Feedbacks
View all comments

Phil Reinemann
August 17, 2017 6:47 pm

Diane, how does one "create a table view grouped by Company Name" in Outlook 2016?

I've created groups in Outlook 2011 & 2007, but I don't see anything like "table view" in 2016.

0
0
Reply
Diane Poremsky
Author
Reply to  Phil Reinemann
August 17, 2017 11:13 pm

That would be List View in Outlook 2016.

0
0
Reply
Bill leeds
October 18, 2015 7:46 am

Hi Diane, the window that allows me to enter debug, popped up. Message was "object variable or With block variable not set. Thanks again.

0
0
Reply
Bill leeds
October 15, 2015 5:24 am

Hi Diane It ran as far as this If Reg1.test(aItem.Subject) Then
and the it went to the debugger... any ideas??

thanks.

0
0
Reply
Diane Poremsky
Author
Reply to  Bill leeds
October 15, 2015 6:28 am

What is the error message? Stopping there means it is probably failing to find aItem. Do you have a message selected?

0
0
Reply
Bill leeds
October 15, 2015 4:59 am

I'll give it a shot, and thanks for the prompt response. I'm not a 'programmer' but i can figure things out... eventually. Thanks again.

0
0
Reply
Bill Leeds
October 14, 2015 9:04 am

Hi, within outlook inbox are a list of 1000 emails. In the Subject field some emails have a 'string' value and number without a space. others have the string value / space / number.
example SP12345 vs SP 12345 (note the space). What i would like to do is somehow do a global search and replace so I can remove the space between the letters SP and the Number. I believe I will need to write a macro to do this. I was wondering if you have any suggestions or perhaps have seen code that will do this. Any help would be gratefully appreciated.
Thanks

1
-1
Reply
Diane Poremsky
Author
Reply to  Bill Leeds
October 14, 2015 9:45 am

you'll need to use a macro for sure. I would use regex to find (a-zA-Z)* (0-9)* then set it as a string, passing it to replace(strSubject, " ", "")

this shows how to change the subject - https://www.slipstick.com/outlook/email/add-a-file-number-or-keyword-to-the-subject-line-of-messages/ - you just need to change what gets changed.

1
-1
Reply
Diane Poremsky
Author
Reply to  Diane Poremsky
October 14, 2015 10:30 am

the macro here https://onedrive.live.com/redir?resid=92BFE835F50A11F5!904487&authkey=!AGdJC5ejvvYDOm4&ithint=folder%2ctxt works with the selected message and removes the space from a code in the format of 2 capital letters and any number of numbers.

2
-2
Reply

Visit Slipstick Forums.
What's New at Slipstick.com

Latest EMO: Vol. 30 Issue 28

Subscribe to Exchange Messaging Outlook






Support Services

Do you need help setting up Outlook, moving your email to a new computer, migrating or configuring Office 365, or just need some one-on-one assistance?

Our Sponsors

CompanionLink
ReliefJet
  • Popular
  • Latest
  • Week Month All
  • Jetpack plugin with Stats module needs to be enabled.
  • Open Outlook Templates using PowerShell
  • Count and List Folders in Classic Outlook
  • Google Workspace and Outlook with POP Mail
  • Import EML Files into New Outlook
  • Opening PST files in New Outlook
  • New Outlook: Show To, CC, BCC in Replies
  • Insert Word Document into Email using VBA
  • Delete Empty Folders using PowerShell
  • Warn Before Deleting a Contact
  • Classic Outlook is NOT Going Away in 2026
Ajax spinner

Recent Bugs List

Microsoft keeps a running list of issues affecting recently released updates at Fixes or workarounds for recent issues in classic Outlook (Windows).

For new Outlook for Windows: Fixes or workarounds for recent issues in new Outlook for Windows .

Outlook for Mac Recent issues: Fixes or workarounds for recent issues in Outlook for Mac

Outlook.com Recent issues: Fixes or workarounds for recent issues on Outlook.com

Office Update History

Update history for supported Office versions is at Update history for Office

Outlook Suggestions and Feedback

Outlook Feedback covers Outlook as an email client, including Outlook Android, iOS, Mac, and Windows clients, as well as the browser extension (PWA) and Outlook on the web.

Outlook (new) Feedback. Use this for feedback and suggestions for Outlook (new).

Use Outlook.com Feedback for suggestions or feedback about Outlook.com accounts.

Other Microsoft 365 applications and services




New Outlook Articles

Open Outlook Templates using PowerShell

Count and List Folders in Classic Outlook

Google Workspace and Outlook with POP Mail

Import EML Files into New Outlook

Opening PST files in New Outlook

New Outlook: Show To, CC, BCC in Replies

Insert Word Document into Email using VBA

Delete Empty Folders using PowerShell

Warn Before Deleting a Contact

Classic Outlook is NOT Going Away in 2026

Newest Code Samples

Open Outlook Templates using PowerShell

Count and List Folders in Classic Outlook

Insert Word Document into Email using VBA

Warn Before Deleting a Contact

Use PowerShell to Delete Attachments

Remove RE:, FWD:, and Other Prefixes from Subject Line

Change the Mailing Address Using PowerShell

Categorize @Mentioned Messages

Send an Email When You Open Outlook

Delete Old Calendar Events using VBA

Repair PST

Convert an OST to PST

Repair damaged PST file

Repair large PST File

Remove password from PST

Merge Two Data Files

Sync & Share Outlook Data

  • Share Calendar & Contacts
  • Synchronize two computers
  • Sync Calendar and Contacts Using Outlook.com
  • Sync Outlook & Android Devices
  • Sync Google Calendar with Outlook
  • Access Folders in Other Users Mailboxes

Diane Poremsky [Outlook MVP]

Make a donation

Mail Tools

Sending and Retrieval Tools

Mass Mail Tools

Compose Tools

Duplicate Remover Tools

Mail Tools for Outlook

Online Services

Calendar Tools

Schedule Management

Calendar Printing Tools

Calendar Reminder Tools

Calendar Dates & Data

Time and Billing Tools

Meeting Productivity Tools

Duplicate Remover Tools

Productivity

Productivity Tools

Automatic Message Processing Tools

Special Function Automatic Processing Tools

Housekeeping and Message Management

Task Tools

Project and Business Management Tools

Choosing the Folder to Save a Sent Message In

Run Rules on messages after reading

Help & Suggestions

Submit Outlook Feature Requests

Slipstick Support Services

Buy Microsoft 365 Office Software and Services

Visit Slipstick Forums.

What's New at Slipstick.com

Home | Outlook User | Exchange Administrator | Office 365 | Outlook.com | Outlook Developer
Outlook for Mac | Common Problems | Utilities & Addins | Tutorials
Outlook & iCloud Issues | Outlook Apps
EMO Archives | About Slipstick | Slipstick Forums
Submit New or Updated Outlook and Exchange Server Utilities

Send comments using our Feedback page
Copyright © 2025 Slipstick Systems. All rights reserved.
Slipstick Systems is not affiliated with Microsoft Corporation.

:wpds_smile::wpds_grin::wpds_wink::wpds_mrgreen::wpds_neutral::wpds_twisted::wpds_arrow::wpds_shock::wpds_unamused::wpds_cool::wpds_evil::wpds_oops::wpds_razz::wpds_roll::wpds_cry::wpds_eek::wpds_lol::wpds_mad::wpds_sad::wpds_exclamation::wpds_question::wpds_idea::wpds_hmm::wpds_beg::wpds_whew::wpds_chuckle::wpds_silly::wpds_envy::wpds_shutmouth:
wpDiscuz

Sign up for Exchange Messaging Outlook

Our weekly Outlook & Exchange newsletter (bi-weekly during the summer)






Please note: If you subscribed to Exchange Messaging Outlook before August 2019, please re-subscribe.

Never see this message again.

You are going to send email to

Move Comment