move emails to folder with a subject that is similar

megatronixs · #1 10-14-2014, 03:05 AM

Hi all,

I'm looking for some help with a outlook macro to move emails to a folder when they contain parts of the subject. They all have for sure the 2014 Report in the subject, but it could be also RE: 2014 Report. In a outlook rule I can't use wild cards, so I need it to do with VBA. So far I found the below, but I don't want to delete the email :-)

Code:

Sub CheckSpam(Item As Outlook.MailItem)
If InStr(LCase(Item.Subject), "*2014 report") Then
Item.Delete
End If
End Sub

Any Ideas how I can move this to a folder in a different mailbox.
The mailbox ix called "Mailbox - Spare"
and the folder "2014 Report"

Any help would be great.

Greetings.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Outlook VBA rule to search email attachements and move the emails into a folder	genius7	Outlook	6	09-09-2014 07:01 AM
Move files from one folder to another	obasanla	Word	1	09-28-2012 04:42 PM
Move conversation to folder after replying	karlads	Outlook	0	01-28-2012 12:52 PM
Rule to move sent messages to a specific folder	LouisOscar	Outlook	1	08-17-2011 05:42 AM
How to move pics in excel to another folder?	SPI	Excel	1	08-19-2008 11:58 AM