how to delete one word in multiple appointments Outlook 2010

[MelanieB]

When appointments were copied between calendars, at some point, the words "copy of" appeared in the target calendar. How can I do something like an Edit/Replace and get rid of the words "copy of" in all appointments in the Outlook calendar?

[HansV]

I don't think there is a way to do this in the Outlook interface. You could use a macro. Here is one that acts on the default calendar; it will have to be modified to act on another calendar.

Code: Select all

Sub RemoveCopyOf()
    Dim nsp As Outlook.NameSpace
    Dim fld As Outlook.MAPIFolder
    Dim app As Outlook.AppointmentItem
    Set nsp = Application.GetNamespace("MAPI")
    Set fld = nsp.GetDefaultFolder(olFolderCalendar)
    For Each app In fld.Items
        app.subject = Replace(app.subject, "Copy of ", "")
        app.Save
    Next app
End Sub

[Rudi]

When appointments were copied between calendars, at some point, the words "copy of" appeared in the target calendar. How can I do something like an Edit/Replace and get rid of the words "copy of" in all appointments in the Outlook calendar?

AFAIK, you cannot run Find/Replace outside of the text editor in Outlook.
In order to do what you need, you would either need to use an add-in (not free), a macro or do a work-around (free).

The workaround:
Export your calendar to Excel
Use Find/Replace in Excel to modify the appointment names
Import the appointments back into Outlook

Since this is not tried and tested, I'm not sure if it will create duplicate appointments when you import it again?