how to delete one word in multiple appointments Outlook 2010
-
- 3StarLounger
- Posts: 310
- Joined: 19 Apr 2010, 16:18
- Location: middle of the state of Washington
how to delete one word in multiple appointments Outlook 2010
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?
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: how to delete one word in multiple appointments Outlook
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
Best wishes,
Hans
Hans
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: how to delete one word in multiple appointments Outlook
AFAIK, you cannot run Find/Replace outside of the text editor in Outlook.MelanieB wrote: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?
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?
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.