Auto forward for multiple emails

stripesandcanvas

New Member
Outlook version
Outlook 365 64 bit
Email Account
Office 365 Exchange
Hi, I have a VBA script that auto-forwards one set of conditions to a group of people. I want to add another set of conditions so that it auto-forwards a different email to another group of people so that the script sends email 1 to group A and email 2 to group B. I'm having difficulty getting the second set of conditions to work. How can I get this to work? Ultimately I'd like to have 5 or so of different set of conditions. Setting up Outlook rules doesn't work due to auto-forwarding limitations.

Here is what I have so far:

Public WithEvents objInbox As Outlook.Folder
Public With Events objInboxItems As Outlook.Items

Private Sub Application_Startup()
Set objInbox = Outlook.Application.Session.GetDefaultFolder (olFolderInbox)
Set objInboxItems = objInbox.Items
End Sub

Private Sub objInboxItems_ItemAdd (ByVal Item As Object)
Dim objMail As Outlook.MailItem
Fim objForward As Outlook.MailItem

If TypeOf Item Is MailItem Then
Set objMail = Item

If (objMail.SenderEmailAdress = "sender@mailbox.com) And (objMail.Subject = "Email Subject 1") Then
Set objForward = objmail.Forward
With obJForward
.Subject = "Email Subject 1"
.Recipients.Add ("person1@mailbox.com")
.Recipients.Add ("person2@mailbox.com")
.Recipients.ResolveAll
.Send
End With
End If
End If
End Sub

'Until here it works, can't get the below part to work

Private Sub objInboxItems_ItemAdd_2 (ByVal Item As Object)
Dim objMail As Outlook.MailItem
Fim objForward As Outlook.MailItem

If TypeOf Item Is MailItem Then
Set objMail = Item

If (objMail.SenderEmailAdress = "sender@mailbox.com) And (objMail.Subject = "Email Subject 2") Then
Set objForward = objmail.Forward
With obJForward
.Subject = "Email Subject 2"
.Recipients.Add ("person3@mailbox.com")
.Recipients.Add ("person4@mailbox.com")
.Recipients.ResolveAll
.Send
End With
End If
End If
End Sub
 
Similar threads
Thread starter Title Forum Replies Date
B Auto Save of Attachments from Multiple Emails and forward attachments to user group Outlook VBA and Custom Forms 1
D auto forward base on email address in body email Outlook VBA and Custom Forms 0
M VBA to auto forward message with new subject and body text Outlook VBA and Custom Forms 8
J Auto Forward - Include Attachment and change Subject depending on original sender Outlook VBA and Custom Forms 3
Z Auto Forward Using Outlook 4
R Auto-create receipt from email and forward to payer Using Outlook 3
L Auto Forward without presenting the original sender Outlook VBA and Custom Forms 1
S Rule to Auto-forward/re-direct a specific incoming email to a group via BCC? Using Outlook 1
J Custom Forms Don't Always Auto-Forward From Public Folder Using Outlook 0
K How to auto truncate a message to forward with Outlook Rules Using Outlook 6
FryW Need help modifying a VBA script for in coming emails to auto set custom reminder time Outlook VBA and Custom Forms 0
DDB VBA to Auto Insert Date and Time in the signature Outlook VBA and Custom Forms 2
V Auto-complete stopped working Using Outlook 4
M Replyall macro with template and auto insert receptens Outlook VBA and Custom Forms 1
R Auto Forwarding with different "From" Outlook VBA and Custom Forms 0
P auto-complete is hopelessly broken Using Outlook 0
R Auto Assign Category colours to Incoming Emails based on whom the email is addressed Outlook VBA and Custom Forms 3
C Auto Run VBA Code on new email Outlook VBA and Custom Forms 1
S Outlook Macro to send auto acknowledge mail only to new mails received to a specific shared inbox Outlook VBA and Custom Forms 0
V Auto-Submitted: auto-replied in header Using Outlook 0
R Auto display of new email does not work on non-default account Outlook VBA and Custom Forms 0
B Outlook 2016 Auto-archive creates new folder Using Outlook 3
J Edit auto-complete list in Outlook 2016+/365? Using Outlook 0
P Auto assign shared mailbox Outlook VBA and Custom Forms 1
M Outlook 2010 Problem with OutLook 2010 32 bit, after Windows Auto Update Using Outlook 3
P [SOLVED] Auto remove [EXTERNAL] from subject Using Outlook 16
Z Add text to auto-forwarded e-mail Outlook VBA and Custom Forms 4
N Disable Auto Read Receipts sent after using Advanced Find Using Outlook 4
Q Prompt button to auto turn on Out of Office Outlook VBA and Custom Forms 3
P Auto Insert Current Date or Time into Email Subject Outlook VBA and Custom Forms 2
S Messages moved / deleted by auto-archive are not synchronized to exchange Exchange Server Administration 8
B Outlook 2010 is Auto Purging when not configured for that Using Outlook 1
A Auto Accept Meetings from the General Calendar Using Outlook 3
R auto send email when meeting closes from a shared calendar only Outlook VBA and Custom Forms 2
S auto-mapping mailboxes in outlook impacting an ost file? Exchange Server Administration 2
M Auto expand Distribution List Before Sending Email Outlook VBA and Custom Forms 1
M Auto-export mail to Excel Outlook VBA and Custom Forms 2
Ms_Cynic Auto-pasting email content in calendar appt? Using Outlook 2
R How Do I insert images in and Auto Reply Using Outlook 3
S Received mail as part of DL, need to auto-CC the same when replying Outlook VBA and Custom Forms 5
T Have Outlook 2016 suggest email address auto complete entries directly from the user's contacts list Using Outlook 10
T Have Outlook 2016 suggest email address auto complete entries directly from the user's contacts list Using Outlook 0
P Auto scroll to specific folder in Folder Pane Outlook VBA and Custom Forms 3
C Auto categorize duplicate subjects Outlook VBA and Custom Forms 11
N Auto-complete - block select emails Using Outlook 3
C Auto save outlook attachments when email is received Outlook VBA and Custom Forms 1
J HELP- Rule to auto strip prepend from external emails Using Outlook 0
S BCM Auto Backup Data and Customizations BCM (Business Contact Manager) 6
G Auto accept meeting request for non primary account Outlook VBA and Custom Forms 1
J Outlook Rules - Changing auto-submit address in multiple rules, according to rule name Outlook VBA and Custom Forms 0

Similar threads

Top