ADSL - filter by email address to

  • Thread starter news.microsoft.com
  • Start date
Status
Not open for further replies.
N

news.microsoft.com

I'm having a problem filtering the sent items folder by

"urn:schemas:httpmail:to" LIKE '%emailaddress%' ... the search always

returns nothing. Same is true for "urn:schemas:mailheader:to" LIKE

'%emailaddress%'. I would use the displayto property but it is specific to

how an individual chooses to display a mail address unlike the email

address.

Any help in obtaining a filter to provide a list of emails sent to an

individual by email address would be appreciated.

Thanks
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Have your tried this:

urn:schemas:httpmail:displayto" LIKE '%emailaddress%'

Best regards

Michael Bauer

Am Mon, 2 Nov 2009 16:00:08 -0600 schrieb news.microsoft.com:


> I'm having a problem filtering the sent items folder by
> "urn:schemas:httpmail:to" LIKE '%emailaddress%' ... the search always
> returns nothing. Same is true for "urn:schemas:mailheader:to" LIKE
> '%emailaddress%'. I would use the displayto property but it is specific


to
> how an individual chooses to display a mail address unlike the email
> address.

> Any help in obtaining a filter to provide a list of emails sent to an
> individual by email address would be appreciated.

> Thanks
 
R

Randall

Yes. As I mentioned in my note this only looks at the display name which

can be anything and is not related to the actual email address.

What I am looking to do is this. Given an email address find all

correspondences to this email address.

Thanks

"Michael Bauer " <mb@mvps.org> wrote in message

news:10mr26ztm0gb2$.1xgb3entak4nm$.dlg@40tude.net...

> Have your tried this:

> urn:schemas:httpmail:displayto" LIKE '%emailaddress%'

> > Best regards
> Michael Bauer

> >

> Am Mon, 2 Nov 2009 16:00:08 -0600 schrieb news.microsoft.com:
>
> > I'm having a problem filtering the sent items folder by
> > "urn:schemas:httpmail:to" LIKE '%emailaddress%' ... the search always
> > returns nothing. Same is true for "urn:schemas:mailheader:to" LIKE
> > '%emailaddress%'. I would use the displayto property but it is specific

> to
> > how an individual chooses to display a mail address unlike the email
> > address.
>

>> Any help in obtaining a filter to provide a list of emails sent to an
> > individual by email address would be appreciated.
>

>> Thanks
 
S

Sue Mosher [MVP]

Just using the built-in view Filter dialog and its SQL tab, I came up with

this in Outlook 2007:

("http://schemas.microsoft.com/mapi/proptag/0x0e04001f" CI_STARTSWITH

'@gmail.com' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"

CI_STARTSWITH '@gmail.com')

Odd that it would be CI_STARTSWITH instead of CI_PHRASEMATCH, but that's

what the SQL tab had. And the view showed all the gmail addresses,

regardless of whether that string was in the display name.

Then I modified it to use LIKE in case it's an earlier version or unindexed,

but that returned only those items that had @gmail.com in the display name.

("http://schemas.microsoft.com/mapi/proptag/0x0e04001f" LIKE

'%@gmail.com%' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"

LIKE '%@gmail.com%')

These results make me wonder if the underlying email address is available

only for an indexed search.

Sue Mosher

"Randall" <r_no_spam_gouge@doncar_no_spam_sys.com> wrote in message

news:O9W$5WMXKHA.3504@TK2MSFTNGP05.phx.gbl...
> Yes. As I mentioned in my note this only looks at the display name which
> can be anything and is not related to the actual email address.

> What I am looking to do is this. Given an email address find all
> correspondences to this email address.

> Thanks

> "Michael Bauer " <mb@mvps.org> wrote in message
> news:10mr26ztm0gb2$.1xgb3entak4nm$.dlg@40tude.net...
>

>> Have your tried this:
>

>> urn:schemas:httpmail:displayto" LIKE '%emailaddress%'
> >

>
> > Am Mon, 2 Nov 2009 16:00:08 -0600 schrieb news.microsoft.com:
> >
> >> I'm having a problem filtering the sent items folder by
> >> "urn:schemas:httpmail:to" LIKE '%emailaddress%' ... the search always
> >> returns nothing. Same is true for "urn:schemas:mailheader:to" LIKE
> >> '%emailaddress%'. I would use the displayto property but it is specific

> > to
> >> how an individual chooses to display a mail address unlike the email
> >> address.
> >
>>> Any help in obtaining a filter to provide a list of emails sent to an
> >> individual by email address would be appreciated.
 
R

Randall

Thanks for the info Sue ... but when I am performing the same search it

appears to only be returning messages with the specified email address in

the to or cc fields ... and not returning those for the same email address

that only displayed a name.

Was hoping that was the answer as I was unaware that the sql was written for

searches where the sql is not explicitly provided.

One other question. Is this information, being able to filter folders, only

available where exhange is the mail sever?

Thanks in advance.

"Sue Mosher [MVP]" <suemvp@gmail.com> wrote in message

news:OaWxJiNXKHA.1372@TK2MSFTNGP02.phx.gbl...
> Just using the built-in view Filter dialog and its SQL tab, I came up with
> this in Outlook 2007:

> ("http://schemas.microsoft.com/mapi/proptag/0x0e04001f" CI_STARTSWITH
> '@gmail.com' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"
> CI_STARTSWITH '@gmail.com')

> Odd that it would be CI_STARTSWITH instead of CI_PHRASEMATCH, but that's
> what the SQL tab had. And the view showed all the gmail addresses,
> regardless of whether that string was in the display name.

> Then I modified it to use LIKE in case it's an earlier version or
> unindexed, but that returned only those items that had @gmail.com in the
> display name.

> ("http://schemas.microsoft.com/mapi/proptag/0x0e04001f" LIKE
> '%@gmail.com%' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"
> LIKE '%@gmail.com%')

> These results make me wonder if the underlying email address is available
> only for an indexed search.
> > Sue Mosher
> > >

> "Randall" <r_no_spam_gouge@doncar_no_spam_sys.com> wrote in message
> news:O9W$5WMXKHA.3504@TK2MSFTNGP05.phx.gbl...
> > Yes. As I mentioned in my note this only looks at the display name which
> > can be anything and is not related to the actual email address.
>

>> What I am looking to do is this. Given an email address find all
> > correspondences to this email address.
>

>> Thanks
>

>> "Michael Bauer " <mb@mvps.org> wrote in message
> > news:10mr26ztm0gb2$.1xgb3entak4nm$.dlg@40tude.net...
> >
>>> Have your tried this:
> >
>>> urn:schemas:httpmail:displayto" LIKE '%emailaddress%'
> >>

> >
> >> Am Mon, 2 Nov 2009 16:00:08 -0600 schrieb news.microsoft.com:
> >
>>>> I'm having a problem filtering the sent items folder by
> >>> "urn:schemas:httpmail:to" LIKE '%emailaddress%' ... the search always
> >>> returns nothing. Same is true for "urn:schemas:mailheader:to" LIKE
> >>> '%emailaddress%'. I would use the displayto property but it is
> >>> specific
> >> to
> >>> how an individual chooses to display a mail address unlike the email
> >>> address.
> >>
>>>> Any help in obtaining a filter to provide a list of emails sent to an
> >>> individual by email address would be appreciated.


>
 
S

Sue Mosher [MVP]

When it comes to viewing and manipulating data, Outlook generally doesn't

care what data store is involved.

Did you ever tell us your Outlook version? Which of my two search strings

did you try?

Sue Mosher

"Randall" <r_no_spam_gouge@doncar_no_spam_sys.com> wrote in message

news:OCqV9oPXKHA.5368@TK2MSFTNGP02.phx.gbl...
> Thanks for the info Sue ... but when I am performing the same search it
> appears to only be returning messages with the specified email address in
> the to or cc fields ... and not returning those for the same email address
> that only displayed a name.

> Was hoping that was the answer as I was unaware that the sql was written
> for searches where the sql is not explicitly provided.

> One other question. Is this information, being able to filter folders,
> only available where exhange is the mail sever?

> Thanks in advance.

> "Sue Mosher [MVP]" <suemvp@gmail.com> wrote in message
> news:OaWxJiNXKHA.1372@TK2MSFTNGP02.phx.gbl...
> > Just using the built-in view Filter dialog and its SQL tab, I came up
> > with this in Outlook 2007:
>

>> ("http://schemas.microsoft.com/mapi/proptag/0x0e04001f" CI_STARTSWITH
> > '@gmail.com' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"
> > CI_STARTSWITH '@gmail.com')
>

>> Odd that it would be CI_STARTSWITH instead of CI_PHRASEMATCH, but that's
> > what the SQL tab had. And the view showed all the gmail addresses,
> > regardless of whether that string was in the display name.
>

>> Then I modified it to use LIKE in case it's an earlier version or
> > unindexed, but that returned only those items that had @gmail.com in the
> > display name.
>

>> ("http://schemas.microsoft.com/mapi/proptag/0x0e04001f" LIKE
> > '%@gmail.com%' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"
> > LIKE '%@gmail.com%')
>

>> These results make me wonder if the underlying email address is available
> > only for an indexed search.



>

>> "Randall" <r_no_spam_gouge@doncar_no_spam_sys.com> wrote in message
> > news:O9W$5WMXKHA.3504@TK2MSFTNGP05.phx.gbl...
> >> Yes. As I mentioned in my note this only looks at the display name
> >> which can be anything and is not related to the actual email address.
> >
>>> What I am looking to do is this. Given an email address find all
> >> correspondences to this email address.
> >
>>> Thanks
> >
>>> "Michael Bauer " <mb@mvps.org> wrote in message
> >> news:10mr26ztm0gb2$.1xgb3entak4nm$.dlg@40tude.net...
> >>
>>>> Have your tried this:
> >>
>>>> urn:schemas:httpmail:displayto" LIKE '%emailaddress%'
> >>
>>
>>>> Am Mon, 2 Nov 2009 16:00:08 -0600 schrieb news.microsoft.com:
> >>
>>>>> I'm having a problem filtering the sent items folder by
> >>>> "urn:schemas:httpmail:to" LIKE '%emailaddress%' ... the search always
> >>>> returns nothing. Same is true for "urn:schemas:mailheader:to" LIKE
> >>>> '%emailaddress%'. I would use the displayto property but it is
> >>>> specific
> >>> to
> >>>> how an individual chooses to display a mail address unlike the email
> >>>> address.
> >>>
>>>>> Any help in obtaining a filter to provide a list of emails sent to an
> >>>> individual by email address would be appreciated.

>

>>


>
 
R

Randall

Good to see it is not dependent on the datastore.

I used the filter view in Outlook 2007, that I now know how to use, and used

the To field on the messages tab. The SQL for the query is the same as

yours and returns all mail with emailaddress in the To field and also

returns some messages (a very small fraction) of messages where the name

associated with the email address is displayed in the To field.

("http://schemas.microsoft.com/mapi/proptag/0x0e04001f" CI_STARTSWITH

'emailaddress' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"

CI_STARTSWITH 'emailaddress')

This returns only mail with the emailaddress in the To field

("http://schemas.microsoft.com/mapi/proptag/0x0e04001f" LIKE

'%emailaddress%' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"

LIKE '%emailaddress%')

I would have thought that since the email addresses are in the header of the

message that "urn:schemas:mailheader:to" would contain the string of

recipients but this comes back with no results.

I'm not sure what all is available .... but if there are alternate methods

of obtaining this list of recipients in code I would be willing to look at

doing that. Any thoughts would be appreciated.

Thanks

"Sue Mosher [MVP]" <suemvp@gmail.com> wrote in message

news:%23RimUNVXKHA.1280@TK2MSFTNGP04.phx.gbl...
> When it comes to viewing and manipulating data, Outlook generally doesn't
> care what data store is involved.

> Did you ever tell us your Outlook version? Which of my two search strings
> did you try?
> > Sue Mosher
> > >

> "Randall" <r_no_spam_gouge@doncar_no_spam_sys.com> wrote in message
> news:OCqV9oPXKHA.5368@TK2MSFTNGP02.phx.gbl...
> > Thanks for the info Sue ... but when I am performing the same search it
> > appears to only be returning messages with the specified email address in
> > the to or cc fields ... and not returning those for the same email
> > address that only displayed a name.
>

>> Was hoping that was the answer as I was unaware that the sql was written
> > for searches where the sql is not explicitly provided.
>

>> One other question. Is this information, being able to filter folders,
> > only available where exhange is the mail sever?
>

>> Thanks in advance.
>

>
>> "Sue Mosher [MVP]" <suemvp@gmail.com> wrote in message
> > news:OaWxJiNXKHA.1372@TK2MSFTNGP02.phx.gbl...
> >> Just using the built-in view Filter dialog and its SQL tab, I came up
> >> with this in Outlook 2007:
> >
>>> ("http://schemas.microsoft.com/mapi/proptag/0x0e04001f" CI_STARTSWITH
> >> '@gmail.com' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"
> >> CI_STARTSWITH '@gmail.com')
> >
>>> Odd that it would be CI_STARTSWITH instead of CI_PHRASEMATCH, but that's
> >> what the SQL tab had. And the view showed all the gmail addresses,
> >> regardless of whether that string was in the display name.
> >
>>> Then I modified it to use LIKE in case it's an earlier version or
> >> unindexed, but that returned only those items that had @gmail.com in the
> >> display name.
> >
>>> ("http://schemas.microsoft.com/mapi/proptag/0x0e04001f" LIKE
> >> '%@gmail.com%' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"
> >> LIKE '%@gmail.com%')
> >
>>> These results make me wonder if the underlying email address is
> >> available only for an indexed search.

>
> >
>>> "Randall" <r_no_spam_gouge@doncar_no_spam_sys.com> wrote in message
> >> news:O9W$5WMXKHA.3504@TK2MSFTNGP05.phx.gbl...
> >>> Yes. As I mentioned in my note this only looks at the display name
> >>> which can be anything and is not related to the actual email address.
> >>
>>>> What I am looking to do is this. Given an email address find all
> >>> correspondences to this email address.
> >>
>>>> Thanks
> >>
>>>> "Michael Bauer " <mb@mvps.org> wrote in message
> >>> news:10mr26ztm0gb2$.1xgb3entak4nm$.dlg@40tude.net...
> >>>
>>>>> Have your tried this:
> >>>
>>>>> urn:schemas:httpmail:displayto" LIKE '%emailaddress%'
> >>>
>>>
>>>>> Am Mon, 2 Nov 2009 16:00:08 -0600 schrieb news.microsoft.com:
> >>>
>>>>>> I'm having a problem filtering the sent items folder by
> >>>>> "urn:schemas:httpmail:to" LIKE '%emailaddress%' ... the search always
> >>>>> returns nothing. Same is true for "urn:schemas:mailheader:to" LIKE
> >>>>> '%emailaddress%'. I would use the displayto property but it is
> >>>>> specific
> >>>> to
> >>>>> how an individual chooses to display a mail address unlike the email
> >>>>> address.
> >>>>
>>>>>> Any help in obtaining a filter to provide a list of emails sent to an
> >>>>> individual by email address would be appreciated.
> >
>>>

>

>>


>
 
S

Sue Mosher [MVP]

Those are essentially the same results I reported, except that as far as I

could tell, with the first query, I got all messages sent to the gmail.com

domain, not just some, regardless of whether that string was in the display

name. I can't duplicate your "very small fraction" result.

Messages in your own Sent Items folder won't have any Internet headers. You

should be able to see that with Outlook Spy or MFCMAPI.exe.

The alternative is to iterate the Recipients collection for each item and

examine each Recipient.Address.

Sue Mosher

"Randall" <r_no_spam_gouge@doncar_no_spam_sys.com> wrote in message

news:erKKLMXXKHA.408@TK2MSFTNGP04.phx.gbl...
> Good to see it is not dependent on the datastore.

> I used the filter view in Outlook 2007, that I now know how to use, and
> used the To field on the messages tab. The SQL for the query is the same
> as yours and returns all mail with emailaddress in the To field and also
> returns some messages (a very small fraction) of messages where the name
> associated with the email address is displayed in the To field.

> ("http://schemas.microsoft.com/mapi/proptag/0x0e04001f" CI_STARTSWITH
> 'emailaddress' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"
> CI_STARTSWITH 'emailaddress')

> This returns only mail with the emailaddress in the To field
> ("http://schemas.microsoft.com/mapi/proptag/0x0e04001f" LIKE
> '%emailaddress%' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"
> LIKE '%emailaddress%')

> I would have thought that since the email addresses are in the header of
> the message that "urn:schemas:mailheader:to" would contain the string of
> recipients but this comes back with no results.

> I'm not sure what all is available .... but if there are alternate methods
> of obtaining this list of recipients in code I would be willing to look at
> doing that. Any thoughts would be appreciated.

> Thanks

> "Sue Mosher [MVP]" <suemvp@gmail.com> wrote in message
> news:%23RimUNVXKHA.1280@TK2MSFTNGP04.phx.gbl...
> > When it comes to viewing and manipulating data, Outlook generally doesn't
> > care what data store is involved.
>

>> Did you ever tell us your Outlook version? Which of my two search strings
> > did you try?
>

>> "Randall" <r_no_spam_gouge@doncar_no_spam_sys.com> wrote in message
> > news:OCqV9oPXKHA.5368@TK2MSFTNGP02.phx.gbl...
> >> Thanks for the info Sue ... but when I am performing the same search it
> >> appears to only be returning messages with the specified email address
> >> in the to or cc fields ... and not returning those for the same email
> >> address that only displayed a name.
> >
>>> Was hoping that was the answer as I was unaware that the sql was written
> >> for searches where the sql is not explicitly provided.
> >
>>> One other question. Is this information, being able to filter folders,
> >> only available where exhange is the mail sever?
> >
>>> Thanks in advance.
> >
>>
>>> "Sue Mosher [MVP]" <suemvp@gmail.com> wrote in message
> >> news:OaWxJiNXKHA.1372@TK2MSFTNGP02.phx.gbl...
> >>> Just using the built-in view Filter dialog and its SQL tab, I came up
> >>> with this in Outlook 2007:
> >>
>>>> ("http://schemas.microsoft.com/mapi/proptag/0x0e04001f"
> >>> CI_STARTSWITH '@gmail.com' OR
> >>> "http://schemas.microsoft.com/mapi/proptag/0x0e03001f" CI_STARTSWITH
> >>> '@gmail.com')
> >>
>>>> Odd that it would be CI_STARTSWITH instead of CI_PHRASEMATCH, but
> >>> that's what the SQL tab had. And the view showed all the gmail
> >>> addresses, regardless of whether that string was in the display name.
> >>
>>>> Then I modified it to use LIKE in case it's an earlier version or
> >>> unindexed, but that returned only those items that had @gmail.com in
> >>> the display name.
> >>
>>>> ("http://schemas.microsoft.com/mapi/proptag/0x0e04001f" LIKE
> >>> '%@gmail.com%' OR
> >>> "http://schemas.microsoft.com/mapi/proptag/0x0e03001f" LIKE
> >>> '%@gmail.com%')
> >>
>>>> These results make me wonder if the underlying email address is
> >>> available only for an indexed search.

> >
> >>
>>>> "Randall" <r_no_spam_gouge@doncar_no_spam_sys.com> wrote in message
> >>> news:O9W$5WMXKHA.3504@TK2MSFTNGP05.phx.gbl...
> >>>> Yes. As I mentioned in my note this only looks at the display name
> >>>> which can be anything and is not related to the actual email address.
> >>>
>>>>> What I am looking to do is this. Given an email address find all
> >>>> correspondences to this email address.
> >>>
>>>>> Thanks
> >>>
>>>>> "Michael Bauer " <mb@mvps.org> wrote in message
> >>>> news:10mr26ztm0gb2$.1xgb3entak4nm$.dlg@40tude.net...
> >>>>
>>>>>> Have your tried this:
> >>>>
>>>>>> urn:schemas:httpmail:displayto" LIKE '%emailaddress%'
> >>>>
>>>>
>>>>>> Am Mon, 2 Nov 2009 16:00:08 -0600 schrieb news.microsoft.com:
> >>>>
>>>>>>> I'm having a problem filtering the sent items folder by
> >>>>>> "urn:schemas:httpmail:to" LIKE '%emailaddress%' ... the search
> >>>>>> always
> >>>>>> returns nothing. Same is true for "urn:schemas:mailheader:to" LIKE
> >>>>>> '%emailaddress%'. I would use the displayto property but it is
> >>>>>> specific
> >>>>> to
> >>>>>> how an individual chooses to display a mail address unlike the email
> >>>>>> address.
> >>>>>
>>>>>>> Any help in obtaining a filter to provide a list of emails sent to
> >>>>>> an
> >>>>>> individual by email address would be appreciated.
 
R

Randall

Thanks for the help Sue. I'll look at the recipients collection.

"Sue Mosher [MVP]" <suemvp@gmail.com> wrote in message

news:%23xazQXXXKHA.1280@TK2MSFTNGP04.phx.gbl...
> Those are essentially the same results I reported, except that as far as I
> could tell, with the first query, I got all messages sent to the gmail.com
> domain, not just some, regardless of whether that string was in the
> display name. I can't duplicate your "very small fraction" result.

> Messages in your own Sent Items folder won't have any Internet headers.
> You should be able to see that with Outlook Spy or MFCMAPI.exe.

> The alternative is to iterate the Recipients collection for each item and
> examine each Recipient.Address.

> > Sue Mosher
> > >

> "Randall" <r_no_spam_gouge@doncar_no_spam_sys.com> wrote in message
> news:erKKLMXXKHA.408@TK2MSFTNGP04.phx.gbl...
> > Good to see it is not dependent on the datastore.
>

>> I used the filter view in Outlook 2007, that I now know how to use, and
> > used the To field on the messages tab. The SQL for the query is the same
> > as yours and returns all mail with emailaddress in the To field and also
> > returns some messages (a very small fraction) of messages where the name
> > associated with the email address is displayed in the To field.
>

>> ("http://schemas.microsoft.com/mapi/proptag/0x0e04001f" CI_STARTSWITH
> > 'emailaddress' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"
> > CI_STARTSWITH 'emailaddress')
>

>> This returns only mail with the emailaddress in the To field
> > ("http://schemas.microsoft.com/mapi/proptag/0x0e04001f" LIKE
> > '%emailaddress%' OR
> > "http://schemas.microsoft.com/mapi/proptag/0x0e03001f" LIKE
> > '%emailaddress%')
>

>> I would have thought that since the email addresses are in the header of
> > the message that "urn:schemas:mailheader:to" would contain the string of
> > recipients but this comes back with no results.
>

>> I'm not sure what all is available .... but if there are alternate
> > methods of obtaining this list of recipients in code I would be willing
> > to look at doing that. Any thoughts would be appreciated.
>

>> Thanks
>

>
>> "Sue Mosher [MVP]" <suemvp@gmail.com> wrote in message
> > news:%23RimUNVXKHA.1280@TK2MSFTNGP04.phx.gbl...
> >> When it comes to viewing and manipulating data, Outlook generally
> >> doesn't care what data store is involved.
> >
>>> Did you ever tell us your Outlook version? Which of my two search
> >> strings did you try?
> >
>>> "Randall" <r_no_spam_gouge@doncar_no_spam_sys.com> wrote in message
> >> news:OCqV9oPXKHA.5368@TK2MSFTNGP02.phx.gbl...
> >>> Thanks for the info Sue ... but when I am performing the same search it
> >>> appears to only be returning messages with the specified email address
> >>> in the to or cc fields ... and not returning those for the same email
> >>> address that only displayed a name.
> >>
>>>> Was hoping that was the answer as I was unaware that the sql was
> >>> written for searches where the sql is not explicitly provided.
> >>
>>>> One other question. Is this information, being able to filter folders,
> >>> only available where exhange is the mail sever?
> >>
>>>> Thanks in advance.
> >>
>>>
>>>> "Sue Mosher [MVP]" <suemvp@gmail.com> wrote in message
> >>> news:OaWxJiNXKHA.1372@TK2MSFTNGP02.phx.gbl...
> >>>> Just using the built-in view Filter dialog and its SQL tab, I came up
> >>>> with this in Outlook 2007:
> >>>
>>>>> ("http://schemas.microsoft.com/mapi/proptag/0x0e04001f"
> >>>> CI_STARTSWITH '@gmail.com' OR
> >>>> "http://schemas.microsoft.com/mapi/proptag/0x0e03001f" CI_STARTSWITH
> >>>> '@gmail.com')
> >>>
>>>>> Odd that it would be CI_STARTSWITH instead of CI_PHRASEMATCH, but
> >>>> that's what the SQL tab had. And the view showed all the gmail
> >>>> addresses, regardless of whether that string was in the display name.
> >>>
>>>>> Then I modified it to use LIKE in case it's an earlier version or
> >>>> unindexed, but that returned only those items that had @gmail.com in
> >>>> the display name.
> >>>
>>>>> ("http://schemas.microsoft.com/mapi/proptag/0x0e04001f" LIKE
> >>>> '%@gmail.com%' OR
> >>>> "http://schemas.microsoft.com/mapi/proptag/0x0e03001f" LIKE
> >>>> '%@gmail.com%')
> >>>
>>>>> These results make me wonder if the underlying email address is
> >>>> available only for an indexed search.
> >
>>>>
>>>>> "Randall" <r_no_spam_gouge@doncar_no_spam_sys.com> wrote in message
> >>>> news:O9W$5WMXKHA.3504@TK2MSFTNGP05.phx.gbl...
> >>>>> Yes. As I mentioned in my note this only looks at the display name
> >>>>> which can be anything and is not related to the actual email address.
> >>>>
>>>>>> What I am looking to do is this. Given an email address find all
> >>>>> correspondences to this email address.
> >>>>
>>>>>> Thanks
> >>>>
>>>>>> "Michael Bauer " <mb@mvps.org> wrote in message
> >>>>> news:10mr26ztm0gb2$.1xgb3entak4nm$.dlg@40tude.net...
> >>>>>
>>>>>>> Have your tried this:
> >>>>>
>>>>>>> urn:schemas:httpmail:displayto" LIKE '%emailaddress%'
> >>>>>
>>>>>
>>>>>>> Am Mon, 2 Nov 2009 16:00:08 -0600 schrieb news.microsoft.com:
> >>>>>
>>>>>>>> I'm having a problem filtering the sent items folder by
> >>>>>>> "urn:schemas:httpmail:to" LIKE '%emailaddress%' ... the search
> >>>>>>> always
> >>>>>>> returns nothing. Same is true for "urn:schemas:mailheader:to" LIKE
> >>>>>>> '%emailaddress%'. I would use the displayto property but it is
> >>>>>>> specific
> >>>>>> to
> >>>>>>> how an individual chooses to display a mail address unlike the
> >>>>>>> email
> >>>>>>> address.
> >>>>>>
>>>>>>>> Any help in obtaining a filter to provide a list of emails sent to
> >>>>>>> an
> >>>>>>> individual by email address would be appreciated.


>
 
H

Harold

Thanks

("http://schemas.microsoft.com/mapi/proptag/0x0e04001f" LIKE

'%emailaddress%' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"

LIKE '%emailaddress%')

Is working in Outlook view filter ;)

I've found it undesignedly too, by filling view filter field "From" in

"Messages" tab value "@domain".

"Randall" wrote:



> Thanks for the help Sue. I'll look at the recipients collection.

> "Sue Mosher [MVP]" <suemvp@gmail.com> wrote in message
> news:%23xazQXXXKHA.1280@TK2MSFTNGP04.phx.gbl...
> > Those are essentially the same results I reported, except that as far as I
> > could tell, with the first query, I got all messages sent to the gmail.com
> > domain, not just some, regardless of whether that string was in the
> > display name. I can't duplicate your "very small fraction" result.
> > Messages in your own Sent Items folder won't have any Internet headers.
> > You should be able to see that with Outlook Spy or MFCMAPI.exe.
> > The alternative is to iterate the Recipients collection for each item and
> > examine each Recipient.Address.
> > > > Sue Mosher
> > > > > > > > "Randall" <r_no_spam_gouge@doncar_no_spam_sys.com> wrote in message
> > news:erKKLMXXKHA.408@TK2MSFTNGP04.phx.gbl...
> >> Good to see it is not dependent on the datastore.
> >
> >> I used the filter view in Outlook 2007, that I now know how to use, and
> >> used the To field on the messages tab. The SQL for the query is the same
> >> as yours and returns all mail with emailaddress in the To field and also
> >> returns some messages (a very small fraction) of messages where the name
> >> associated with the email address is displayed in the To field.
> >
> >> ("http://schemas.microsoft.com/mapi/proptag/0x0e04001f" CI_STARTSWITH
> >> 'emailaddress' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"
> >> CI_STARTSWITH 'emailaddress')
> >
> >> This returns only mail with the emailaddress in the To field
> >> ("http://schemas.microsoft.com/mapi/proptag/0x0e04001f" LIKE
> >> '%emailaddress%' OR
> >> "http://schemas.microsoft.com/mapi/proptag/0x0e03001f" LIKE
> >> '%emailaddress%')
> >
> >> I would have thought that since the email addresses are in the header of
> >> the message that "urn:schemas:mailheader:to" would contain the string of
> >> recipients but this comes back with no results.
> >
> >> I'm not sure what all is available .... but if there are alternate
> >> methods of obtaining this list of recipients in code I would be willing
> >> to look at doing that. Any thoughts would be appreciated.
> >
> >> Thanks
> >
> >
> >> "Sue Mosher [MVP]" <suemvp@gmail.com> wrote in message
> >> news:%23RimUNVXKHA.1280@TK2MSFTNGP04.phx.gbl...
> >>> When it comes to viewing and manipulating data, Outlook generally
> >>> doesn't care what data store is involved.
> >>
> >>> Did you ever tell us your Outlook version? Which of my two search
> >>> strings did you try?
> >>
> >>> "Randall" <r_no_spam_gouge@doncar_no_spam_sys.com> wrote in message
> >>> news:OCqV9oPXKHA.5368@TK2MSFTNGP02.phx.gbl...
> >>>> Thanks for the info Sue ... but when I am performing the same search it
> >>>> appears to only be returning messages with the specified email address
> >>>> in the to or cc fields ... and not returning those for the same email
> >>>> address that only displayed a name.
> >>>
> >>>> Was hoping that was the answer as I was unaware that the sql was
> >>>> written for searches where the sql is not explicitly provided.
> >>>
> >>>> One other question. Is this information, being able to filter folders,
> >>>> only available where exhange is the mail sever?
> >>>
> >>>> Thanks in advance.
> >>>
> >>>
> >>>> "Sue Mosher [MVP]" <suemvp@gmail.com> wrote in message
> >>>> news:OaWxJiNXKHA.1372@TK2MSFTNGP02.phx.gbl...
> >>>>> Just using the built-in view Filter dialog and its SQL tab, I came up
> >>>>> with this in Outlook 2007:
> >>>>
> >>>>> ("http://schemas.microsoft.com/mapi/proptag/0x0e04001f"
> >>>>> CI_STARTSWITH '@gmail.com' OR
> >>>>> "http://schemas.microsoft.com/mapi/proptag/0x0e03001f" CI_STARTSWITH
> >>>>> '@gmail.com')
> >>>>
> >>>>> Odd that it would be CI_STARTSWITH instead of CI_PHRASEMATCH, but
> >>>>> that's what the SQL tab had. And the view showed all the gmail
> >>>>> addresses, regardless of whether that string was in the display name.
> >>>>
> >>>>> Then I modified it to use LIKE in case it's an earlier version or
> >>>>> unindexed, but that returned only those items that had @gmail.com in
> >>>>> the display name.
> >>>>
> >>>>> ("http://schemas.microsoft.com/mapi/proptag/0x0e04001f" LIKE
> >>>>> '%@gmail.com%' OR
> >>>>> "http://schemas.microsoft.com/mapi/proptag/0x0e03001f" LIKE
> >>>>> '%@gmail.com%')
> >>>>
> >>>>> These results make me wonder if the underlying email address is
> >>>>> available only for an indexed search.
> >>
> >>>>
> >>>>> "Randall" <r_no_spam_gouge@doncar_no_spam_sys.com> wrote in message
> >>>>> news:O9W$5WMXKHA.3504@TK2MSFTNGP05.phx.gbl...
> >>>>>> Yes. As I mentioned in my note this only looks at the display name
> >>>>>> which can be anything and is not related to the actual email address.
> >>>>>
> >>>>>> What I am looking to do is this. Given an email address find all
> >>>>>> correspondences to this email address.
> >>>>>
> >>>>>> Thanks
> >>>>>
> >>>>>> "Michael Bauer " <mb@mvps.org> wrote in message
> >>>>>> news:10mr26ztm0gb2$.1xgb3entak4nm$.dlg@40tude.net...
> >>>>>>
> >>>>>>> Have your tried this:
> >>>>>>
> >>>>>>> urn:schemas:httpmail:displayto" LIKE '%emailaddress%'
> >>>>>>
> >>>>>
> >>>>>>> Am Mon, 2 Nov 2009 16:00:08 -0600 schrieb news.microsoft.com:
> >>>>>>
> >>>>>>>> I'm having a problem filtering the sent items folder by
> >>>>>>>> "urn:schemas:httpmail:to" LIKE '%emailaddress%' ... the search
> >>>>>>>> always
> >>>>>>>> returns nothing. Same is true for "urn:schemas:mailheader:to" LIKE
> >>>>>>>> '%emailaddress%'. I would use the displayto property but it is
> >>>>>>>> specific
> >>>>>>> to
> >>>>>>>> how an individual chooses to display a mail address unlike the
> >>>>>>>> email
> >>>>>>>> address.
> >>>>>>>
> >>>>>>>> Any help in obtaining a filter to provide a list of emails sent to
> >>>>>>>> an
> >>>>>>>> individual by email address would be appreciated.

> >


> .
>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
Jennifer Murphy Spam filter not working Using Outlook 13
Y Filter unread emails in a search folder vba help Outlook VBA and Custom Forms 0
M How create a Rule to filter sender's email with more that one @ sign Using Outlook 1
M Sorting by Day in Date Column Advanced Filter BCM (Business Contact Manager) 1
B Task Filter Not Working When I add too many criteria Using Outlook 0
M Filter Conversations - Filter Out Single Emails Outlook VBA and Custom Forms 3
B Looking to filter (or just find/search) for only messages that the sender has sent more than 1 messa Using Outlook 2
B Wanting to run a script that will filter any body that has a russian link in it. Outlook VBA and Custom Forms 5
C Filter/Search emails sent to internal Exchange address only Using Outlook 2
e_a_g_l_e_p_i Is there a good third party SPAM filter that intergrates with Outlook 2010 Using Outlook 7
P How to filter primary contacts in business contact manager BCM (Business Contact Manager) 0
O Outlook Web Access - how to disable spam filter Using Outlook 6
G How to filter by the format of an email address Using Outlook 6
S Mail filter recieved before the last 2 working days Using Outlook 1
Liza Creating a rule in outlook to filter messages Using Outlook 0
F Adding textbox filter to listbox? Outlook VBA and Custom Forms 2
Diane Poremsky Filter and Save Contacts to a CSV File New Slipstick.com Articles 0
Diane Poremsky Filter and Save Contacts to a CSV File New Slipstick.com Articles 0
Fozzie Bear HomeTab Email filter "Greyed Out" in Outlook 2013 Exchange Server Administration 3
W Filter condition "contains"/"doesn't contain" doesn't always work Using Outlook 10
B Conditional Formatting:How to use >1 value in a filter Using Outlook 7
J Outlook VBA for Email Filter Outlook VBA and Custom Forms 2
Emerogork How do I set up an "Incoming mail filter" Using Outlook 12
M Filter today's mail Using Outlook 2
M trying to disable junk email filter. completely. Using Outlook 4
J Task Filter for Status OR One Month Using Outlook 4
R Filter Views by Category Using Outlook 2
D Junk Mail filter Using Outlook 1
S Filter by accounts but communicate to all linked contacts BCM (Business Contact Manager) 1
D What is this SQL filter that is applied to my Inbox? Using Outlook 6
J Outlook Contacts: How to filter contact phone numbers from a cti request Using Outlook 1
H Two accounts, Junk email filter only works on one account, office 2010, pop3 Using Outlook 5
D How Would I Write This Filter? Using Outlook 3
N Filter end date works differently in OL'07/OL'10 vs OL'03? Hello?! Using Outlook 12
williamlambton Filter which removes Display Names from incoming emails. Using Outlook 2
J How to filter by address fragment (e.g. "@domain.com") with advanced find? Using Outlook 2
L Need a good email filter Using Outlook 2
P BCM Review & Filter BCM (Business Contact Manager) 1
M DASL Filter function? Outlook VBA and Custom Forms 3
M DASL Filter function? Outlook VBA and Custom Forms 3
M Today(S) function in DASL Filter Outlook VBA and Custom Forms 1
M Today(S) function in DASL Filter Outlook VBA and Custom Forms 1
M Create search folder filter that converts UTC time to local? Outlook VBA and Custom Forms 9
A Junk mail filter is junk Outlook Wishlist 2
E DASL Filter doesn't work when defined programatically Outlook VBA and Custom Forms 1
H Outlook 2007 SQL syntax to filter views of tasks and todo items Outlook VBA and Custom Forms 1
K Can I filter by fields 'containing' specific words? BCM (Business Contact Manager) 1
P Custom rule to filter on sender name Outlook VBA and Custom Forms 5
M Filter rules to distinguish To and CC fields Outlook VBA and Custom Forms 1
D Disable Junk E-mail Filter in Outlook 2007 Using Outlook 13

Similar threads

Top