move a specified email "From" tag items to a certain folder whenever there is "New Mail" in the inbo

Status
Not open for further replies.
P

Philosophaie

Member
What I want to do is move a specified email "From" tag items to a certain folder whenever there is "New Mail" in the inbox.


Private Sub Application_NewMail()
Dim BillsEmailFrom(100), JunkEmailFrom(100), ForumsEmailFrom(100) As String
Dim numbills, numjunk, numforums As Double
Dim OLapp As New Outlook.Application
Dim OLns As Outlook.NameSpace
Dim Inbox As Outlook.MAPIFolder
Dim Bills As Outlook.MAPIFolder
Dim JunkEmail As Outlook.MAPIFolder
Dim Forums As Outlook.MAPIFolder
Dim mail As String
BillsEmailFrom(1) = "bill1"
BillsEmailFrom(2) = "bill2"
BillsEmailFrom(3) = "bill3"
numbills = 3
JunkEmailFrom(1) = "advertize@droz.com"
JunkEmailFrom(2) = "advertize@vitahealth.com"
numjunk = 2
Set OLns = OLapp.GetNamespace("MAPI")
Set Inbox = OLns.GetDefaultFolder(olFolderInbox)
Set Items = Inbox.Items
Set PersonalFolder= Inbox.Folders("Personal Folders")
Set BillsFolder = PersonalFolder.Folders("Bills")
Set JunkFolder = PersonalFolder.Folders("Junk E-mail")
If Inbox.Items.Count = 0 Then Exit Sub
For iLoop = 1 To Inbox.Items.Count
For nb = 1 To numbills
If Inbox.Items(iLoop).From = BillsEmailFrom(nb) Then Item.Move BillsFolder
Next nb
For nj = 1 To numjunk
If Inbox.Items(iLoop).From = JunkEmailFrom(nj) Then Item.Move JunkFolder
Next nj
Next iLoop
Set ForumsFolder = Nothing
Set JunkFolder = Nothing
Set BillsFolder = Nothing
Set Items = Nothing
Set Inbox = Nothing
Set OLns = Nothing
End Sub
 
There are three errors:

1) The Item variable doesn't point to the item of the loop.

2) You couldn't move item(1) in the nb loop and then again reference it in the next nj loop as it wouldn't exist anymore in that folder. So the outer loop should be for the address type, the inner one for the folder items.

3) Loop backwards through a collection if you want to remove items from it.
 
Set PersonalFolder= Inbox.Folders("Personal Folders")
is wrong. Personal Folders is where every folder is in including Inbox.
I tried:
Set PersonalFolder = OLns.GetDefaultFolder("Personal Folders")
There are two default folders then plus the syntax of the "Personal Folders"?
 
I get an error when I add this:

Set PersonalFolder = OLns.GetFolders
Set Inbox = OLns.GetDefaultFolder(olFolderInbox)
Set BillsFolder = PersonalFolder.Folders("Bills")
Set JunkFolder = PersonalFolder.Folders("Junk E-mail")
 
try this
Set Inbox = OLns.GetDefaultFolder(olFolderInbox)
Set BillsFolder = Inbox.Folders("Bills")
Set JunkFolder = Inbox.Folders("Junk E-mail")
 
Status
Not open for further replies.
< Picture/Image/Attachment Resizing | String manipulation in Outlook VBA >
Similar threads
Thread starter Title Forum Replies Date
H Move Selected emails to Local Drive Outlook VBA and Custom Forms 0
A Search folder and move the email Outlook VBA and Custom Forms 0
A Outlook 365 (OutLook For Mac)Move "On My Computer" Folder Items From Old To New Mac Computer Using Outlook 4
HarvMan Outlook 365 - Rule to Move an Incoming Message to Another Folder Using Outlook 4
humility36 Cannot move emails to archive - 440 error Outlook VBA and Custom Forms 1
B Outlook 2019 Automatically move email after assigning category Using Outlook 4
C Trying to move messages between imap accounts/folders Using Outlook 5
M Move command Outlook VBA and Custom Forms 11
C Code to move mail with certain attachment name? Does Not work Outlook VBA and Custom Forms 3
B Move emails from one account to another Outlook VBA and Custom Forms 2
J Quick steps delete original email and move reply/sent email to folder Using Outlook 2
N How to add or delete items to Move dropdown Menu Using Outlook 0
Commodore Unable to move message Using Outlook 3
N Line to move origEmail to subfolder within a reply macro Outlook VBA and Custom Forms 0
C Move or copy from field to field Outlook VBA and Custom Forms 0
T Outlook 365 Move newly created tasks automatically on save. Outlook VBA and Custom Forms 1
NVDon Create new Move To Folder list Outlook VBA and Custom Forms 0
P Print attachments automatically and move the mail to an existing folder called "Ted" Outlook VBA and Custom Forms 4
T Macro to move reply and original message to folder Outlook VBA and Custom Forms 6
F VBA to move email from Non Default folder to Sub folders as per details given in excel file Outlook VBA and Custom Forms 11
F Excel VBA to move mails for outlook 365 on secondary mail account Outlook VBA and Custom Forms 1
J Dopey move - deleted profile Using Outlook 1
GregS Outlook 2016 Move Outlook to new computer? Using Outlook 4
Witzker Macro to move @domain.xx of a Spammail to Blacklist in Outlook 2019 Outlook VBA and Custom Forms 7
G Move tasks up/down todo list by VBA Outlook VBA and Custom Forms 1
S Macro to move “Re:” & “FWD:” email recieved the shared inbox to a subfolder in outlook Outlook VBA and Custom Forms 0
S Outlook Macro to move reply mail based on the key word in the subjectline Outlook VBA and Custom Forms 0
D Move Email with Attachment to Folder Outlook VBA and Custom Forms 3
Eike Move mails via macro triggered by the click of a button? Outlook VBA and Custom Forms 0
G Cannot Move Autocomplete File to New Computer Using Outlook 15
M Move to Folder Using Outlook 1
P Move emails between 2 mailboxes. Using Outlook 0
C Copy Move item won't work Outlook VBA and Custom Forms 2
N Macro to move all recipients to CC while replying Outlook VBA and Custom Forms 0
Commodore Move turns into "copy" Using Outlook 3
R List folders in a combo box + select folder + move emails from inbox to that folder + reply to that email Outlook VBA and Custom Forms 1
Jennifer Murphy Ctrl+Tab sometimes will not move through text a word at a time Using Outlook 1
V Outlook 2016 will not move emails in search results Using Outlook 4
M move to iCloud not working in outlook calendar Using Outlook 12
A Create date folder and move messages daily Outlook VBA and Custom Forms 1
Commodore Folders always closed in move/copy items dialog box Using Outlook 3
C Move Outlook 2007 to new PC with Outlook 365 Using Outlook 3
C Can't move folder, the folder is full Using Outlook 0
Nadine Rule to move attachments with specific name Outlook VBA and Custom Forms 1
A Move email items based on a list of email addresses Outlook VBA and Custom Forms 40
T Move calendar invites to new calendar Using Outlook 5
O Rule to move (specific) messages from Sent folder to Specific folder Using Outlook 1
I Automating message move between folders Outlook VBA and Custom Forms 0
K Outlook Rules: Move a Copy Using Outlook 4
K VBA BeforeItemMove event create rule to always move to its folder. Outlook VBA and Custom Forms 4

Similar threads

Back
Top