Outlook script to forward emails based on senders' address

Status
Not open for further replies.

Natalie

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Hello,

I desperately need help for this. My office inbox receives 100-200 emails daily which we have to disseminate to different groups of people in the firm. I was hoping to semi-automate this process by forwarding each incoming email based on the senders' address to the corresponding group of recipients. For example, if the senders' address contains "@oaktree.com", then this email should be forwarded to a group of people handling the Oaktree account.

Typically, if we only had a few accounts, I can upload each account one by one. However, we have 1000+ accounts to be forwarded and I cannot possibly upload them account by account. Each senders' address is also accompanied by a group of recipients and these are all recorded in an excel sheet.

Is there anyway for the script to search the senders' address in the incoming email, and then forward it to the relevant account handlers stated in the excel sheet?

Thanks so much so much in advance.

Best regards,
Natalie
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
dweller Outlook 2010 Rule Ignores VBA Script Outlook VBA and Custom Forms 2
B Outlook rule run a Script doesn't work Outlook VBA and Custom Forms 1
K Outlook Archive to PST Files by Date Range VBA Script? Outlook VBA and Custom Forms 1
H VB script in outlook form doesn't work anymore Outlook VBA and Custom Forms 2
Vijay Run script doesn't work in outlook Using Outlook 1
F Avoid sending duplicate using Outlook script Outlook VBA and Custom Forms 2
oliv- How to Run a Script IN AN ADDIN with Outlook's Rules and Alerts Outlook VBA and Custom Forms 2
S using script rule to save attachments on arrival Outlook 2010 Outlook VBA and Custom Forms 9
X Outlook script to run excel data Outlook VBA and Custom Forms 1
N VBA Script to Send Automatic Emails from Outlook 2010 Outlook VBA and Custom Forms 1
D RUN SCRIPT WHEN OUTLOOK IS CLOSE Outlook VBA and Custom Forms 1
P How many subs can run in one outlook VBA script Using Outlook 5
J VBS Script (macro) for word to open Outlook template. Outlook VBA and Custom Forms 2
J Email Parsing VBA Script for Outlook - NEEDED Outlook VBA and Custom Forms 7
J VBS Script: How to execute in Outlook Outlook VBA and Custom Forms 8
Hudas Outlook VBA script reverting back to previous changes Outlook VBA and Custom Forms 2
J Outlook 2007 Rules & VBA: How to run a script on a report message (ReportItem) Using Outlook 14
M Outlook Rule To Redirect Mail - Script to overcome lack of cc's & others Using Outlook 0
C Outlook Script Error Using Outlook 0
S Outlook VBA rule script to process both MailItem and MeetingItem Using Outlook 0
L Outlook 2007 Macro to Run a Script From a Contact Form Using Outlook 41
L Limit VBA Script to one Outlook account Using Outlook 1
S Outlook 2010, need script for rules & Warnings Using Outlook 3
C Outlook 200? - Script Export Rules Using Outlook 1
R Change Outlook 2010 Exchange server address via registry or script Using Outlook 5
G Script Error message when trying to print e-mails using Outlook Mail Using Outlook 2
H Outlook Connector & Java Script cannot upgrade Using Outlook 2
S How to delete "Outlook Default Profile" via script Outlook 2010 Using Outlook 3
G Can't open email on Microsoft Outlook 2007 that contain java script Using Outlook 1
F Outlook Script Error____Line 278, Class not Registered URL outlook:today Using Outlook 2
H Trying to send Outlook email via VB Script - undeliverable errors Using Outlook 3
B Outlook Script ( using calendar function in a form) Outlook VBA and Custom Forms 3
M Outlook 2013 reminder email by using Outlook vba Outlook VBA and Custom Forms 2
H Outlook 2019 Certificate error Using Outlook 2
B Outlook 2013 erratically deleting original file that is attached Using Outlook 0
V Outlook Forms: Formatting a Label with 2 different styles Outlook VBA and Custom Forms 1
M Outlook 2016 Outlook randomly unhides from taskbar Using Outlook 9
X Using Outlook 2013 and Outlook 365 Using Outlook 1
V Date and/or time error in Outlook Form Outlook VBA and Custom Forms 0
D Sending email from Office 365 alias in Outlook Using Outlook 4
B Spam folder not showing in Outlook Using Outlook 5
ThinkToday Calculate reply time of outlook mail Using Outlook 1
M Microsoft 365 Outlook keeps requesting password on Local Account Using Outlook 1
I Outlook 365 - import/attach PST file that used POP3 Using Outlook.com accounts in Outlook 0
e_a_g_l_e_p_i I think it may be time to upgrade from Outlook 2010 Using Outlook 3
K Outlook 2016 Outlook, Chrome, and Clio Using Outlook 5
O Outlook tasks - Add text column with multiple lines Using Outlook 3
A Run-time error '430' on certain emails when trying to set "Outlook.mailitem" as "ActiveExplorer.Selection.Item" Outlook VBA and Custom Forms 2
HarvMan Outlook 365 PST Report Using Outlook 1
V Upgraded Outlook Using Outlook 1
Similar threads


















































Top