Remove text in subject using VBA

Status
Not open for further replies.
D

danlyng

New Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
Hi,

In my company there has been made a new feature whenever we get an email from an external sender.

Text i subject can now be: "[CAUTION: EXTERNAL EMAIL] Agenda for meeting wednesday" as before it would just have stated "Agenda for meeting wednesday"

The annoying thing about it is that the text [CAUTION: EXTERNAL EMAIL] does not remove itself when I send a reply.
I would like af code to put into ThisOutlookSession.

I have tried this one but without luck:

Sub mymacro ()
dim arr as variant,i as long
arr=array("[CAUTION: EXTERNAL EMAIL]")
for i=0 to ubound(arr)
oitem.subject=replace(oitem.subject,arr(i),"",,,vbtextcompare)
next
oitem.subject=trim(oitem.subject)
oitem.save
End Sub
 
is that the only test you need to replace? if so, don't use the arrary.
oitem.subject=replace(oitem.subject,"[CAUTION: EXTERNAL EMAIL]","")

if you want ot use an array, see Using Arrays in Outlook macros
try For i = LBound(arr) To UBound(arr)
 
Status
Not open for further replies.
< VBA BeforeItemMove event create rule to always move to its folder. | VBA Code to permanently delete selected email >
Similar threads
Thread starter Title Forum Replies Date
F VB Script, remove text from subject line when forwarding Using Outlook 22
N How to remove signature formatting from Text in Word (accidentally taken from Outlook) Using Outlook 0
J Remove text to Clean Up Outlook VBA and Custom Forms 1
G Reply a selected message and remove blank space before signature Outlook 365 version 2406 64BIT Outlook VBA and Custom Forms 2
G Reply a selected message and remove blank space before signature Outlook 365 version 2406 64BIT Outlook VBA and Custom Forms 0
D Auto Remove [EXTERNAL] from Subject + ConversationTopic (WITHOUT Redemption plug-in) Outlook VBA and Custom Forms 5
Rupert Dragwater How do I remove an email ending with @gmail.com Using Outlook 4
E Edit incoming emails to remove a certain sentence added by the "system" Using Outlook 1
O VBA - Regex - remove double line spacing Outlook VBA and Custom Forms 1
TomHuckstep Remove Send/Receive All Folders (IMAP/POP) button from Outlook 365 Ribbon Using Outlook 2
Rupert Dragwater How to permanently remove an email address Using Outlook 9
D Auto Remove [EXTERNAL] from subject - Issue with Macro Using Outlook 21
E Remove flag automatically Using Outlook 4
N Can't create NEW GROUP and add/remove a member from existing Group in Outlook Using Outlook 1
Timmon Remove just one attachment before AutoForward Outlook VBA and Custom Forms 0
Z Remove GMAIL IMAP account from Outlook 2016 Using Outlook 2
C-S-R Manage Add-ins (Remove Wunderlist) Using Outlook 6
O Remove duplicates within two accounts Using Outlook 2
D How to remove a folder, option grayed out Using Outlook 4
T Outlook 2016 remove envelope icon for certain folders Using Outlook 5
M In Outlook Calendar remove the buttons: 'Today' and '<' (Back a day) and '>' (Forward a day) that are below the Ribbon and above the calendar display. Using Outlook 0
P [SOLVED] Auto remove [EXTERNAL] from subject Using Outlook 16
P Add, remove, & reorder folder pane Using Outlook 6
W Remove specific contacts from contact list Outlook VBA and Custom Forms 3
T Cannot remove needless PST Using Outlook 1
Healy Consultants Macro to remove inside organization distribution list email address when reply to all recepients Outlook VBA and Custom Forms 0
S Unable to remove rule outlook 2010 Using Outlook 0
B Remove Subject Residual Outlook VBA and Custom Forms 3
P how to remove unwanted PST file default categories assigned to many calendar entries Using Outlook 7
B Automatically Forward Emails and Remove/Replace All or Part of Body Outlook VBA and Custom Forms 8
T Remove Old Location From Tasks Pane Using Outlook 1
A remove or turn off outlook.com contact folder from outlook 2016 Using Outlook 4
R Chancing / remove “ something ” in the subject, online archive Outlook VBA and Custom Forms 8
Morgan Fowler Remove Signature Using Outlook 1
M How to remove a list of specific contacts from Outlook Using Outlook 18
R New Links on Navigation Pane, How to Remove? Using Outlook 1
M VBA to remove deferred delivery on a MeetingItem Outlook VBA and Custom Forms 2
J Remove extra line above signature in reply Outlook VBA and Custom Forms 5
Diane Poremsky How to Remove RSS Support from Outlook Using Outlook 0
Diane Poremsky Remove Attachments From Messages Using Outlook 0
Diane Poremsky Remove Office 2013 Update Banner Using Outlook 0
O Remove duplicate mail items Outlook VBA and Custom Forms 6
Diane Poremsky Remove a password from an Outlook *.pst File Using Outlook 3
G VBA/Macro to remove page colour when replying or forwarding email Outlook VBA and Custom Forms 2
L Fake reminder apperaring (not in calendar) - how to remove? Using Outlook 5
J Your IMAP server wants to alert you to the following: cannot remove system folder Using Outlook 3
A Auto Insert of filename when selecting 'Remove Attachment' Using Outlook 1
C how to remove icons on right hand side outlook 2013 Using Outlook 2
K Remove Manage APPS button for users Exchange Server Administration 1
P Remove name and parenthses from email Using Outlook 1

Similar threads

Back
Top