If it were me I would just use the CATCHALLMAILS feature of Declude and COPY them to an archival e-mail address and then just burn the inbox of that address to disk once a month.
----- Original Message ----- From: "Rick Davidson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 27, 2004 4:29 PM Subject: Re: [Declude.JunkMail] Determining a BCC Recipient > Essentially the good folks at Enron and WorldComm brought us the > Sarbanes-Oxley Act or SOX for short. Public companies have to keep a record > of all communications, the details of this are vague but mostly apply to the > money people and decision makers. Since we cant selectively catch that > specific traffic we have to grab it all. > > Basicly all mail must be archived including the attachments and all mail > must be retrievable in a reasonable amount of time, thats about it. > > We were considering stripping the attachments and storing them in a > directory structure and storing the email text data in the sql database. > Separate fields for the date, to, from, subject, the entire D file and the > attachment names and their location. > > We figure we can get decent compression and searchabiltiy with the text info > but the biggest hurdle is the attachments and being a Title company we have > alot of large attachments to deal with. > > > Rick Davidson > National Systems Manager > North American Title Group > - > ----- Original Message ----- > From: "Matt" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, October 27, 2004 3:53 PM > Subject: Re: [Declude.JunkMail] Determining a BCC Recipient > > > > That's funny that you should ask. I just coded that one up in VBScript > > this last weekend. I even managed to decode base64 text attachments, > > remove quoted-printable encoding, and strip out all of the HTML code. If > > this is for archiving according to legal requirement, the attachments > > would probably be necessary however. > > > > Sandy had some good recommendations on how to archive. Maybe if you > > shared your requirements with the list, someone would have some > > recommendations as to how to approach this a better way. > > > > Matt > > > > > > > > Rick Davidson wrote: > > > >> ok thanks Matt, we do have some programmers on staff here but I will sure > >> conscript your help if we brick wall. Regardless of where it is stored > >> its going to be a massive amount of data, my initial samplings show 1.5 > >> to 2GB per day. Yikes! > >> > >> You wouldnt happen to know how to parse mime types and remove attachments > >> would you? :-) > >> > >> Rick Davidson > >> National Systems Manager > >> North American Title Group > >> - > >> ----- Original Message ----- From: "Matt" <[EMAIL PROTECTED]> > >> To: <[EMAIL PROTECTED]> > >> Sent: Wednesday, October 27, 2004 2:58 PM > >> Subject: Re: [Declude.JunkMail] Determining a BCC Recipient > >> > >> > >>> That's going to be one massive database :) I've become quite the > >>> VBScripter as of late (if that's something to brag about), so let me > >>> know if you need any help. > >>> > >>> Matt > >>> > >>> Rick Davidson wrote: > >>> > >>>> Thanks Matt, > >>>> COPYFILE is working perfectly, now its just a matter of writing the > >>>> program to parse and insert it into the SQL database. > >>>> > >>>> Rick Davidson > >>>> National Systems Manager > >>>> North American Title Group > >>>> - > >>>> ----- Original Message ----- From: "Matt" <[EMAIL PROTECTED]> > >>>> To: <[EMAIL PROTECTED]> > >>>> Sent: Tuesday, October 26, 2004 5:15 PM > >>>> Subject: Re: [Declude.JunkMail] Determining a BCC Recipient > >>>> > >>>> > >>>>> Rick, > >>>>> > >>>>> This information is in the Q* file. If you use the COPYFILE action, > >>>>> it will keep both the D* and the Q* file. The only issue is that the > >>>>> Declude headers are lost and each message is kept separately and not > >>>>> viewable without a special application like spamreview. IMO, this is > >>>>> appropriate for archiving due to legal requirement, but not for doing > >>>>> review. > >>>>> > >>>>> If you want to handle this in a different way by just sending to a > >>>>> mailbox, you can use a WARN action with the %ALLRECIPS% variable which > >>>>> will contain the BCC addresses as well. For instance, you could do > >>>>> the following: > >>>>> > >>>>> TESTNAME WARN X-RECIPIENTS: <%ALLRECIPS%> > >>>>> > >>>>> This of course exposes the BCC info to all that might view the > >>>>> headers. > >>>>> > >>>>> Matt > >>>>> > >>>>> > >>>>> Rick Davidson wrote: > >>>>> > >>>>>> I am looking at creating our own email archiving solution using sql, > >>>>>> the main hurdle is how to handle and email sent to a user using BCC. > >>>>>> Is there a way to use Declude to include that info in a recipient > >>>>>> x-header? > >>>>>> > >>>>>> If I send myself using only the BCC field the header contains only > >>>>>> this > >>>>>> > >>>>>> From: "Rick Davidson" <[EMAIL PROTECTED]> > >>>>>> To: <Undisclosed-Recipient:;> > >>>>>> Subject: test > >>>>>> > >>>>>> I assume the BCC info is lost once the message hits the senders SMTP > >>>>>> server correct? > >>>>>> > >>>>>> Rick Davidson > >>>>>> National Systems Manager > >>>>>> North American Title Group > >>>>>> - > >>>>>> > >>>>>> --- > >>>>>> [This E-mail was scanned for viruses by Declude Virus > >>>>>> (http://www.declude.com)] > >>>>>> > >>>>>> --- > >>>>>> This E-mail came from the Declude.JunkMail mailing list. To > >>>>>> unsubscribe, just send an E-mail to [EMAIL PROTECTED], and > >>>>>> type "unsubscribe Declude.JunkMail". The archives can be found > >>>>>> at http://www.mail-archive.com. > >>>>>> > >>>>>> > >>>>> > >>>>> -- > >>>>> ===================================================== > >>>>> MailPure custom filters for Declude JunkMail Pro. > >>>>> http://www.mailpure.com/software/ > >>>>> ===================================================== > >>>>> > >>>>> --- > >>>>> [This E-mail was scanned for viruses by Declude Virus > >>>>> (http://www.declude.com)] > >>>>> > >>>>> --- > >>>>> This E-mail came from the Declude.JunkMail mailing list. To > >>>>> unsubscribe, just send an E-mail to [EMAIL PROTECTED], and > >>>>> type "unsubscribe Declude.JunkMail". The archives can be found > >>>>> at http://www.mail-archive.com. > >>>>> > >>>> > >>>> > >>>> --- > >>>> [This E-mail was scanned for viruses by Declude Virus > >>>> (http://www.declude.com)] > >>>> > >>>> --- > >>>> This E-mail came from the Declude.JunkMail mailing list. To > >>>> unsubscribe, just send an E-mail to [EMAIL PROTECTED], and > >>>> type "unsubscribe Declude.JunkMail". The archives can be found > >>>> at http://www.mail-archive.com. > >>>> > >>>> > >>> > >>> -- > >>> ===================================================== > >>> MailPure custom filters for Declude JunkMail Pro. > >>> http://www.mailpure.com/software/ > >>> ===================================================== > >>> > >>> --- > >>> [This E-mail was scanned for viruses by Declude Virus > >>> (http://www.declude.com)] > >>> > >>> --- > >>> This E-mail came from the Declude.JunkMail mailing list. To > >>> unsubscribe, just send an E-mail to [EMAIL PROTECTED], and > >>> type "unsubscribe Declude.JunkMail". The archives can be found > >>> at http://www.mail-archive.com. > >>> > >> > >> > >> --- > >> [This E-mail was scanned for viruses by Declude Virus > >> (http://www.declude.com)] > >> > >> --- > >> This E-mail came from the Declude.JunkMail mailing list. To > >> unsubscribe, just send an E-mail to [EMAIL PROTECTED], and > >> type "unsubscribe Declude.JunkMail". The archives can be found > >> at http://www.mail-archive.com. > >> > >> > > > > -- > > ===================================================== > > MailPure custom filters for Declude JunkMail Pro. > > http://www.mailpure.com/software/ > > ===================================================== > > > > --- > > [This E-mail was scanned for viruses by Declude Virus > > (http://www.declude.com)] > > > > --- > > This E-mail came from the Declude.JunkMail mailing list. To > > unsubscribe, just send an E-mail to [EMAIL PROTECTED], and > > type "unsubscribe Declude.JunkMail". The archives can be found > > at http://www.mail-archive.com. > > > > > > > --- > [This E-mail was scanned for viruses by Declude Virus (http://www.declude.com)] > > --- > This E-mail came from the Declude.JunkMail mailing list. To > unsubscribe, just send an E-mail to [EMAIL PROTECTED], and > type "unsubscribe Declude.JunkMail". The archives can be found > at http://www.mail-archive.com. > ----------------------------------------------------------------------- > Sign up for virus-free and spam-free e-mail with Nexus Technology Group > http://www.nexustechgroup.com/mailscan > > ----------------------------------------------------------------------- Sign up for virus-free and spam-free e-mail with Nexus Technology Group http://www.nexustechgroup.com/mailscan --- [This E-mail was scanned for viruses by Declude Virus (http://www.declude.com)] --- This E-mail came from the Declude.JunkMail mailing list. To unsubscribe, just send an E-mail to [EMAIL PROTECTED], and type "unsubscribe Declude.JunkMail". The archives can be found at http://www.mail-archive.com.