Outlook script to run excel data

Status
Not open for further replies.

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.
Similar threads
Thread starter Title Forum Replies Date
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
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
e_a_g_l_e_p_i Can someone explain syncing with Outlook and Gmail Using Outlook 3
K Outlook Office 365 VBA download attachment Outlook VBA and Custom Forms 2
e_a_g_l_e_p_i Gmail in Outlook 2010 preview issue Using Outlook 4
I Outlook is stuck at "Updating Calendar" Using Outlook 1
AmonRa Outlook 365 calendar - too much white space Using Outlook 0
e_a_g_l_e_p_i Outlook 2010 Help setting up Gmail account in Outlook 2010 Using Outlook 3
C-S-R How to clear an Outlook (To Do) Task Flag? Using Outlook 8
N How do I make Outlook autocomplete addresses from a list of recognised <full_names> only? Using Outlook 2
P Outlook 2019 UI changes after 20H2 update Using Outlook 1
R How to restrict GWSMO sync to Outlook Send/Receive cycles Using Outlook 0
B Outlook 2016 Unable to view images or logos on the outlook 2016 emails the same html code works well when i use outlook 2010 Using Outlook 0
S Outlook 2007 crash linked to gdiplus.dll Using Outlook 0
P Sending email from outlook IMAP to GMAIL where embedded images are added as attachment Using Outlook 1
M Outlook 2010 How could I globally redesign an outlook template form/region/inspector template used to display mail lists or an individual mails? Outlook VBA and Custom Forms 0
T The Linked Image Cannot Be Displayed in Outlook Using Outlook 5
M Outlook 2010 Outlook 2010 with O365 / Exchange Online Using Outlook 0
S Outlook 2016 Change how Outlook shows me contacts in emails Using Outlook 0
A OutLook For Mac 16.46 Comes Up In Small Window When Opening Using Outlook 4
S Outlook 2007 - Automatic purge fail Using Outlook 0
T Outlook creating unwanted tasks in Tasks and Todo from emails Using Outlook 1
V vBA for searching a cell's contents in Outlook and retrieving the subject line Outlook VBA and Custom Forms 1
B vBA for exporting excel file from outlook 2016 Outlook VBA and Custom Forms 3
Horsepower Moving emails between folder Outlook for Mac Outlook Wishlist 8

Similar threads

Top