Solved

Isolating on Unique Identifier from Common Source

Posted on 2004-04-15
29
390 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
  • 16
  • 13
29 Comments
 
LVL 13

Expert Comment

by:stefri
Comment Utility
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
Comment Utility
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
Comment Utility
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
 
LVL 1

Author Comment

by:eetheredge
Comment Utility
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
Comment Utility
I do not understand the notion of unique identifier

Stefri
0
 
LVL 1

Author Comment

by:eetheredge
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
I am testing your suggestion.  However, not much is coming from the courts today.
0
 
LVL 13

Expert Comment

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

stefri
0
 
LVL 13

Expert Comment

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

Author Comment

by:eetheredge
Comment Utility
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
Comment Utility
I see what it is doing.  It seems to be converting the Message-ID.  I will test further.
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 13

Expert Comment

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

Author Comment

by:eetheredge
Comment Utility
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
Comment Utility
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
Comment Utility
I already had lowered it to Medium.
0
 
LVL 13

Expert Comment

by:stefri
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Could you post the full headers

stefri
0
 
LVL 1

Author Comment

by:eetheredge
Comment Utility
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
Comment Utility
I would prefer the header fom Fed Bank
Modify the IP addresses and your name
Stefri
0
 
LVL 13

Expert Comment

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

Author Comment

by:eetheredge
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
So, we finally succeeded..

Stefri
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
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: …

762 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now