Convert Subject Line to Internet Header version of Subject

Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
Hi.
I attempted a VBA a few weeks ago and messed it up. I changed 500+ emails so that the subject for each one reads "New Subject". How can I correct this using the Internet Header "Subject" that is within the email? I can see it one at a time for copy/paste but, I'd like to do it more efficiently.

Thank you.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
That worked so well!
It appears that the subject line is listed (in the hidden details) across two lines with a hard return in the middle. Any ideas on how to fix that?
 
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
Hi Diane...
To clarify, let me show you the pieces of what I'm trying to resolve on this last part.

The Internet Headers lists the Subject as:

Subject: Discovery Information Available For Case 0YG0T4S On Defendant Michael
Gray

Between Michael and Gray is a Hard Carriage Return. As a result, the Subject that you showed me how to retrieve does not return the entire line of data.

How may I tweak the existing script so that this is no longer an issue? Here's the relevant part of your fantastic script!


Code:
Set Reg1 = CreateObject("VBScript.RegExp")
    With Reg1
        .Pattern = "(Subject:\s(.*))"
        .Global = True
    End With
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
You'd use \r at the pattern - i think it's \r, but if it doesn't work, try \n.
.Pattern = "(Subject:\s(.*)\r(.*))"

The only problem is it might pick up part of the next line.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
BTW - since you only have one subject line in the header, use folder for global. It ill stop checking the header when it finds the first entry.
 
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
Well. Now I’ve messed up royally! After making the change, I ran the script on my CALENDAR! Any idea how to undo that?! (I’ll be getting out of VBA after this I think)
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I don't think I've done that before... <g> but will see if there is a second property we can read - there should be something.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
The subject is in the appointment 3 times... once as a conversation topic. Using that as the propertyAccessor in the oops code should work. I'll test it.
2857
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
:( Conversation index works - but only for meetings.

I changed strheader to strtemp and removed the regex.
Code:
strTemp = propertyAccessor.GetProperty("http://schemas.microsoft.com/mapi/proptag/0x0070001E")
aItem.Subject = strTemp
 
Last edited:
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
Good morning Diane.

I have to fix one more thing but I'm going to start a fresh thread with it.

thanks!
 
Similar threads
Thread starter Title Forum Replies Date
T Why does outlook 2010 convert only some forum notifications to plain text? Using Outlook 0
B VBA to convert email to task, insert text of email in task notes, and attach copy of original email Outlook VBA and Custom Forms 4
E To convert imported data to custom fields in Task list Outlook VBA and Custom Forms 1
P How do I convert outlook “to-do” items to “tasks” Outlook VBA and Custom Forms 1
I Convert POP3 account (PST) to IMAP (.OST) Using Outlook 3
S problem with convert Using Outlook 1
I Outlook 2016 64bit - on receipt convert emails into PDF and save Outlook VBA and Custom Forms 2
C convert an .ost to .pst Using Outlook 3
D The way to convert ost to pst Using Outlook 2
J Outlook 2013 how to convert 2013 OST file into an another format, i m using outlook 2013 versions. Using Outlook 1
sneaky30 convert text to date Outlook VBA and Custom Forms 1
P Is it possible to convert address book to "Auto-Complete List" (NK2)? Using Outlook 5
Diane Poremsky Convert an Offline File (.ost) to a Personal File (.pst) New Slipstick.com Articles 0
S How to do I convert OST file to PST? Exchange Server Administration 3
J convert .pst to .eml, how is it possible? Using Outlook 1
M convert/import a customized record into the default "Account" record BCM (Business Contact Manager) 0
V Check/convert to emailaddresses Outlook VBA and Custom Forms 11
R Convert Access table to pst Using Outlook 1
M Outlook 2013 won't convert Excel contacts into Outlook contacts using my custom form Using Outlook 3
L Convert Distribution List of Contacts to Single Contacts Using Outlook 6
G Is there any way to convert outlook 2003 to outlook 2007 Using Outlook 5
D Outlook contacts no in address book - 2002 pst file convert to 2007 pst file? Using Outlook 0
P Outlook 2002 - How to upgrade to 2003 and convert PST from ANSI to Unicode? Using Outlook 7
K Outlook Contact Group - can you convert to a .vcf? Using Outlook 1
P How can I convert an Outlook 2010 folder to a .pdf with active links like I could in Outlook 2007? Using Outlook 3
J Is it possible to convert a shared calender in Outlook to a ical version that can be subscribed to by confluence. Using Outlook 1
O convert OE Address book folders/subgroups to Outlook 2010? Using Outlook 4
O convert Outlook Express to Outlook 2010 Using Outlook 1
P Can I convert outlook emails to windows live? Using Outlook 1
C convert windows live mail to outlook 2010 Using Outlook 4
A Outlook 2003: convert all RTF emails to HTML Outlook VBA and Custom Forms 1
J How to convert BCM contacts to normal Outlook contacts BUT... BCM (Business Contact Manager) 2
A Convert client Outlook 2007 .ost to Outlook 2007 .pst Using Outlook 8
G Tasks - convert email to task & attach email Outlook VBA and Custom Forms 6
A Re: Convert Oportunity to Project? BCM (Business Contact Manager) 3
B convert VBA code to Add-in Outlook VBA and Custom Forms 1
Q How tough is it to convert VBA to Addin 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 14
M Outlook 2013 Replace Subject with Conversation (a "hidden" value). Outlook VBA and Custom Forms 0
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

Similar threads

Top