![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
![]()
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] 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 |
#2
|
|||
|
|||
![]()
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 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Peter Walker" wrote in message ... 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] 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 |
#3
|
|||
|
|||
![]()
Thanks Sue for the help. I'm new to Outlook programming. I better get a
reference : ) Cheers, Peter "Sue Mosher [MVP-Outlook]" wrote in message ... 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 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Peter Walker" wrote in message ... 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] 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Batch Edit Contacts | [email protected] | Outlook - Using Contacts | 0 | July 26th 06 03:52 PM |
changed subject line in Outlook | jellin | Outlook - General Queries | 0 | April 21st 06 02:33 PM |
Edit Subject Field | Meeme | Outlook - Calandaring | 2 | April 18th 06 02:59 PM |
can not use japanses at subject line in outlook | Linhsuwei | Outlook - Installation | 0 | February 13th 06 09:03 AM |
some emails not opening, subject line only, not message | Bill | Outlook - General Queries | 4 | January 26th 06 02:31 PM |