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!
 
Thread starter Similar threads Forum Replies Date
T Why does outlook 2010 convert only some forum notifications to plain text? Using Outlook 2
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
S In Microsoft Outlook 2003 I have a Adobe PDF icon, to convert emails to pdf and then save them in the correct folder/file and it is not working anymor Using Outlook 1
S In Microsoft Outlook 2003 I have a Adobe PDF icon, to convert emails to pdf and then save them in the correct folder/file and it is not working anymor Using Outlook 1
D How do I convert Entourage for Mac data to Outlook for Windows Using Outlook 2
F I used the MS software "set_up_outlookset" to convert my Godaddy.com web mail to MS Outlook 2010, ho Using Outlook 2
N auto convert HTML to Plain Text Using Outlook 1
S Convert from Outlook 2003 on old computer (XP) to Outlook 2010 on new PC Win 7 Using Outlook 1
G Convert Linked mailbox to User mailbox - (Disable-mailbox -identity) Exchange Server Administration 2
I How to convert appointments to meetings in Outlook 2010 Using Outlook 8
M File folders lost when I convert form Outlook 2000 to 2007 Using Outlook 1
S How to convert .pst file in to Exchange 2010 mailboxes. Exchange Server Administration 4
V Convert mails from Entourage to Outlook Using Outlook 2
E Convert from ldap to opath when migrating from Exchange 2003 to Exchange 2010 Exchange Server Administration 6
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
R Disable conversation thread from replying of recipients in the same subject. Please help Using Outlook 0
Similar threads


















































Top