Solved

Isolating on Unique Identifier from Common Source

Posted on 2004-04-15
29
436 Views
Last Modified: 2008-02-01
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?
0
Comment
Question by:eetheredge
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 16
  • 13
29 Comments
 
LVL 13

Expert Comment

by:stefri
ID: 10836957
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
 
LVL 1

Author Comment

by:eetheredge
ID: 10837467
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
 
LVL 13

Expert Comment

by:stefri
ID: 10839313
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:eetheredge
ID: 10840623
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
 
LVL 13

Expert Comment

by:stefri
ID: 10841869
I do not understand the notion of unique identifier

Stefri
0
 
LVL 1

Author Comment

by:eetheredge
ID: 10842050
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
 
LVL 13

Expert Comment

by:stefri
ID: 10846250
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
 
LVL 13

Expert Comment

by:stefri
ID: 10850746
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
 
LVL 1

Author Comment

by:eetheredge
ID: 10850952
It's the same message going to three different addresses at the same time.  Only one msg is created.
0
 
LVL 1

Author Comment

by:eetheredge
ID: 10850966
I am testing your suggestion.  However, not much is coming from the courts today.
0
 
LVL 13

Expert Comment

by:stefri
ID: 10851068
Send yourself a mail....(rule modified to be fired on your name)

stefri
0
 
LVL 13

Expert Comment

by:stefri
ID: 10851080
Keep me informed. time to go to bed in my time zone...quite late
stefri
0
 
LVL 1

Author Comment

by:eetheredge
ID: 10855050
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
 
LVL 1

Author Comment

by:eetheredge
ID: 10855095
I see what it is doing.  It seems to be converting the Message-ID.  I will test further.
0
 
LVL 13

Expert Comment

by:stefri
ID: 10860424
could you post what's happening
mileage is a string read/write with no constraint
Stefri
0
 
LVL 1

Author Comment

by:eetheredge
ID: 10860727
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
 
LVL 13

Expert Comment

by:stefri
ID: 10860752
how are set Macros security? Tools/Macros/Security/ set to Medium
Do you have a warning when starting OL
Stefri
0
 
LVL 1

Author Comment

by:eetheredge
ID: 10860810
I already had lowered it to Medium.
0
 
LVL 13

Expert Comment

by:stefri
ID: 10861777
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
 
LVL 13

Expert Comment

by:stefri
ID: 10861836
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
 
LVL 1

Author Comment

by:eetheredge
ID: 10861961
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
 
LVL 13

Expert Comment

by:stefri
ID: 10862066
Could you post the full headers

stefri
0
 
LVL 1

Author Comment

by:eetheredge
ID: 10862171
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
 
LVL 13

Expert Comment

by:stefri
ID: 10862634
I would prefer the header fom Fed Bank
Modify the IP addresses and your name
Stefri
0
 
LVL 13

Expert Comment

by:stefri
ID: 10862662
Did you find: 77E8E8FB-B3D7-43FE-B173-7CB865 in the message header from Fed Bank
Stefri
0
 
LVL 1

Author Comment

by:eetheredge
ID: 10862925
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
 
LVL 1

Author Comment

by:eetheredge
ID: 10862949
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
 
LVL 13

Accepted Solution

by:
stefri earned 500 total points
ID: 10863993
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
 
LVL 13

Expert Comment

by:stefri
ID: 10892207
So, we finally succeeded..

Stefri
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Mailbox Overload?
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question