Email Subject and Conversation Topic

Status
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?

Thanks
Alan
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
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.
 

Alan McGowan

Senior Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
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.
 

Alan McGowan

Senior Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
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.
 

Alan McGowan

Senior Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
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.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
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.
 

Alan McGowan

Senior Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
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?

Code:
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: http://www.dimastr.com/redemption/download.htm
Set oRDOSess = CreateObject("Redemption.RDOSession")
Set oNS = Nothing
Set oNS = Outlook.GetNamespace("MAPI")
oNS.Logon
oRDOSess.MAPIOBJECT = oNS.MAPIOBJECT

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("http://schemas.microsoft.com/mapi/proptag/0x00710102") = Null

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

End Sub
 

Alan McGowan

Senior Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
Apologies I am getting an error (I forgot to tick Redemption in references). The error is:

Untitled.png
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
It's working here to split a conversation in my exchange mailbox.
 

Alan McGowan

Senior Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
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
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
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.
 

Alan McGowan

Senior Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
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.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
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.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
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
N contact list seen in Contact folder but knot in Address book or when 'TO' button is clicked in new email Using Outlook 0
T Junk Email does not get added to the Blocked Sender List Using Outlook 0
P i-Phone 6s Plus receiving 2 notifications from Outlook email Using Outlook 1
C WARNING - DO NOT USE AN OUTLOOK.COM ADDRESS FOR GOOGLE ACCOUNT RECOVERY EMAIL Using Outlook 10
T Why is every new email pinned (to keep it on top)? Windows 10 Using Outlook 6
M Outlook, send to > mail recipient - results in plain text email Using Outlook 1
P Can I create a Rule that sends me an email when I get a Task? Using Outlook 3
M Issue transferring Outlook 2016 email accounts & settings onto new computer Using Outlook 8
R Auto Assign Category colours to Incoming Emails based on whom the email is addressed Outlook VBA and Custom Forms 3
S Outlook email to configure setup for each mail Outlook VBA and Custom Forms 1
S Macro to extract email addresses of recipients in current drafted email and put into clipboard Outlook VBA and Custom Forms 2

Similar threads

Top