A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

ADSL - filter by email address to



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old November 2nd 09, 10:00 PM posted to microsoft.public.outlook.program_vba
news.microsoft.com[_9_]
external usenet poster
 
Posts: 1
Default ADSL - filter by email address to


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


Ads
  #2  
Old November 3rd 09, 08:16 PM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default ADSL - filter by email address to


Have your tried this:

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

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: http://www.vboffice.net/product.html?pub=6&lang=en


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

  #3  
Old November 3rd 09, 08:39 PM posted to microsoft.public.outlook.program_vba
Randall[_2_]
external usenet poster
 
Posts: 4
Default ADSL - filter by email address to

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 [MVP - Outlook]" wrote in message
. ..

Have your tried this:

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

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: http://www.vboffice.net/product.html?pub=6&lang=en


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



  #4  
Old November 3rd 09, 10:39 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP][_4_]
external usenet poster
 
Posts: 552
Default ADSL - filter by email address to

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
' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"
CI_STARTSWITH ')

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
%' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"
LIKE %')

These results make me wonder if the underlying email address is available
only for an indexed search.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Randall" wrote in message
...
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 [MVP - Outlook]" wrote in message
. ..

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.



  #5  
Old November 4th 09, 02:55 AM posted to microsoft.public.outlook.program_vba
Randall[_2_]
external usenet poster
 
Posts: 4
Default ADSL - filter by email address to

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]" wrote in message
...
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
' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"
CI_STARTSWITH ')

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
%' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"
LIKE %')

These results make me wonder if the underlying email address is available
only for an indexed search.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Randall" wrote in message
...
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 [MVP - Outlook]" wrote in message
. ..

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.





  #6  
Old November 4th 09, 01:04 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP][_4_]
external usenet poster
 
Posts: 552
Default ADSL - filter by email address to

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, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Randall" wrote in message
...
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]" wrote in message
...
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
' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"
CI_STARTSWITH ')

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
%' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"
LIKE %')

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



"Randall" wrote in message
...
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 [MVP - Outlook]" wrote in message
. ..

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.







  #7  
Old November 4th 09, 05:19 PM posted to microsoft.public.outlook.program_vba
Randall[_2_]
external usenet poster
 
Posts: 4
Default ADSL - filter by email address to

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]" wrote in message
...
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, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Randall" wrote in message
...
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]" wrote in message
...
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
' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"
CI_STARTSWITH ')

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
%' OR "http://schemas.microsoft.com/mapi/proptag/0x0e03001f"
LIKE %')

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



"Randall" wrote in message
...
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 [MVP - Outlook]" wrote in message
. ..

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.








  #8  
Old November 4th 09, 05:38 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP][_4_]
external usenet poster
 
Posts: 552
Default ADSL - filter by email address to

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, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Randall" wrote in message
...
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]" wrote in message
...
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" wrote in message
...
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]" wrote in message
...
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 ' OR
"http://schemas.microsoft.com/mapi/proptag/0x0e03001f" CI_STARTSWITH
')

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
%' OR
"http://schemas.microsoft.com/mapi/proptag/0x0e03001f" LIKE
%')

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



"Randall" wrote in message
...
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 [MVP - Outlook]" wrote in message
. ..

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.



  #9  
Old November 4th 09, 07:06 PM posted to microsoft.public.outlook.program_vba
Randall[_2_]
external usenet poster
 
Posts: 4
Default ADSL - filter by email address to


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

"Sue Mosher [MVP]" wrote in message
...
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, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Randall" wrote in message
...
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]" wrote in message
...
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" wrote in message
...
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]" wrote in message
...
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 ' OR
"http://schemas.microsoft.com/mapi/proptag/0x0e03001f" CI_STARTSWITH
')

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
%' OR
"http://schemas.microsoft.com/mapi/proptag/0x0e03001f" LIKE
%')

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


"Randall" wrote in message
...
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 [MVP - Outlook]" wrote in message
. ..

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.





  #10  
Old November 7th 09, 06:15 PM posted to microsoft.public.outlook.program_vba
Harold
external usenet poster
 
Posts: 14
Default ADSL - filter by email address to

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]" wrote in message
...
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, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Randall" wrote in message
...
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]" wrote in message
...
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" wrote in message
...
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]" wrote in message
...
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 ' OR
"http://schemas.microsoft.com/mapi/proptag/0x0e03001f" CI_STARTSWITH
')

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
%' OR
"http://schemas.microsoft.com/mapi/proptag/0x0e03001f" LIKE
%')

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


"Randall" wrote in message
...
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 [MVP - Outlook]" wrote in message
. ..

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.





.

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
fAX AND ADSL Ghianda Outlook - Fax Functions 1 January 27th 09 10:27 AM
Adsl-modeemi Tapani Tervo Outlook - Fax Functions 0 November 17th 08 11:07 PM
Filter to specify which account is used according to email address? Gaikokujin Kyofusho Outlook - General Queries 6 April 7th 08 03:57 PM
How can I filter my invalid e-mail address out of my address book EDewitt Outlook - Using Contacts 1 June 9th 07 05:23 AM
Junk Mail Filter, No Email Address Don Milner Outlook - Installation 1 August 11th 06 10:34 PM


All times are GMT +1. The time now is 03:44 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.