Re: binary compare two mailitems

maybe this is what you're looking for:

EntryID Property

Returns a String representing the unique entry ID of the object. This
property corresponds to the MAPI property PR_ENTRYID. MAPI systems assign a
permanent, unique ID string when an object is created that does not change
from one MAPI session to another. The EntryID property is not set for an
Outlook item until it is saved or sent. Also, the EntryID changes when an
item is moved into another folder. Read-only.

"Jenny Tam" <yinjentam@hotmail.com> wrote in message
news:d6b9e062.0306301609.e05a5c4@posting.google.com...
> Is there such thing as a unique identifier to an email message? We
> are building a COM addin such that the user can export any outlook
> message to our SQL database. Let's say if an email is sent to 5
> people, and one of these 5 has exported the email to the database, we
> want to make sure the rest of the recipients won't be able to export
> the same email again to the same database. If we need to compare
> property by property, the performance will be extremely slow and
> unacceptable.
>
> Any suggestions or hints are very much appreciated!
> Jenny
>
>
>
> "Dmitry Streblechenko" <dmitry@dimastr.com> wrote in message
news:<OvZwGkcODHA.1608@TK2MSFTNGP11.phx.gbl>...
> > There is no such thing as binary comparison of two messages, you can
only do
> > that property by property. Do you also compare the recipients? If a
message
> > has no body, no subject and the recipients are the same, for all
practical
> > purposes from the end-user point of view the two messages are the same.
> >
> > Dmitry Streblechenko (MVP)
> > http://www.dimastr.com/
> > OutlookSpy - Outlook, CDO
> > and MAPI Developer Tool
> >
> >
> > "flekso" <taurus@email.hinet.hr> wrote in message
> > news:eupweKKODHA.2788@TK2MSFTNGP10.phx.gbl...
> > > i need to binary compare them for my duplicate remove routine which is
> > > working quite nice now but fails on some specific comparisons that
involve
> > > things like no body, attachments and such - is there a way?
> > >
> > > thanks
> > >
> > >

Good point! I could also compare those properties and probably the
size of the email message.

Could you please elaborate more about how to use MD5 signature? I
don't know anything about that at all.

Thanks,
jenny


alien_solutions@hotmail.com (Allen Morgan) wrote in message news:<60c98f79.0307011012.3d0092ba@posting.google.com>...
> Try using the MD5 signature. I have been saving messages as HTML and
> only putting things in it that will be the same for all recipients
> e.g. the time it was sent will be the same
> Who from, who to, who CC'd
>
> Not BCC or Received Time or whether it was replyed to.
>
> Attachments are also saved and their MD5 signatures noted and thus
> avoiding duplication.
>
> Can anyone see a problem with this? For records compiance I don't know
> if anyone has an opinion on Outlook mails? The format of the mail has
> changed since it came in off the internet so therefore changing it
> once again (and not losing any info) should make a emailing archiving
> system valid??
>
> Allen Morgan
>
> "flekso" <taurus@email.hinet.hr> wrote in message news:<OhgcEi6PDHA.2052@TK2MSFTNGP11.phx.gbl>...
> > maybe this is what you're looking for:
> >
> > EntryID Property
> >
> > Returns a String representing the unique entry ID of the object. This
> > property corresponds to the MAPI property PR_ENTRYID. MAPI systems assign a
> > permanent, unique ID string when an object is created that does not change
> > from one MAPI session to another. The EntryID property is not set for an
> > Outlook item until it is saved or sent. Also, the EntryID changes when an
> > item is moved into another folder. Read-only.
> >
> > "Jenny Tam" <yinjentam@hotmail.com> wrote in message
> > news:d6b9e062.0306301609.e05a5c4@posting.google.com...
> > > Is there such thing as a unique identifier to an email message? We
> > > are building a COM addin such that the user can export any outlook
> > > message to our SQL database. Let's say if an email is sent to 5
> > > people, and one of these 5 has exported the email to the database, we
> > > want to make sure the rest of the recipients won't be able to export
> > > the same email again to the same database. If we need to compare
> > > property by property, the performance will be extremely slow and
> > > unacceptable.
> > >
> > > Any suggestions or hints are very much appreciated!
> > > Jenny
> > >
> > >
> > >
> > > "Dmitry Streblechenko" <dmitry@dimastr.com> wrote in message
> news:<OvZwGkcODHA.1608@TK2MSFTNGP11.phx.gbl>...
> > > > There is no such thing as binary comparison of two messages, you can
> only do
> > > > that property by property. Do you also compare the recipients? If a
> message
> > > > has no body, no subject and the recipients are the same, for all
> practical
> > > > purposes from the end-user point of view the two messages are the same.
> > > >
> > > > Dmitry Streblechenko (MVP)
> > > > http://www.dimastr.com/
> > > > OutlookSpy - Outlook, CDO
> > > > and MAPI Developer Tool
> > > >
> > > >
> > > > "flekso" <taurus@email.hinet.hr> wrote in message
> > > > news:eupweKKODHA.2788@TK2MSFTNGP10.phx.gbl...
> > > > > i need to binary compare them for my duplicate remove routine which is
> > > > > working quite nice now but fails on some specific comparisons that
> involve
> > > > > things like no body, attachments and such - is there a way?
> > > > >
> > > > > thanks
> > > > >
> > > > >