Rule to move attachments with specific name

Status
Not open for further replies.

Nadine

New Member
Outlook version
Outlook 2016 32 bit
Email Account
POP3
Please can someone assist me with VBA Code to create a rule for outlook to move all emails with the attachment name "SALESINVOICE" to a sub folder in my Inbox Called "Invoices". It is a pop account. Thank you.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
The macros on Use VBA to move messages with attachments comes close to what you need - the first runs in a rule, the second checks every message that is added to the folder.

This checks for the filetype - you'll need to change it to check the filename
Code:
For i = attCount To 1 Step -1
      strFile = Item.Attachments.Item(i).FileName
      
      sFileType = LCase$(Right$(strFile, 4))
    
    Select Case sFileType
        Case ".pdf", ".doc", "docx"
    ' do something if the file types are found 
    ' this code moves the message
      Item.Move (Session.GetDefaultFolder(olFolderInbox).Folders("Invoices"))
    
   ' stop checking if a match is found and exit sub
       GoTo endsub
      End Select
  Next i


This should work but i didn't test it. I don't guarantee its error free. :) if SALESINVOICE will always be upper case, you can use it, but if the case can vary, you need to convert the subject to lower caser (or upper case) when checking. I prefer to use lcase: if instr(lcase(strfile), "salesinvoice") > 0 then

Code:
For i = attCount To 1 Step -1
      strFile = Item.Attachments.Item(i).FileName
      
if instr(strfile, "SALESINVOICE") > 0 then 
    ' do something if the file types are found 
    ' this code moves the message
      Item.Move (Session.GetDefaultFolder(olFolderInbox).Folders("Invoices"))
    
   ' stop checking if a match is found and exit sub
       GoTo endsub
end if
  Next i
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
O Rule to move (specific) messages from Sent folder to Specific folder Using Outlook 1
K VBA BeforeItemMove event create rule to always move to its folder. Outlook VBA and Custom Forms 4
L Making rule to move email to folder from one O365 domain Using Outlook 1
S Send email via SMTP - use transport rules to add to senders inbox (then rule to move to sent items Exchange Server Administration 1
S How can I create a rule to move inbound emails from any of my contacts out of Inbox? Using Outlook 1
H Rule to move emails based on subject and content Outlook VBA and Custom Forms 1
B Outlook 2000 Rule to Move txt msg Not Working if size >24KB Using Outlook 3
S Creating custom rule to move if "NAME" is in body but ignore the phrase "Hi NAME" in the search Using Outlook 2
N rule to move sent mail to the deleted folder in outlook Using Outlook 4
S Rule to move messages except for replies Using Outlook 5
H move to folder rule corrupts message Using Outlook 3
A rule to move emails to a folder then want to delete them from that folder 2010 Using Outlook 5
S Rule to move BCC email to a folder Using Outlook 6
P Create rule 'move to XYZ folder when sender does not contain mydomain.com' Using Outlook 2
N Move to folder rule still shows desktop alert Using Outlook 2
O Outlook 2010: Rule to move sent emails doesn't start if I Use "Send To" command on a file on desktop Using Outlook 3
D A way to create a rule to move messages to specific folder after read? Using Outlook 2
R Move to folder rule for already downloaded emails Using Outlook 1
B Create a rule to move emails after being sent to specific domains Outlook 2007 Using Outlook 1
O How to set rule to move email from hotmail account into Inbox? Using Outlook 1
M Organization rule ***SPAM*** to move to specific folder Using Outlook 6
D How to create a rule to move a message after it is read Using Outlook 3
1 Incorrectly Setup a Rule at Domain level to not allow address from outside domain Exchange Server Administration 2
J Transport Rule to detect Keyword question.. Exchange Server Administration 2
T "Words In Recipient's Address" Rule Causes Outlook To Stop Processing Rules Using Outlook 3
R Outlook Autoforward rule do not work for NDR messages Using Outlook 1
R Setup autofoward rule on a particular folder in Outlook Using Outlook 0
N Rule for "on behalf of" - with changing names Using Outlook 2
S Unable to remove rule outlook 2010 Using Outlook 0
O Outlook 2016 This rule will only run when you check your email in Outlook.... Using Outlook 4
N Outlook Email Rule execution through shortcut keys (VBA codes) Using Outlook 1
dweller Outlook 2010 Rule Ignores VBA Script Outlook VBA and Custom Forms 2
S Adding new Exchange (2016) rule very slow down Microsoft Outlook Exchange Server Administration 0
B Outlook rule run a Script doesn't work Outlook VBA and Custom Forms 1
icacream Rule based on sender / wrong sender sent to folder Using Outlook 7
Bri the Tech Guy Run Script rule not running for newly arriving messages Outlook VBA and Custom Forms 25
J Assess content of User Defined Field in Rule Using Outlook 3
A Change order of actions in one (!) rule Outlook VBA and Custom Forms 2
J HELP- Rule to auto strip prepend from external emails Using Outlook 0
A Forward Outlook Email by Filtering using Macro Rule Outlook VBA and Custom Forms 44
A rule to flag messages not working Using Outlook 5
Brian Murphy Exchange Online Everything a Transport Rule should do and cannot Exchange Server Administration 1
J Outlook Rules - Changing auto-submit address in multiple rules, according to rule name Outlook VBA and Custom Forms 0
A saving attachement to folder named the same as rule name Outlook VBA and Custom Forms 0
Jennifer Murphy Can I create a Rule with Or'd conditions? Using Outlook 1
A Rules - how to determine if all conditions in rule are true or false Outlook VBA and Custom Forms 5
Vijay Error in rule- Run a script Using Outlook 1
Ascar_CT Rule behavior analysis - any tools available? Using Outlook 0
Liza Creating a rule in outlook to filter messages Using Outlook 0
Stilgar Relsik Create a rule to copy text from an email and paste it in the subject line. Using Outlook 1
Similar threads


















































Top