To Purge Or Not To Purge...
Apr 14, 2005After using the good old SQL statement, I have created over 400 email that were sent to people. Each person responds to that and now I need to purge out of the email the data that I cannot use.
Here is what I have come down to. I can save all the email at once into a single text file. The only data I need is in between two quotes "xxx". Each email has that in it only once. Is there a better way to isolate that data than just highlighting and deleting text that is outside of that?
I am going to show you an example:
From: Mailbox Entitlement Review
Sent: Wednesday, April 13, 2005 4:02 PM
To: Smith, John
Subject: IMPORTANT: Your access to generic mailbox
In accordance with CITMP Policy, Messaging Systems Support requires a semi-annual review of user's with access to group mailboxes.
You are receiving this email because you have been identified as the owner of "Project Management Office" group mailbox. Please review the entitlements below to ensure that each person is permitted to access and send from this mailbox.
In order for us to be compliant with our policies, we are requesting that you review the permissions on this account and answer the following questions:
1. Is this Group Mailbox account still needed to conduct business?
2. Will you remain as the owner of this mailbox? If not, please send us the unique email address of the new owner.
3. Please verify that the permissions are correct. Please advise us of any permission changes.
I have highlighted what I will need to extract. Is there any way of getting this data out?
Again, I have over 400 email. This would be tedious (understatement) to do by hand. Any help you can give will go a long, long way. The last post I put up, someone replied with a piece of code. Had the two words "Inner Join" I ran from there. Worked like a champ. Not specifically the code that was posted up, just the idea. I don't even have an idea.