Link to home
Start Free TrialLog in
Avatar of eetheredge
eetheredgeFlag for United States of America

asked on

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?
Avatar of stefri
stefri
Flag of France image

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
Avatar of eetheredge

ASKER

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.  
Again, if you use Exchange, you can set a delivery options AND keep a copy of the incoming mails in the main mailbox.

Stefri
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.
I do not understand the notion of unique identifier

Stefri
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?
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
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
It's the same message going to three different addresses at the same time.  Only one msg is created.
I am testing your suggestion.  However, not much is coming from the courts today.
Send yourself a mail....(rule modified to be fired on your name)

stefri
Keep me informed. time to go to bed in my time zone...quite late
stefri
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?
I see what it is doing.  It seems to be converting the Message-ID.  I will test further.
could you post what's happening
mileage is a string read/write with no constraint
Stefri
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.  
how are set Macros security? Tools/Macros/Security/ set to Medium
Do you have a warning when starting OL
Stefri
I already had lowered it to Medium.
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
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
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
Could you post the full headers

stefri
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

I would prefer the header fom Fed Bank
Modify the IP addresses and your name
Stefri
Did you find: 77E8E8FB-B3D7-43FE-B173-7CB865 in the message header from Fed Bank
Stefri
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
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.
ASKER CERTIFIED SOLUTION
Avatar of stefri
stefri
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
So, we finally succeeded..

Stefri