eetheredge
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?
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?
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
ASKER
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
Stefri
ASKER
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.M APIUtils")
Set MailItem = Item '
internetHeadersField = &H7D001E ' &HC1F001E
internetHeaders = utils.HrGetOneProp(MailIte m.MAPIOBJE CT, 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
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.M
Set MailItem = Item '
internetHeadersField = &H7D001E ' &HC1F001E
internetHeaders = utils.HrGetOneProp(MailIte
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.M APIUtils")
Set MailItem = Item '
internetHeadersField = &H7D001E ' &HC1F001E
internetHeaders = utils.HrGetOneProp(MailIte m.MAPIOBJE CT, 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
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.M
Set MailItem = Item '
internetHeadersField = &H7D001E ' &HC1F001E
internetHeaders = utils.HrGetOneProp(MailIte
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
ASKER
It's the same message going to three different addresses at the same time. Only one msg is created.
ASKER
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
stefri
Keep me informed. time to go to bed in my time zone...quite late
stefri
stefri
ASKER
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?
ASKER
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
mileage is a string read/write with no constraint
Stefri
ASKER
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
Do you have a warning when starting OL
Stefri
ASKER
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
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.Jav aMail.root @ns5.exper ts-exchang e.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.Jav aMail.root @ns5.exper ts-exchang e.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
...... 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
for <wwwww@yyyyy.zzz>; 19 Apr 2004 15:54:09 -0000
Received: from [64.156.132.253] (helo=ns5.experts-exchange
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.Jav
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:
X-Spam-Checker-Version: SpamAssassin 2.61 (1.212.2.1-2003-12-09-exp)
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.Jav
Stefri
PS: it is 07:45 PM my time
ASKER
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-7C B865
77E8E8FB-B3D7-43FE-B173-7C
Could you post the full headers
stefri
stefri
ASKER
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.f ed1rmmtai1 2.cox.net@ ns5.expert s-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.Ja vaMail.roo t@ns5.expe rts-exchan ge.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
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)
id <20040419181151.URJI2018.f
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.Ja
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:
X-Mailer: Experts Exchange
I would prefer the header fom Fed Bank
Modify the IP addresses and your name
Stefri
Modify the IP addresses and your name
Stefri
Did you find: 77E8E8FB-B3D7-43FE-B173-7C B865 in the message header from Fed Bank
Stefri
Stefri
ASKER
Return-Path: <BKECF_LiveDB@txnb.uscourt s.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. lakermmtai 18.cox.net @txnbei.tx nb.uscourt s.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
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)
id <20040419194649.YZCX20276.
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
To: BKECF_LiveDB@txnb.uscourts
Message-Id: <3813271@txnb.uscourts.gov
Subject: 01-70586-hdh13 "Close bankruptcy case"
Content-Type: text/html
ASKER
77E8E8FB-B3D7-43FE-B173-7C B865 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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
So, we finally succeeded..
Stefri
Stefri
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