Outlook script to run excel data

Status
Not open for further replies.
X

xoomoon

New Member
Outlook version
Outlook 2016 64 bit
Email Account
IMAP
Hi guys,
I'm new to the forum and I need help with something. What I want to do is create a rule in outlook to filter incoming customers' orders to a specific folder. I have over 400 customers and I don't want to create over 400 rules to filter the emails. Is there a faster way to do this? I have a macro to create the 400 folders in Outlook already. Now, all i have to do is create a rule from each customer and filter it out to the correct folder.
For instance, if the subject is "order #123" it will filter to "order#123" folder.
If there's a script to create a folder based on the subject, that would be good too. Or, if there's a way for outlook to run the 400 data in Excel and create a rule to filter them out to specific folders from there.

Any help would be appreciated.

Thanks
 
Status
Not open for further replies.
< vba scrip to move emails based on long keywords list | VBA Script to Send Automatic Emails from Outlook 2010 >
Similar threads
Thread starter Title Forum Replies Date
J Outlook Rules VBA Run a Script - Multiple Rules Outlook VBA and Custom Forms 0
N Outlook 2021 'Run Script" Rules? Outlook VBA and Custom Forms 4
B Outlook rule run a Script doesn't work Outlook VBA and Custom Forms 1
Vijay Run script doesn't work in outlook Using Outlook 1
oliv- How to Run a Script IN AN ADDIN with Outlook's Rules and Alerts Outlook VBA and Custom Forms 2
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 Outlook 2007 Rules & VBA: How to run a script on a report message (ReportItem) Using Outlook 14
L Outlook 2007 Macro to Run a Script From a Contact Form Using Outlook 41
G Trigger script without restaring outlook Outlook VBA and Custom Forms 7
D.Moore VB script to Digitaly Sign newly created outlook message Outlook VBA and Custom Forms 2
dweller Outlook 2010 Rule Ignores VBA Script Outlook VBA and Custom Forms 2
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
F Avoid sending duplicate using Outlook script Outlook VBA and Custom Forms 2
N Outlook script to forward emails based on senders' address Outlook VBA and Custom Forms 2
S using script rule to save attachments on arrival Outlook 2010 Outlook VBA and Custom Forms 9
N VBA Script to Send Automatic Emails from Outlook 2010 Outlook VBA and Custom Forms 1
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
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 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
B Outlook Script ( using calendar function in a form) Outlook VBA and Custom Forms 3
Rupert Dragwater Background colors not saving in Outlook 365 Using Outlook 11
petunia Outlook tasks module sunsetting? Exchange Server Administration 3
G Save emails as msg file from Outlook Web AddIn (Office JS) Outlook VBA and Custom Forms 1
D Outlook VBA forward the selected email to the original sender’s email ID (including the email used in TO, CC Field) from the email chain Outlook VBA and Custom Forms 3
U Outlook 2021 not showing contact cards in Searches Using Outlook 2
C Outlook - Macro to block senders domain - Macro Fix Outlook VBA and Custom Forms 2
H Outlook 365 O365 outlook calendar item editing Using Outlook 1
J Outlook 365 html inline images Using Outlook 1
Rupert Dragwater How to get Outlook 365 to open from websites Using Outlook 5
S Why do I have to close and reopen Outlook for macros to work? Outlook VBA and Custom Forms 2
J Outlook 2021 ScanPST errors (yet again ... sorry): repair button missing Outlook 2021 Using Outlook 0
HarvMan Outlook 365 - Rule to Move an Incoming Message to Another Folder Using Outlook 4
K Moved pst to new computer, now Gmail not coming into Outlook Using Outlook 7
S Email Macros to go to a SHARED Outlook mailbox Draft folder...NOT my personal Outlook Draft folder Using Outlook 2
F Running Scripts in Outlook 2021 Using Outlook 0
Nufc1980 Outlook "Please treat this as private label" auto added to some emails - Help. Using Outlook 3
S Outlook 2019 Custom outlook Add-in using Visual Studio Outlook VBA and Custom Forms 0
V Outlook macros no longer run until VB editor is opened Outlook VBA and Custom Forms 0
R Outlook 365 How to integrate a third-party app with Outlook to track email and sms? Using Outlook 2
e_a_g_l_e_p_i I can't believe what I am seeing when trying to install Outlook 2021 Using Outlook 9

Similar threads

Top