Isolating on Unique Identifier from Common Source

Let me explain the situation.  

First, we work with the Federal Bankruptcy courts and we receive documents from the courts electronically in the form on an email containing links to the documents on the court system's computer.  For failover purposes, we have the ability to configure as many email addresses as we wish to have the notices sent to.  Right now, we have three different email addresses.  

What I am wanting to be able to do is to establish a way of reconciling between the three addresses  to ensure we receive the messages and to also rebuild in case the main account goes down.

Any suggestions?
LVL 1
eetheredgeAsked:
Who is Participating?
 
stefriConnect With a Mentor Commented:
If you right click the court mail, then Options, do you have an internet header showing?
Stefri
Just notice:
Courts mail contains ->     Message-Id:
I am testing against ->      Message-ID:
Do you notice?

Modify this:
MessIdPosStart = InStr(1, internetHeaders, "Message-ID:", vbTextCompare) to
MessIdPosStart = InStr(1, lcase(internetHeaders), "message-id:", vbTextCompare) to get rid of upper and lower case mixing

Stefri
0
 
stefriCommented:
You mean Federal Bankrupcy can send the same mail to the three addresses or one  mail sent to one address, another one to the second address, etc... randomly ?
Do you have an exchange server?
You may create a forth mailbox where would be autoforwarded the mails received at the three email addresses you have already setup (autoforwrd can be handled by Exchange server automatically)
Creating a view displaying mails grouped by Conversation topic in his forth mailbox would show one, two or three instances of the same mail

Stefri
0
 
eetheredgeAuthor Commented:
We cannot autoforward because the main account has an add-in which processes the message, downloads the document(s) and establishes an entry into our document que to be worked into the case on our system.  
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
stefriCommented:
Again, if you use Exchange, you can set a delivery options AND keep a copy of the incoming mails in the main mailbox.

Stefri
0
 
eetheredgeAuthor Commented:
stefri, your suggestion does not establish a way of reconciling between the three accounts.  Using Exchange, which we already do, does not give me a unique identifier which is what I asked in the first place.
0
 
stefriCommented:
I do not understand the notion of unique identifier

Stefri
0
 
eetheredgeAuthor Commented:
I have found message-id in the internet header.  Is there a way to extract the message-id and make it a field in Outlook?
0
 
stefriCommented:
I am stuck on adding a new field to an incoming message, otherwise the Internet Header can be obtained with VBA and Redemption software + a rule which is fired when a mail is received from Fed Bank.. which would run the following script

Dowload an install Redemption http://www.dimastr.com/redemption/download.htm
Open VBA (AltF11)
Cu&Paste code below in ThisOutlookSession right pane window



Sub msgInternetHeader(Item As Outlook.MailItem)
Dim utils, MailItem, internetHeadersField , internetHeaders, msgId, MessIdPosStart, MessIdPosEnd
Set utils = CreateObject("Redemption.MAPIUtils")

Set MailItem = Item  '
internetHeadersField = &H7D001E ' &HC1F001E
internetHeaders = utils.HrGetOneProp(MailItem.MAPIOBJECT, internetHeadersField  )
MessIdPosStart = InStr(1, internetHeaders, "Message-ID:", vbTextCompare)
MessIdPosEnd = InStr(MessIdPosStart, internetHeaders, ">", vbTextCompare)
msgId = Trim(Mid(internetHeaders, MessIdPosStart + Len("Message-ID:"), _
                 1 + MessIdPosEnd - MessIdPosStart - Len("Message-ID:")))
MsgBox msgId
set utils = Nothing
End Sub


Creat a rule from blank
check a new mail arrives
from people
Run a script
Select msgInternetHeader from the list
We could assign msgId to a Category but your Category List would blow out quicly

I am ashamed to say that I am stuck on adding a new field to an incoming message so other Gurus, Wizards, Sage and Genius, I need your help to solve eetheredge's problem....

Stefri
0
 
stefriCommented:
Got it...
We only have to use an existing Field such as Mileage:

Sub msgInternetHeader(Item As Outlook.MailItem)
Dim utils, MailItem, internetHeadersField, internetHeaders, msgId, MessIdPosStart, MessIdPosEnd
Set utils = CreateObject("Redemption.MAPIUtils")

Set MailItem = Item  '
internetHeadersField = &H7D001E ' &HC1F001E
internetHeaders = utils.HrGetOneProp(MailItem.MAPIOBJECT, internetHeadersField)
MessIdPosStart = InStr(1, internetHeaders, "Message-ID:", vbTextCompare)
MessIdPosEnd = InStr(MessIdPosStart, internetHeaders, ">", vbTextCompare)
msgId = Trim(Mid(internetHeaders, MessIdPosStart + Len("Message-ID:"), _
                 1 + MessIdPosEnd - MessIdPosStart - Len("Message-ID:")))
Item.Mileage = msgId
Item.Save
Set utils = Nothing
End Sub
Customize current view to display Mileage field from Field Chooser (sectioon All Mails Items) . Drag and drop to view headers then group by this field.
I was wondering something: Fed Bank sends you one mail to three addresses at the same time or three deifferent mails at each email adddress
If the last is true, the Internet msgId will differ and you wont be able to reconcile

Stefri
0
 
eetheredgeAuthor Commented:
It's the same message going to three different addresses at the same time.  Only one msg is created.
0
 
eetheredgeAuthor Commented:
I am testing your suggestion.  However, not much is coming from the courts today.
0
 
stefriCommented:
Send yourself a mail....(rule modified to be fired on your name)

stefri
0
 
stefriCommented:
Keep me informed. time to go to bed in my time zone...quite late
stefri
0
 
eetheredgeAuthor Commented:
When I changed the end of the code to fill in the Mileage field.  I do not get the Message ID, I get something completely different.  What if I created a field and then changed the coding to match that created field?
0
 
eetheredgeAuthor Commented:
I see what it is doing.  It seems to be converting the Message-ID.  I will test further.
0
 
stefriCommented:
could you post what's happening
mileage is a string read/write with no constraint
Stefri
0
 
eetheredgeAuthor Commented:
For some reason the script is not running first so I split out it to run the script first and then store the message in a different folder.  
0
 
stefriCommented:
how are set Macros security? Tools/Macros/Security/ set to Medium
Do you have a warning when starting OL
Stefri
0
 
eetheredgeAuthor Commented:
I already had lowered it to Medium.
0
 
stefriCommented:
Very strange
How is set the rule which is supposed to run the script
On which term is it based
Do you use:
with specific words in sender's address or
with specific words in the header?
Stefri
0
 
stefriCommented:
Also
...... see what it is doing.  It seems to be converting the Message-ID.  I will test further.

I based my code the way I am receiving mails: for example, here is what I get from EE

Return-Path: <qna@experts-exchange.com>
Delivered-To: wwwww@yyyyy.zzz
Received: (qmail 8186 invoked by uid 0); 19 Apr 2004 15:54:09 -0000
Received: from unknown (HELO mx.mailix.net) ([444.555.666.777])
          (envelope-sender <qna@experts-exchange.com>)
          by 212.000.2.000(qmail-ldap-1.03) with SMTP
          for <wwwww@yyyyy.zzz>; 19 Apr 2004 15:54:09 -0000
Received: from [64.156.132.253] (helo=ns5.experts-exchange.com)
      by mx.mailix.net with esmtp (Exim 4.24-ND)
      id 1BFbM3-0000ut-Q1
      for wwwww@yyyyy.zzz; Mon, 19 Apr 2004 09:10:43 -0700
Received: from ns5.experts-exchange.com (localhost.localdomain [127.0.0.1])
      by ns5.experts-exchange.com (Postfix) with ESMTP id 409CA600122
      for <wwwww@yyyyy.zzz>; Mon, 19 Apr 2004 08:54:07 -0700 (PDT)
Message-ID: <3489663.1082390047259.JavaMail.root@ns5.experts-exchange.com>
Date: Mon, 19 Apr 2004 08:54:07 -0700 (PDT)
From: Experts Exchange <qna@experts-exchange.com>
To: stefri <wwwww@yyyyy.zzz>
Mime-Version: 1.0
X-Mailer: Experts Exchange
X-SA-Exim-Mail-From: qna@experts-exchange.com
Subject: Comment Added: Isolating on Unique Identifier from Common Source
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Spam-Checker-Version: SpamAssassin 2.61 (1.212.2.1-2003-12-09-exp) on
      southcarolina.backend
X-Spam-Report:
X-Spam-Status: No, hits=0.0 required=10.0 tests=none autolearn=no version=2.61
X-Spam-Level:
X-SA-Exim-Version: 3.1 (built Thu Oct 23 13:26:47 PDT 2003)
X-SA-Exim-Scanned: Yes
X-uvscan-result: clean (1BFbM3-0000ut-Q1)


As you can see: Message-ID: <3489663.1082390047259.JavaMail.root@ns5.experts-exchange.com> is between angle brackets. Is it the same for you? (check View/Options when reading the mail)

Stefri
PS: it is 07:45 PM my time
0
 
eetheredgeAuthor Commented:
The rule is based on the sender's email address.  I get the same message id structure as what you do.  For some reason, when I run the script manually, it works fine.  But if I don't then I get something like this:

77E8E8FB-B3D7-43FE-B173-7CB865
0
 
stefriCommented:
Could you post the full headers

stefri
0
 
eetheredgeAuthor Commented:
Return-Path: <qna@experts-exchange.com>
Received: from ns5.experts-exchange.com ([64.156.132.253])
          by fed1rmmtai12.cox.net
          (InterMail vM.6.01.03.02 201-2131-111-104-20040324) with ESMTP
          id <20040419181151.URJI2018.fed1rmmtai12.cox.net@ns5.experts-exchange.com>
          for <eetheredge1@cox.net>; Mon, 19 Apr 2004 14:11:51 -0400
Received: from ns5.experts-exchange.com (localhost.localdomain [127.0.0.1])
      by ns5.experts-exchange.com (Postfix) with ESMTP id 5D869600131
      for <eetheredge1@cox.net>; Mon, 19 Apr 2004 11:11:52 -0700 (PDT)
Message-ID: <11325176.1082398312378.JavaMail.root@ns5.experts-exchange.com>
Date: Mon, 19 Apr 2004 11:11:52 -0700 (PDT)
From: Experts Exchange <qna@experts-exchange.com>
To: eetheredge <eetheredge1@cox.net>
Subject: Comment Added: Isolating on Unique Identifier from Common Source
Mime-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Experts Exchange

0
 
stefriCommented:
I would prefer the header fom Fed Bank
Modify the IP addresses and your name
Stefri
0
 
stefriCommented:
Did you find: 77E8E8FB-B3D7-43FE-B173-7CB865 in the message header from Fed Bank
Stefri
0
 
eetheredgeAuthor Commented:
Return-Path: <BKECF_LiveDB@txnb.uscourts.gov>
Received: from txnbei.txnb.uscourts.gov ([208.27.202.124])
          by lakermmtai18.cox.net
          (InterMail vM.6.01.03.02 201-2131-111-104-20040324) with ESMTP
          id <20040419194649.YZCX20276.lakermmtai18.cox.net@txnbei.txnb.uscourts.gov>
          for <ch13-12westtex@cox.net>; Mon, 19 Apr 2004 15:46:49 -0400
Received: (from root@localhost)
      by txnbei.txnb.uscourts.gov (8.11.7p1+Sun/8.11.7) id i3JJV5B05449;
      Mon, 19 Apr 2004 14:31:05 -0500 (CDT)
Date: Mon, 19 Apr 2004 14:31:05 -0500 (CDT)
MIME-Version: 1.0
From: BKECF_LiveDB@txnb.uscourts.gov
To: BKECF_LiveDB@txnb.uscourts.gov
Message-Id: <3813271@txnb.uscourts.gov>
Subject: 01-70586-hdh13 "Close bankruptcy case"
Content-Type: text/html
0
 
eetheredgeAuthor Commented:
77E8E8FB-B3D7-43FE-B173-7CB865 came from a different message not from the courts.  The ones from the court do not have anything that shows up in the "Mileage" field when they first come in.  The field is blank and then I run the script manually and it works.
0
 
stefriCommented:
So, we finally succeeded..

Stefri
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.