RTRIM a subject line for grouping purposes

Status
Not open for further replies.

Debbie

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
I would like to know if I can have a rule that would basically RTRIM the subject line after a certain character for the purposes of grouping.

Everytime an error occurs in our system, an email is generated. I'm trying to run metrics on which processes error the most by Error type and vendor. But the problem is that the emails look like:

"Error @ (file_step): (Vendor_Name) -> "(Process_Name)" -> (Date) [(Process_Key)]

Parenthetical values indicate a variable, and parenthesis are not part of the subject line. All other formatting is exact.

This makes it difficult for grouping. I'd like to have RTRIM before the second "->" so I can have my folder group the subject lines by File_step, Vendor_Name, Process_Name and not separate out the date or the process_key.

Is there a way to do this, either in rules, or in the view settings (I don't need to necessarily change the subject lines if I could group by subject before the date)
 
To be able to group by it, you'd need to change the subject. Write a macro that can be called by a rule. In that macro use the Instr function to get the position of '->', then extract the characters left of that positon by calling the Left function.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
H using VBA to edit subject line Outlook VBA and Custom Forms 0
F Auto changing email subject line in bulk Using Outlook 2
M Outlook Macro to save as Email with a file name format : Date_Timestamp_Sender initial_Email subject Outlook VBA and Custom Forms 0
J Outlook 365 Forward Email Subject to my inbox when new email arrive in shared inbox Using Outlook 0
sjmo2 Change subject for new e-mails only. Outlook VBA and Custom Forms 2
C Outlook 365 Copy/Save Emails in Folder Outside Outlook to Show Date Sender Recipient Subject in Header Using Outlook 0
D Prompt to prefix subject line whenever sending an email Outlook VBA and Custom Forms 3
ill13 Prepend the user's computer name to the subject. Outlook VBA and Custom Forms 1
D Auto Remove [EXTERNAL] from subject - Issue with Macro Using Outlook 21
2 How to get rid of the "Emailing:" prefix in the subject line Using Outlook 1
S Outlook Macro for [Date][Subject] Using Outlook 1
O How to find and replace a word in Outlook-Agenda-Subject and Message? Using Outlook 0
D ISOmacro to extract active mail senders name and email, CC, Subject line, and filename of attachments and import them into premade excel spread sheet Outlook VBA and Custom Forms 2
C Outlook 365 Subject Prefixes? Outlook VBA and Custom Forms 1
A Macro to file emails into subfolder based on subject line Outlook VBA and Custom Forms 1
N Save selected messages VBA does not save replies and/or messages that contain : in subject Outlook VBA and Custom Forms 1
V vBA for searching a cell's contents in Outlook and retrieving the subject line Outlook VBA and Custom Forms 1
C Macro to extract sender name & subject line of incoming emails to single txt file Outlook VBA and Custom Forms 3
diver864 vba for a rule to automatically accept meeting requests with 'vacation' in subject, change to all-day event, change to free, don't send reply Outlook VBA and Custom Forms 1
R Disable conversation thread from replying of recipients in the same subject. Please help Using Outlook 0
M Outlook 2013 Script Assistance - Save Opened Link with Subject Added Outlook VBA and Custom Forms 1
C How to rename subject line and forward the email Outlook VBA and Custom Forms 2
B Add Prefix text to Subject Line Using Outlook 1
P [SOLVED] Auto remove [EXTERNAL] from subject Using Outlook 16
M Outlook 2013 Replace Subject with Conversation (a "hidden" value). Outlook VBA and Custom Forms 0
M Convert Subject Line to Internet Header version of Subject Outlook VBA and Custom Forms 10
M Adding Subject to this Link-Saving VBA Outlook VBA and Custom Forms 5
P Auto Insert Current Date or Time into Email Subject Outlook VBA and Custom Forms 2
M VBA to auto forward message with new subject and body text Outlook VBA and Custom Forms 8
L Moving emails with similar subject and find the timings between the emails using outlook VBA macro Outlook VBA and Custom Forms 1
A Edit subject - and change conversationTopic - using VBA and redemption Outlook VBA and Custom Forms 2
B Remove Subject Residual Outlook VBA and Custom Forms 3
F VBA to ensure a code is entered in Subject title Outlook VBA and Custom Forms 1
A Check for words in subject header before sending email Outlook VBA and Custom Forms 4
J VBA Outlook : Subject line : Cut and Paste name to heading , number to very end of the body of Email Outlook VBA and Custom Forms 1
Z Outlook Custom Form: Adding Dropdown(Project Code) at the end of subject Outlook VBA and Custom Forms 0
D Remove text in subject using VBA Outlook VBA and Custom Forms 4
M Making Subject field writable (disable Read Only) Outlook VBA and Custom Forms 2
M Adding Macro to populate "to" "subject" "body" not deleting email string below. Outlook VBA and Custom Forms 5
G Download pdf attachments only if email subject has one of words Outlook VBA and Custom Forms 8
C Change Subject Line in Selected Emails Outlook VBA and Custom Forms 1
M Macro to add date/time stamp to subject Outlook VBA and Custom Forms 4
D Edit Subject (Multiple Accounts) Outlook VBA and Custom Forms 5
E Outlook 2010 Subject sort uses Thread-Topic for grouping Using Outlook 2
C Outlook - cannot save subject line changes Using Outlook 2
J Open an outlook email by Subject on MS Access linked table with VBA Outlook VBA and Custom Forms 10
E Search for folder by key in subject then move new message to related folder Outlook VBA and Custom Forms 1
R Chancing / remove “ something ” in the subject, online archive Outlook VBA and Custom Forms 8
I print calendar without subject and details Using Outlook 1
O On click,I want to change subject line of selected mail and then reply to particular email and move Using Outlook 3

Similar threads

Back
Top