Macro to file emails into subfolder based on subject line

Status
Not open for further replies.
A

ashley1987

New Member
Outlook version
Outlook 2016 64 bit
Email Account
Exchange Server
Hello,

I work with a team and we all share a mailbox. This mailbox gets dozens of emails per day and we file them based on the ref# and the client name in the subject line. I am looking to create a macro that looks for the ref# and the client name in the subject line and files the email in the client subfolder and then with the corresponding ref#. I also need to the macro to create a subfolder if the ref# subfolder doesn't exist yet.

Here is what the inbox looks like (where Aqua-Net, Microsoft, Philipps and Sony are the clients and the numbers 20345, 20389, etc are the ref#s):

1620660687312.png


The subject lines look like this:

Ref#20345 - Aqua-Net - Customer Satisfaction Email - FR

RE: Ref#20389 - Microsoft - 2021 User Guide - FR

Ref#20547 - Philipps - Website proofing - FR (this would be an example of where the macro would create the subfolder)

etc.


thank you!!!!
 
I have a macro that files by client code -
www.slipstick.com

VBA: File messages by client code

The problem: a user needs to file messages from clients in a specific folder, which is the clients accounts number. Moving the messages manually is time consuming but using a macro makes it easy.
www.slipstick.com www.slipstick.com

You'll also want to see this article since its not the default mailbox
www.slipstick.com

Working with VBA and non-default Outlook Folders

How to use VBA to 'do something' in Outlook's non-default folders.
www.slipstick.com www.slipstick.com
 
Status
Not open for further replies.
< Alternative to "getfedualtfolder" | Respond to Outlook Email >
Similar threads
Thread starter Title Forum Replies Date
C Macro to extract sender name & subject line of incoming emails to single txt file Outlook VBA and Custom Forms 3
C Help with a Macro to move emails to a different PST data file Using Outlook 4
M Outlook Macro to save as Email with a file name format : Date_Timestamp_Sender initial_Email subject Outlook VBA and Custom Forms 0
E Copying data from e-mail attachement to EXCEL file via macro Outlook VBA and Custom Forms 38
P Macro to attach a file in a shared Outlook draft folder Outlook VBA and Custom Forms 2
R Macro to check file name with outlook address book Outlook VBA and Custom Forms 0
J Outlook Macro to Update Sharepoint Excel File Using Outlook 1
Matt Johnson Save File Macro Working Sporadically Using Outlook 9
H Macro to file Outlook email by sender's email address Using Outlook 11
E Macro to export BCM business data to CSV file BCM (Business Contact Manager) 1
W Macro to File Inbox Messages? Using Outlook 1
B Simple way to insert file text - macro? Outlook VBA and Custom Forms 1
J Macro to create folder in PST file Outlook VBA and Custom Forms 4
Q A Macro for 'File - Save.As' on multiple selections Outlook VBA and Custom Forms 1
X Custom icon (not from Office 365) for a macro in Outlook Outlook VBA and Custom Forms 1
X Run macro automatically when a mail appears in the sent folder Using Outlook 5
mrrobski68 Issue with Find messages in a conversation macro Outlook VBA and Custom Forms 1
G Creating Macro to scrape emails from calendar invite body Outlook VBA and Custom Forms 6
M Use Macro to change account settings Outlook VBA and Custom Forms 0
J Macro to Reply to Emails w/ Template Outlook VBA and Custom Forms 3
C Outlook - Macro to block senders domain - Macro Fix Outlook VBA and Custom Forms 1
Witzker Outlook 2019 Macro to seach in all contact Folders for marked Email Adress Outlook VBA and Custom Forms 1
S macro error 4605 Outlook VBA and Custom Forms 0
A Macro Mail Alert Using Outlook 4
J Outlook 365 Outlook Macro to Sort emails by column "Received" to view the latest email received Outlook VBA and Custom Forms 0
J Macro to send email as alias Outlook VBA and Custom Forms 0
Witzker Outlook 2019 Macro GoTo user defined search folder Outlook VBA and Custom Forms 6
D Outlook 2016 Creating an outlook Macro to select and approve Outlook VBA and Custom Forms 0
Witzker Outlook 2019 Macro to send an Email Template from User Defined Contact Form Outlook VBA and Custom Forms 0
Witzker Outlook 2019 Macro to check Cursor & Focus position Outlook VBA and Custom Forms 8
V Macro to mark email with a Category Outlook VBA and Custom Forms 4
M Outlook 2019 Macro not working Outlook VBA and Custom Forms 0
S Outlook 365 Help me create a Macro to make some received emails into tasks? Outlook VBA and Custom Forms 1
Geldner Send / Receive a particular group via macro or single keypress Using Outlook 1
D Auto Remove [EXTERNAL] from subject - Issue with Macro Using Outlook 21
V Macro to count flagged messages? Using Outlook 2
sophievldn Looking for a macro that moves completed items from subfolders to other subfolder Outlook VBA and Custom Forms 7
S Outlook Macro for [Date][Subject] Using Outlook 1
E Outlook - Macro - send list of Tasks which are not finished Outlook VBA and Custom Forms 3
E Macro to block senders domain Outlook VBA and Custom Forms 1
D VBA Macro to Print and Save email to network location Outlook VBA and Custom Forms 1
N VBA Macro To Save Emails Outlook VBA and Custom Forms 1
N Line to move origEmail to subfolder within a reply macro Outlook VBA and Custom Forms 0
Witzker Outlook 2019 Macro to answer a mail with attachments Outlook VBA and Custom Forms 2
A Outlook 2016 Macro to Reply, ReplyAll, or Forward(but with composing new email) Outlook VBA and Custom Forms 0
J Macro to Insert a Calendar Outlook VBA and Custom Forms 8
W Macro to Filter Based on Latest Email Outlook VBA and Custom Forms 6
T Macro to move reply and original message to folder Outlook VBA and Custom Forms 6
D Autosort macro for items in a view Outlook VBA and Custom Forms 2
S HTML to Plain Text Macro - Help Outlook VBA and Custom Forms 1

Similar threads

Back
Top