To Purge Or Not To Purge...

Apr 14, 2005

After 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.

View Replies


ADVERTISEMENT

Creating A Commend Button To Purge All Data

Mar 22, 2005

Dear All:

I have a form based on a query. Is there a way to create a command button to delete all data? In addition, when this button is pressed, a pop-up message should appear to say "ARE YOU SURE YOU WANT TO DO THIS?".

Thanking in advance,

Dion

View 6 Replies View Related

Creating A Commend Button To Purge All Data

Aug 16, 2007

Bumping!

Id love to use this code, but I need it to allow for parameters. IE: I need a form that deletes job numbers x through y. How would I arrange a form to do this?

Thanks so much guys!!

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved