Email Subject and Conversation Topic

Not open for further replies.

Alan McGowan

Senior Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
I have quite a complicated macro running in Outlook which saves emails. One of the features is to pop up a userform as soon as a outgoing email hits the sent items folder. The user can then choose to save the email to a folder, delete the email or simply leave it in the sent items. If the choose to save it but not delete it from the sent items the message subject is prefixed with [Saved on /dd/mm/yyyy].

I'm having a problem that when someone replies to the sent message and I am using conversation view the emails aren't grouped together. I'm assuming that the conversation topic is somehow being changed when I save the email and add the prefix [Saved on /dd/mm/yyyy].

Question - am I correct in thinking the conversation topic will be getting changed? If so is there anyway to prevent this?

What version of exchange server do you use? the topic comes from a field in the header and the subject field so changing the subject *shouldn't* change the conversation if you use exchange... unless you are using an older version. It can be problematic in 2007, and i think 2010 as well as with pop & imap accounts.
We are running Office 365 so fully up to date I think. Not sure what version of Exchange but suspect that will be pretty much up to date too.
I've had a look at what is happening when I change the subject. The Conversation ID and Conversation Topic are not changing however, the Conversation Index is changing. I'm assuming this changing is why the messages are no longer being grouped in a Conversation.
I was hoping that I could take the Conversation Index Value prior to changing the subject and storing it as a String and then after the subject is changed I could change the new Conversation Index to the original Conversation Index. However the Conversation Index is read only so that doesn't work.
Redemption can change (at least some) read-only things, while VBA cannot. See Merge or Split Conversations for some code samples. I'm not sure it will help you as it did not work on my office365 mailboxes but worked on shared mailboxes.
Hi Diane, I found some code elsewhere that suggested the Conversation Index could be set to null using redemption. The code I'm trying to use is below. When I run it I get no error message and the Conversation Index isn't being set to null. Any ideas?

Sub convdel()

Dim objApp As Outlook.Application
Dim incomingMail As MailItem
Dim oNS As Object
Dim oRDOSess As Object
Dim oRDOItem As Object
Set objApp = Application
Set incomingMail = objApp.ActiveExplorer.Selection.Item(1)

Debug.Print "Creating Redemption Object ..."
' This requires:
Set oRDOSess = CreateObject("Redemption.RDOSession")
Set oNS = Nothing
Set oNS = Outlook.GetNamespace("MAPI")

Set oRDOItem = oRDOSess.GetMessageFromID(incomingMail.EntryID, incomingMail.Parent.StoreID)

Debug.Print "Trying to change conversation topic ..."
oRDOItem.ConversationTopic = incomingMail.Subject

Debug.Print "Trying to change conversation index ..."
oRDOItem.Fields("") = Null

Debug.Print "Saving modified mail item ..."

End Sub
Apologies I am getting an error (I forgot to tick Redemption in references). The error is:

It's working here to split a conversation in my exchange mailbox.
The code I posted above is working? Strange that it doesn't for me. Wonder if its because I'm not testing on an Exchange mailbox
Yes, its is working here. What type of account are you testing it on? The error seems ot say it doesn't have write access - which could indicate a problem with redemption install.

It should work on any email account type. I'll test it in the morning with pop3 and imap just to be sure, but the code looks fine - it doesn't call anything that is not available in all accounts AFAICS.
I got the code to work by reinstalling redemption.

However it isn't solving my problem unfortunately. I'm actually not sure if I can solve my problem.

The basic issue I have is when I send an email I save it (to HD as msg) and keep a copy in my inbox. The copy in my inbox has a modified subject to indicate it has been saved. When someone replies to my original email it is not grouped with the original email. I thought this was because the Conversation Index had been changed when I saved the original email (with the modified subject). I amended the code above to keep the same Conversation Index after the subject line was modified but I have noticed that the conversation ID is also different so the messages still aren't being grouped.

Any thought on how I can ensure messages remain grouped even if the subject gets changed. I crucial point is the subject gets changed after the message has been sent.
The differences in the conversation id between original and reply should be a few extra characters on the end. But... if the recipients system doesn't support conversation id, it could get a new one when you receive it. In that case, Outlook would look at the subjects to group.

Could you use a custom field or a category to mark as saved? This won't affect the subject so it will still group correctly.
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
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
D Prompt to prefix subject line whenever sending an email Outlook VBA and Custom Forms 3
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 How to rename subject line and forward the email Outlook VBA and Custom Forms 2
P Auto Insert Current Date or Time into Email Subject Outlook VBA and Custom Forms 2
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
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
J Open an outlook email by Subject on MS Access linked table with VBA Outlook VBA and Custom Forms 10
O On click,I want to change subject line of selected mail and then reply to particular email and move Using Outlook 3
R Sending email copy (*.msg file) of sent email if subject line contains specific string. Outlook VBA and Custom Forms 1
K ind specific Subject line from outlook and copy the content of the email body to exce Outlook VBA and Custom Forms 0
C replace subject line generated by converting a word document to PDF and sending it to an email Using Outlook 8
skyfox VBA to search email subject field for a certain string Outlook VBA and Custom Forms 3
D dropdown list in new email in subject line Using Outlook 4
N Rename Subject Line with Email Content Outlook VBA and Custom Forms 3
Stilgar Relsik Create a rule to copy text from an email and paste it in the subject line. Using Outlook 1
C Save Subject of Received Email as a String Outlook VBA and Custom Forms 1
C Auto subject,name,email,deferred Using Outlook 2
S announce email sender and subject when new email arrives... Using Outlook 7
P Foward email to Trello without FW in subject and parce the text Using Outlook 38
M VBA code to save email attachments (PDF) as email subject line Outlook VBA and Custom Forms 1
B Need Help Creating Email Based on Subject w Address in Body Outlook VBA and Custom Forms 1
M How do I mark emails already received as read when I get a second, different email based on subject? Outlook VBA and Custom Forms 3
D Create Exchange Rule for everyone that highlights an email based on content of subject Exchange Server Administration 1
P Autopopulate Email Subject from Project BCM (Business Contact Manager) 6
J vba to get email name , subject and attachements on excel list Outlook VBA and Custom Forms 2
R VBA to count email Subject names Using Outlook 1
S Pre populate subject + body + attachment to already open email in outlook 2007 Using Outlook 2
G Outlook 2003 I need to move email to folder based on subject, using wild card Using Outlook 0
S Script to parse email subject, get Username, look up in GAL and redirect email Exchange Server Administration 6
P Trying to add subject and name to an email using VB Code Using Outlook 3
D Macro for sorting email according to sender and subject Using Outlook 0
P Automatically 'Reply to all', and Change the Subject of Email - Diane P help! Using Outlook 0
M rule to change subject, pull email addresses from body, and forward with templ Using Outlook 14
L Script to: Change subject of email after checking body Using Outlook 2
P Batch adding text to email subject lines in Outlook Using Outlook 24
T Need help making RULE to prepend email SUBJECT Using Outlook 3
M Save incoming Email as .html file with name of subject line Outlook VBA and Custom Forms 3
M Appending text to the subject line of a Reply, Foward or new Email Outlook VBA and Custom Forms 2
C Prevent Outlook from sending an email with a blank Subject Line Outlook VBA and Custom Forms 3
R Legacy Outlook on Mac Email Cache Using Outlook 0
P Email address auto-completes work fine on laptop, but no longer on desktop Using Outlook 3
S Create Outlook Task from Template and append Body with Email Body Outlook VBA and Custom Forms 4
H Copying email address(es) in body of email and pasting in To field Outlook VBA and Custom Forms 1
A Search folder and move the email Outlook VBA and Custom Forms 0
P VBA to add email address to Outlook 365 rule Outlook VBA and Custom Forms 0

Similar threads