Outlook 2010 VBA to remove delete contents in subject line

Posted on 2011-09-14
Last Modified: 2012-11-19
I am trying to run a Outlook rule that will run a script when receiving messages from a particular  email address.  I wan the script to delete the contents of the subject line.  Can someone help me with a script because I have never worked with VBA.  
Question by:beta2028
  • 3
  • 3
LVL 13

Expert Comment

by:Alexei Kuznetsov
ID: 36538338
Something like this:

Sub ClearSubject(Item As Outlook.MailItem)
    Item.Subject = ""
End Sub

Open in new window


Author Comment

ID: 36538945
That didn't work.  I added this to the ThisOutlookSession and then saved the code.  Then ran the script as a rule and it did not clear the subject.  I even tried to run the rule manually and it didn't clear it either.
LVL 13

Expert Comment

by:Alexei Kuznetsov
ID: 36541153
Believe me it works. Looks like you have macro security enabled.
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

LVL 13

Expert Comment

by:Alexei Kuznetsov
ID: 36541155
Or you just misconfigured your rule.

Accepted Solution

beta2028 earned 0 total points
ID: 36542699
You are correct it was the Macro security.  No wonder I couldn't get any scripts to work.  One last question.  If the subject is Ticket #xxx-xxxxxxx how do I take the Ticket # out of the subject and keep the numbers?  Thanks in advance and getting this to work for me.  

Author Closing Comment

ID: 38612247
Issue resolved

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

My experience with Windows 10 over a one year period and suggestions for smooth operation
Resolve DNS query failed errors for Exchange
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now