How to batch edit subject line of outlook emails

  • Thread starter Thread starter Peter Walker
  • Start date Start date
P

Peter Walker

Hi, I was hoping someone could help me.

I would like to batch edit a number of email folders in outlook 2007. The
current situation is that the emails in a number of my folders have common
subject lines, for example:

[Arrow Marker #1] Re: Debian CD
[Arrow Marker #1009] subscribe posting
[Arrow Marker #137] triathlon

What I would like to get rid if is the text '[Arrow Marker #XXXX] ' from the
Subject of each email message, where XXXX is a number that might not be
unique between emails.

Is there any VB script that could do this?

Would be most grateful for any help!

Cheers,
Peter
 
This is a basic text parsing exercise. For each message (objMsg), run code like this to find the break point:

If Left(objMsg.Subject, Len("[Arrow Marker")) = "[Arrow Marker" Then
intBreak = Instr(objMsg.Subject, "]")
If intBreak > 0 Then
objMsg.Subject = Mid(objMsg.Subject, intBreak + 1)
End If
End If

I'd recommend using a search folder to gather all the marked items into one place for processing.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Thanks Sue for the help. I'm new to Outlook programming. I better get a
reference : )

Cheers, Peter

This is a basic text parsing exercise. For each message (objMsg), run code
like this to find the break point:

If Left(objMsg.Subject, Len("[Arrow Marker")) = "[Arrow Marker" Then
intBreak = Instr(objMsg.Subject, "]")
If intBreak > 0 Then
objMsg.Subject = Mid(objMsg.Subject, intBreak + 1)
End If
End If

I'd recommend using a search folder to gather all the marked items into one
place for processing.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Back
Top