Creating a filter to hide invitations from people outside organiza

[Rick Young]

I work for a county government. I have a request from a user who wants me to
create a filter that will hide certain calendar invitations. They want a
rule to hide any calendar invitation where: The user is outside our
organization & the meeting status = tentatively accepted or not yet responded.

They want to filter out any unaccepted invitations (either tentatively
accepted or not yet responded) if it had originated with anyone who is not
part of our global address list.

They want to see all approved calendar items regardless of who originated
them, all reoccurring items, all items they created themselves as reminders
and any calendar events originating from county employees that are
tentatively accepted or not yet responded.

I found out how to look at the meta-data associated with calendar events ( |
Tools | Forms | Design this form | (All Fields) |) but I don't see where to
find the field to search for non "forsythco.com" originators. I can see the
web-based email address in the body of the calendar event but I can't find a
meta-data field with this information in it. In the "All Mail Fields" - From
field, it shows "Calendar
[[email protected]]" but if I build a rule
saying to include only calendar events where From does not contain "@"
(thinking that anyone on our global address list would not have their email
address in here), this calendar event still shows up so I'm assuming that the
info inside the [] brackets is not searchable in the rule.

Where would I find the email address of the Originator and how do I use that
in a filtering rule.

 

[Diane Poremsky [MVP]]

Which filter tab are you using? Did you enabled Querybuilder? It makes it
easy to set up rules...

I used querybuilder and the resulting SQL is
("urn:schemas:httpmail:fromname" <> '@' AND
"http://schemas.microsoft.com/mapi/id/{00062002-0000-0000-C000-000000000046}/82180003"
= 2)

Querybuilder: http://www.outlook-tips.net/archives/2004/20040927.htm


--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

 

[Rick Young]

Thanks for your help with this.

I used Querybuilder and generated the same SQL code, but the calendar event
with From = "Calendar [[email protected]]"
is being displayed so the rule isn't finding the "@" in the bracketed From
information

I simplified the SQL code to:
"urn:schemas:httpmail:fromname" <> '@'
and it still did not filter out the calendar event from the outside source.

P.S.
The user is running Outlook 2003.

Which filter tab are you using? Did you enabled Querybuilder? It makes it
easy to set up rules...

I used querybuilder and the resulting SQL is
("urn:schemas:httpmail:fromname" <> '@' AND
"http://schemas.microsoft.com/mapi/id/{00062002-0000-0000-C000-000000000046}/82180003"
= 2)

Querybuilder: http://www.outlook-tips.net/archives/2004/20040927.htm


--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

I work for a county government. I have a request from a user who wants me
to
create a filter that will hide certain calendar invitations. They want a
rule to hide any calendar invitation where: The user is outside our
organization & the meeting status = tentatively accepted or not yet
responded.

They want to filter out any unaccepted invitations (either tentatively
accepted or not yet responded) if it had originated with anyone who is not
part of our global address list.

They want to see all approved calendar items regardless of who originated
them, all reoccurring items, all items they created themselves as
reminders
and any calendar events originating from county employees that are
tentatively accepted or not yet responded.

I found out how to look at the meta-data associated with calendar events
( |
Tools | Forms | Design this form | (All Fields) |) but I don't see where
to
find the field to search for non "forsythco.com" originators. I can see
the
web-based email address in the body of the calendar event but I can't find
a
meta-data field with this information in it. In the "All Mail Fields" -
From
field, it shows "Calendar
[[email protected]]" but if I build a
rule
saying to include only calendar events where From does not contain "@"
(thinking that anyone on our global address list would not have their
email
address in here), this calendar event still shows up so I'm assuming that
the
info inside the [] brackets is not searchable in the rule.

Where would I find the email address of the Originator and how do I use
that
in a filtering rule.

 

[Diane Poremsky [MVP]]

Check the message header in the inbox - is it blank?

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

Thanks for your help with this.

I used Querybuilder and generated the same SQL code, but the calendar
event
with From = "Calendar
[[email protected]]"
is being displayed so the rule isn't finding the "@" in the bracketed From
information

I simplified the SQL code to:
"urn:schemas:httpmail:fromname" <> '@'
and it still did not filter out the calendar event from the outside
source.

P.S.
The user is running Outlook 2003.

Which filter tab are you using? Did you enabled Querybuilder? It makes it
easy to set up rules...

I used querybuilder and the resulting SQL is
("urn:schemas:httpmail:fromname" <> '@' AND
"http://schemas.microsoft.com/mapi/id/{00062002-0000-0000-C000-000000000046}/82180003"
= 2)

Querybuilder: http://www.outlook-tips.net/archives/2004/20040927.htm


--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point
your
newsreader to msnews.microsoft.com.

I work for a county government. I have a request from a user who wants
me
to
create a filter that will hide certain calendar invitations. They want
a
rule to hide any calendar invitation where: The user is outside our
organization & the meeting status = tentatively accepted or not yet
responded.

They want to filter out any unaccepted invitations (either tentatively
accepted or not yet responded) if it had originated with anyone who is
not
part of our global address list.

They want to see all approved calendar items regardless of who
originated
them, all reoccurring items, all items they created themselves as
reminders
and any calendar events originating from county employees that are
tentatively accepted or not yet responded.

I found out how to look at the meta-data associated with calendar
events
( |
Tools | Forms | Design this form | (All Fields) |) but I don't see
where
to
find the field to search for non "forsythco.com" originators. I can
see
the
web-based email address in the body of the calendar event but I can't
find
a
meta-data field with this information in it. In the "All Mail
Fields" -
From
field, it shows "Calendar
[[email protected]]" but if I build
a
rule
saying to include only calendar events where From does not contain "@"
(thinking that anyone on our global address list would not have their
email
address in here), this calendar event still shows up so I'm assuming
that
the
info inside the [] brackets is not searchable in the rule.

Where would I find the email address of the Originator and how do I use
that
in a filtering rule.

 

[Diane Poremsky [MVP]]

I'll bet the From field is the problem - the From field on the General tab
is the email address and the one in Advanced tab is display name. It worked
correctly in 2007. (although it probably shouldn't have). I'm not sure
which one querybuilder uses - try @ in the organizer field on the first tab
and show time as on the advanced tab.




--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

Thanks for your help with this.

I used Querybuilder and generated the same SQL code, but the calendar
event
with From = "Calendar
[[email protected]]"
is being displayed so the rule isn't finding the "@" in the bracketed From
information

I simplified the SQL code to:
"urn:schemas:httpmail:fromname" <> '@'
and it still did not filter out the calendar event from the outside
source.

P.S.
The user is running Outlook 2003.

Which filter tab are you using? Did you enabled Querybuilder? It makes it
easy to set up rules...

I used querybuilder and the resulting SQL is
("urn:schemas:httpmail:fromname" <> '@' AND
"http://schemas.microsoft.com/mapi/id/{00062002-0000-0000-C000-000000000046}/82180003"
= 2)

Querybuilder: http://www.outlook-tips.net/archives/2004/20040927.htm


--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point
your
newsreader to msnews.microsoft.com.

I work for a county government. I have a request from a user who wants
me
to
create a filter that will hide certain calendar invitations. They want
a
rule to hide any calendar invitation where: The user is outside our
organization & the meeting status = tentatively accepted or not yet
responded.

They want to filter out any unaccepted invitations (either tentatively
accepted or not yet responded) if it had originated with anyone who is
not
part of our global address list.

They want to see all approved calendar items regardless of who
originated
them, all reoccurring items, all items they created themselves as
reminders
and any calendar events originating from county employees that are
tentatively accepted or not yet responded.

I found out how to look at the meta-data associated with calendar
events
( |
Tools | Forms | Design this form | (All Fields) |) but I don't see
where
to
find the field to search for non "forsythco.com" originators. I can
see
the
web-based email address in the body of the calendar event but I can't
find
a
meta-data field with this information in it. In the "All Mail
Fields" -
From
field, it shows "Calendar
[[email protected]]" but if I build
a
rule
saying to include only calendar events where From does not contain "@"
(thinking that anyone on our global address list would not have their
email
address in here), this calendar event still shows up so I'm assuming
that
the
info inside the [] brackets is not searchable in the rule.

Where would I find the email address of the Originator and how do I use
that
in a filtering rule.

 

[Rick Young]

Is 'header' a property of the message?
On the message's "please respond" email, the "header" looks like this:
From, Required, Location, When & message body are filled in
Optional, Subject & Description are not filled in.

Check the message header in the inbox - is it blank?

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

Thanks for your help with this.

I used Querybuilder and generated the same SQL code, but the calendar
event
with From = "Calendar
[[email protected]]"
is being displayed so the rule isn't finding the "@" in the bracketed From
information

I simplified the SQL code to:
"urn:schemas:httpmail:fromname" <> '@'
and it still did not filter out the calendar event from the outside
source.

P.S.
The user is running Outlook 2003.

Which filter tab are you using? Did you enabled Querybuilder? It makes it
easy to set up rules...

I used querybuilder and the resulting SQL is
("urn:schemas:httpmail:fromname" <> '@' AND
"http://schemas.microsoft.com/mapi/id/{00062002-0000-0000-C000-000000000046}/82180003"
= 2)

Querybuilder: http://www.outlook-tips.net/archives/2004/20040927.htm


--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point
your
newsreader to msnews.microsoft.com.


I work for a county government. I have a request from a user who wants
me
to
create a filter that will hide certain calendar invitations. They want
a
rule to hide any calendar invitation where: The user is outside our
organization & the meeting status = tentatively accepted or not yet
responded.

They want to filter out any unaccepted invitations (either tentatively
accepted or not yet responded) if it had originated with anyone who is
not
part of our global address list.

They want to see all approved calendar items regardless of who
originated
them, all reoccurring items, all items they created themselves as
reminders
and any calendar events originating from county employees that are
tentatively accepted or not yet responded.

I found out how to look at the meta-data associated with calendar
events
( |
Tools | Forms | Design this form | (All Fields) |) but I don't see
where
to
find the field to search for non "forsythco.com" originators. I can
see
the
web-based email address in the body of the calendar event but I can't
find
a
meta-data field with this information in it. In the "All Mail
Fields" -
From
field, it shows "Calendar
[[email protected]]" but if I build
a
rule
saying to include only calendar events where From does not contain "@"
(thinking that anyone on our global address list would not have their
email
address in here), this calendar event still shows up so I'm assuming
that
the
info inside the [] brackets is not searchable in the rule.

Where would I find the email address of the Originator and how do I use
that
in a filtering rule.

 

[Diane Poremsky [MVP]]

FWIW, it won't work to use the tabs - you want to hide the ones with @, not
show them - you need to use Querybuilder or SQL and my very slow outlook is
crashing when I edit the SQL created by the From field on the first tab to
use <> '@'. I'll have to wait for the updates to install and reboot before
I try again.


--

I'll bet the From field is the problem - the From field on the General tab
is the email address and the one in Advanced tab is display name. It
worked correctly in 2007. (although it probably shouldn't have). I'm not
sure which one querybuilder uses - try @ in the organizer field on the
first tab and show time as on the advanced tab.




--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

Thanks for your help with this.

I used Querybuilder and generated the same SQL code, but the calendar
event
with From = "Calendar
[[email protected]]"
is being displayed so the rule isn't finding the "@" in the bracketed
From
information

I simplified the SQL code to:
"urn:schemas:httpmail:fromname" <> '@'
and it still did not filter out the calendar event from the outside
source.

P.S.
The user is running Outlook 2003.

Which filter tab are you using? Did you enabled Querybuilder? It makes
it
easy to set up rules...

I used querybuilder and the resulting SQL is
("urn:schemas:httpmail:fromname" <> '@' AND
"http://schemas.microsoft.com/mapi/id/{00062002-0000-0000-C000-000000000046}/82180003"
= 2)

Querybuilder: http://www.outlook-tips.net/archives/2004/20040927.htm


--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point
your
newsreader to msnews.microsoft.com.


I work for a county government. I have a request from a user who
wants me
to
create a filter that will hide certain calendar invitations. They
want a
rule to hide any calendar invitation where: The user is outside our
organization & the meeting status = tentatively accepted or not yet
responded.

They want to filter out any unaccepted invitations (either tentatively
accepted or not yet responded) if it had originated with anyone who is
not
part of our global address list.

They want to see all approved calendar items regardless of who
originated
them, all reoccurring items, all items they created themselves as
reminders
and any calendar events originating from county employees that are
tentatively accepted or not yet responded.

I found out how to look at the meta-data associated with calendar
events
( |
Tools | Forms | Design this form | (All Fields) |) but I don't see
where
to
find the field to search for non "forsythco.com" originators. I can
see
the
web-based email address in the body of the calendar event but I can't
find
a
meta-data field with this information in it. In the "All Mail
Fields" -
From
field, it shows "Calendar
[[email protected]]" but if I build
a
rule
saying to include only calendar events where From does not contain "@"
(thinking that anyone on our global address list would not have their
email
address in here), this calendar event still shows up so I'm assuming
that
the
info inside the [] brackets is not searchable in the rule.

Where would I find the email address of the Originator and how do I
use
that
in a filtering rule.

 

[Rick Young]

I editted the SQL to try
"urn:schemas:httpmail:fromname" NOT LIKE '%@%'
but I get an SQL error:
error parsing your SQL text

FWIW, it won't work to use the tabs - you want to hide the ones with @, not
show them - you need to use Querybuilder or SQL and my very slow outlook is
crashing when I edit the SQL created by the From field on the first tab to
use <> '@'. I'll have to wait for the updates to install and reboot before
I try again.


--

I'll bet the From field is the problem - the From field on the General tab
is the email address and the one in Advanced tab is display name. It
worked correctly in 2007. (although it probably shouldn't have). I'm not
sure which one querybuilder uses - try @ in the organizer field on the
first tab and show time as on the advanced tab.




--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

Thanks for your help with this.

I used Querybuilder and generated the same SQL code, but the calendar
event
with From = "Calendar
[[email protected]]"
is being displayed so the rule isn't finding the "@" in the bracketed
From
information

I simplified the SQL code to:
"urn:schemas:httpmail:fromname" <> '@'
and it still did not filter out the calendar event from the outside
source.

P.S.
The user is running Outlook 2003.


:

Which filter tab are you using? Did you enabled Querybuilder? It makes
it
easy to set up rules...

I used querybuilder and the resulting SQL is
("urn:schemas:httpmail:fromname" <> '@' AND
"http://schemas.microsoft.com/mapi/id/{00062002-0000-0000-C000-000000000046}/82180003"
= 2)

Querybuilder: http://www.outlook-tips.net/archives/2004/20040927.htm


--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point
your
newsreader to msnews.microsoft.com.


I work for a county government. I have a request from a user who
wants me
to
create a filter that will hide certain calendar invitations. They
want a
rule to hide any calendar invitation where: The user is outside our
organization & the meeting status = tentatively accepted or not yet
responded.

They want to filter out any unaccepted invitations (either tentatively
accepted or not yet responded) if it had originated with anyone who is
not
part of our global address list.

They want to see all approved calendar items regardless of who
originated
them, all reoccurring items, all items they created themselves as
reminders
and any calendar events originating from county employees that are
tentatively accepted or not yet responded.

I found out how to look at the meta-data associated with calendar
events
( |
Tools | Forms | Design this form | (All Fields) |) but I don't see
where
to
find the field to search for non "forsythco.com" originators. I can
see
the
web-based email address in the body of the calendar event but I can't
find
a
meta-data field with this information in it. In the "All Mail
Fields" -
From
field, it shows "Calendar
[[email protected]]" but if I build
a
rule
saying to include only calendar events where From does not contain "@"
(thinking that anyone on our global address list would not have their
email
address in here), this calendar event still shows up so I'm assuming
that
the
info inside the [] brackets is not searchable in the rule.

Where would I find the email address of the Originator and how do I
use
that
in a filtering rule.

 

[Rick Young]

"urn:schemas:httpmail:fromname" <> '%@%' does not exclude the ones I want
either

I editted the SQL to try
"urn:schemas:httpmail:fromname" NOT LIKE '%@%'
but I get an SQL error:
error parsing your SQL text

FWIW, it won't work to use the tabs - you want to hide the ones with @, not
show them - you need to use Querybuilder or SQL and my very slow outlook is
crashing when I edit the SQL created by the From field on the first tab to
use <> '@'. I'll have to wait for the updates to install and reboot before
I try again.


--

I'll bet the From field is the problem - the From field on the General tab
is the email address and the one in Advanced tab is display name. It
worked correctly in 2007. (although it probably shouldn't have). I'm not
sure which one querybuilder uses - try @ in the organizer field on the
first tab and show time as on the advanced tab.




--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.


Thanks for your help with this.

I used Querybuilder and generated the same SQL code, but the calendar
event
with From = "Calendar
[[email protected]]"
is being displayed so the rule isn't finding the "@" in the bracketed
From
information

I simplified the SQL code to:
"urn:schemas:httpmail:fromname" <> '@'
and it still did not filter out the calendar event from the outside
source.

P.S.
The user is running Outlook 2003.


:

Which filter tab are you using? Did you enabled Querybuilder? It makes
it
easy to set up rules...

I used querybuilder and the resulting SQL is
("urn:schemas:httpmail:fromname" <> '@' AND
"http://schemas.microsoft.com/mapi/id/{00062002-0000-0000-C000-000000000046}/82180003"
= 2)

Querybuilder: http://www.outlook-tips.net/archives/2004/20040927.htm


--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point
your
newsreader to msnews.microsoft.com.


I work for a county government. I have a request from a user who
wants me
to
create a filter that will hide certain calendar invitations. They
want a
rule to hide any calendar invitation where: The user is outside our
organization & the meeting status = tentatively accepted or not yet
responded.

They want to filter out any unaccepted invitations (either tentatively
accepted or not yet responded) if it had originated with anyone who is
not
part of our global address list.

They want to see all approved calendar items regardless of who
originated
them, all reoccurring items, all items they created themselves as
reminders
and any calendar events originating from county employees that are
tentatively accepted or not yet responded.

I found out how to look at the meta-data associated with calendar
events
( |
Tools | Forms | Design this form | (All Fields) |) but I don't see
where
to
find the field to search for non "forsythco.com" originators. I can
see
the
web-based email address in the body of the calendar event but I can't
find
a
meta-data field with this information in it. In the "All Mail
Fields" -
From
field, it shows "Calendar
[[email protected]]" but if I build
a
rule
saying to include only calendar events where From does not contain "@"
(thinking that anyone on our global address list would not have their
email
address in here), this calendar event still shows up so I'm assuming
that
the
info inside the [] brackets is not searchable in the rule.

Where would I find the email address of the Originator and how do I
use
that
in a filtering rule.

 

[Diane Poremsky [MVP]]

This is the line for the address (from the first tab) - but you need to make
it exclude @ - which so far, I can't do without crashing.
"http://schemas.microsoft.com/mapi/proptag/0x0c1a001f" <>'@'

--

"urn:schemas:httpmail:fromname" <> '%@%' does not exclude the ones I want
either

I editted the SQL to try
"urn:schemas:httpmail:fromname" NOT LIKE '%@%'
but I get an SQL error:
error parsing your SQL text

FWIW, it won't work to use the tabs - you want to hide the ones with @,
not
show them - you need to use Querybuilder or SQL and my very slow
outlook is
crashing when I edit the SQL created by the From field on the first tab
to
use <> '@'. I'll have to wait for the updates to install and reboot
before
I try again.


--
I'll bet the From field is the problem - the From field on the
General tab
is the email address and the one in Advanced tab is display name. It
worked correctly in 2007. (although it probably shouldn't have). I'm
not
sure which one querybuilder uses - try @ in the organizer field on
the
first tab and show time as on the advanced tab.




--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point
your
newsreader to msnews.microsoft.com.


Thanks for your help with this.

I used Querybuilder and generated the same SQL code, but the
calendar
event
with From = "Calendar
[[email protected]]"
is being displayed so the rule isn't finding the "@" in the
bracketed
From
information

I simplified the SQL code to:
"urn:schemas:httpmail:fromname" <> '@'
and it still did not filter out the calendar event from the outside
source.

P.S.
The user is running Outlook 2003.


:

Which filter tab are you using? Did you enabled Querybuilder? It
makes
it
easy to set up rules...

I used querybuilder and the resulting SQL is
("urn:schemas:httpmail:fromname" <> '@' AND
"http://schemas.microsoft.com/mapi/id/{00062002-0000-0000-C000-000000000046}/82180003"
= 2)

Querybuilder:
http://www.outlook-tips.net/archives/2004/20040927.htm


--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or
point
your
newsreader to msnews.microsoft.com.


I work for a county government. I have a request from a user who
wants me
to
create a filter that will hide certain calendar invitations.
They
want a
rule to hide any calendar invitation where: The user is outside
our
organization & the meeting status = tentatively accepted or not
yet
responded.

They want to filter out any unaccepted invitations (either
tentatively
accepted or not yet responded) if it had originated with anyone
who is
not
part of our global address list.

They want to see all approved calendar items regardless of who
originated
them, all reoccurring items, all items they created themselves as
reminders
and any calendar events originating from county employees that
are
tentatively accepted or not yet responded.

I found out how to look at the meta-data associated with calendar
events
( |
Tools | Forms | Design this form | (All Fields) |) but I don't
see
where
to
find the field to search for non "forsythco.com" originators. I
can
see
the
web-based email address in the body of the calendar event but I
can't
find
a
meta-data field with this information in it. In the "All Mail
Fields" -
From
field, it shows "Calendar
[[email protected]]" but if I
build
a
rule
saying to include only calendar events where From does not
contain "@"
(thinking that anyone on our global address list would not have
their
email
address in here), this calendar event still shows up so I'm
assuming
that
the
info inside the [] brackets is not searchable in the rule.

Where would I find the email address of the Originator and how do
I
use
that
in a filtering rule.

 

[Diane Poremsky [MVP]]

No, when you right click on the item in the inbox and choose message options
(or options)

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

Is 'header' a property of the message?
On the message's "please respond" email, the "header" looks like this:
From, Required, Location, When & message body are filled in
Optional, Subject & Description are not filled in.

Check the message header in the inbox - is it blank?

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point
your
newsreader to msnews.microsoft.com.

Thanks for your help with this.

I used Querybuilder and generated the same SQL code, but the calendar
event
with From = "Calendar
[[email protected]]"
is being displayed so the rule isn't finding the "@" in the bracketed
From
information

I simplified the SQL code to:
"urn:schemas:httpmail:fromname" <> '@'
and it still did not filter out the calendar event from the outside
source.

P.S.
The user is running Outlook 2003.


:

Which filter tab are you using? Did you enabled Querybuilder? It makes
it
easy to set up rules...

I used querybuilder and the resulting SQL is
("urn:schemas:httpmail:fromname" <> '@' AND
"http://schemas.microsoft.com/mapi/id/{00062002-0000-0000-C000-000000000046}/82180003"
= 2)

Querybuilder: http://www.outlook-tips.net/archives/2004/20040927.htm


--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point
your
newsreader to msnews.microsoft.com.


I work for a county government. I have a request from a user who
wants
me
to
create a filter that will hide certain calendar invitations. They
want
a
rule to hide any calendar invitation where: The user is outside our
organization & the meeting status = tentatively accepted or not yet
responded.

They want to filter out any unaccepted invitations (either
tentatively
accepted or not yet responded) if it had originated with anyone who
is
not
part of our global address list.

They want to see all approved calendar items regardless of who
originated
them, all reoccurring items, all items they created themselves as
reminders
and any calendar events originating from county employees that are
tentatively accepted or not yet responded.

I found out how to look at the meta-data associated with calendar
events
( |
Tools | Forms | Design this form | (All Fields) |) but I don't see
where
to
find the field to search for non "forsythco.com" originators. I can
see
the
web-based email address in the body of the calendar event but I
can't
find
a
meta-data field with this information in it. In the "All Mail
Fields" -
From
field, it shows "Calendar
[[email protected]]" but if I
build
a
rule
saying to include only calendar events where From does not contain
"@"
(thinking that anyone on our global address list would not have
their
email
address in here), this calendar event still shows up so I'm assuming
that
the
info inside the [] brackets is not searchable in the rule.

Where would I find the email address of the Originator and how do I
use
that
in a filtering rule.

 

[Rick Young]

In further testing, anything in the brackets [] isn't looked at in the SQL
query.
I tested this with an appointment from "Mad Max [[email protected]]"
I can filter where From <> "Max" or "Mad M" but I cannot filter where From
<> "xyzxyz.com"

This is the line for the address (from the first tab) - but you need to make
it exclude @ - which so far, I can't do without crashing.
"http://schemas.microsoft.com/mapi/proptag/0x0c1a001f" <>'@'

--

"urn:schemas:httpmail:fromname" <> '%@%' does not exclude the ones I want
either

I editted the SQL to try
"urn:schemas:httpmail:fromname" NOT LIKE '%@%'
but I get an SQL error:
error parsing your SQL text

:

FWIW, it won't work to use the tabs - you want to hide the ones with @,
not
show them - you need to use Querybuilder or SQL and my very slow
outlook is
crashing when I edit the SQL created by the From field on the first tab
to
use <> '@'. I'll have to wait for the updates to install and reboot
before
I try again.


--
I'll bet the From field is the problem - the From field on the
General tab
is the email address and the one in Advanced tab is display name. It
worked correctly in 2007. (although it probably shouldn't have). I'm
not
sure which one querybuilder uses - try @ in the organizer field on
the
first tab and show time as on the advanced tab.




--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point
your
newsreader to msnews.microsoft.com.


Thanks for your help with this.

I used Querybuilder and generated the same SQL code, but the
calendar
event
with From = "Calendar
[[email protected]]"
is being displayed so the rule isn't finding the "@" in the
bracketed
From
information

I simplified the SQL code to:
"urn:schemas:httpmail:fromname" <> '@'
and it still did not filter out the calendar event from the outside
source.

P.S.
The user is running Outlook 2003.


:

Which filter tab are you using? Did you enabled Querybuilder? It
makes
it
easy to set up rules...

I used querybuilder and the resulting SQL is
("urn:schemas:httpmail:fromname" <> '@' AND
"http://schemas.microsoft.com/mapi/id/{00062002-0000-0000-C000-000000000046}/82180003"
= 2)

Querybuilder:
http://www.outlook-tips.net/archives/2004/20040927.htm


--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or
point
your
newsreader to msnews.microsoft.com.


I work for a county government. I have a request from a user who
wants me
to
create a filter that will hide certain calendar invitations.
They
want a
rule to hide any calendar invitation where: The user is outside
our
organization & the meeting status = tentatively accepted or not
yet
responded.

They want to filter out any unaccepted invitations (either
tentatively
accepted or not yet responded) if it had originated with anyone
who is
not
part of our global address list.

They want to see all approved calendar items regardless of who
originated
them, all reoccurring items, all items they created themselves as
reminders
and any calendar events originating from county employees that
are
tentatively accepted or not yet responded.

I found out how to look at the meta-data associated with calendar
events
( |
Tools | Forms | Design this form | (All Fields) |) but I don't
see
where
to
find the field to search for non "forsythco.com" originators. I
can
see
the
web-based email address in the body of the calendar event but I
can't
find
a
meta-data field with this information in it. In the "All Mail
Fields" -
From
field, it shows "Calendar
[[email protected]]" but if I
build
a
rule
saying to include only calendar events where From does not
contain "@"
(thinking that anyone on our global address list would not have
their
email
address in here), this calendar event still shows up so I'm
assuming
that
the
info inside the [] brackets is not searchable in the rule.

Where would I find the email address of the Originator and how do
I
use
that
in a filtering rule.

 

[Rick Young]

I looked at the inbound Inbox invitation and the perfect meta-data property
to look at would be "Return Path". Can we reference that in the SQL?

This is the line for the address (from the first tab) - but you need to make
it exclude @ - which so far, I can't do without crashing.
"http://schemas.microsoft.com/mapi/proptag/0x0c1a001f" <>'@'

--

"urn:schemas:httpmail:fromname" <> '%@%' does not exclude the ones I want
either

I editted the SQL to try
"urn:schemas:httpmail:fromname" NOT LIKE '%@%'
but I get an SQL error:
error parsing your SQL text

:

FWIW, it won't work to use the tabs - you want to hide the ones with @,
not
show them - you need to use Querybuilder or SQL and my very slow
outlook is
crashing when I edit the SQL created by the From field on the first tab
to
use <> '@'. I'll have to wait for the updates to install and reboot
before
I try again.


--
I'll bet the From field is the problem - the From field on the
General tab
is the email address and the one in Advanced tab is display name. It
worked correctly in 2007. (although it probably shouldn't have). I'm
not
sure which one querybuilder uses - try @ in the organizer field on
the
first tab and show time as on the advanced tab.




--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point
your
newsreader to msnews.microsoft.com.


Thanks for your help with this.

I used Querybuilder and generated the same SQL code, but the
calendar
event
with From = "Calendar
[[email protected]]"
is being displayed so the rule isn't finding the "@" in the
bracketed
From
information

I simplified the SQL code to:
"urn:schemas:httpmail:fromname" <> '@'
and it still did not filter out the calendar event from the outside
source.

P.S.
The user is running Outlook 2003.


:

Which filter tab are you using? Did you enabled Querybuilder? It
makes
it
easy to set up rules...

I used querybuilder and the resulting SQL is
("urn:schemas:httpmail:fromname" <> '@' AND
"http://schemas.microsoft.com/mapi/id/{00062002-0000-0000-C000-000000000046}/82180003"
= 2)

Querybuilder:
http://www.outlook-tips.net/archives/2004/20040927.htm


--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or
point
your
newsreader to msnews.microsoft.com.


I work for a county government. I have a request from a user who
wants me
to
create a filter that will hide certain calendar invitations.
They
want a
rule to hide any calendar invitation where: The user is outside
our
organization & the meeting status = tentatively accepted or not
yet
responded.

They want to filter out any unaccepted invitations (either
tentatively
accepted or not yet responded) if it had originated with anyone
who is
not
part of our global address list.

They want to see all approved calendar items regardless of who
originated
them, all reoccurring items, all items they created themselves as
reminders
and any calendar events originating from county employees that
are
tentatively accepted or not yet responded.

I found out how to look at the meta-data associated with calendar
events
( |
Tools | Forms | Design this form | (All Fields) |) but I don't
see
where
to
find the field to search for non "forsythco.com" originators. I
can
see
the
web-based email address in the body of the calendar event but I
can't
find
a
meta-data field with this information in it. In the "All Mail
Fields" -
From
field, it shows "Calendar
[[email protected]]" but if I
build
a
rule
saying to include only calendar events where From does not
contain "@"
(thinking that anyone on our global address list would not have
their
email
address in here), this calendar event still shows up so I'm
assuming
that
the
info inside the [] brackets is not searchable in the rule.

Where would I find the email address of the Originator and how do
I
use
that
in a filtering rule.

 

[Rick Young]

I've done some additional research and the MAPI Property PS_INTERNET_HEADERS
is documented to contain the return path. I found this at:
http://blogs.msdn.com/stephen_griffin/archive/2007/03/06/outlook-2007-rtm-docs-properties.aspx

I looked at the inbound Inbox invitation and the perfect meta-data property
to look at would be "Return Path". Can we reference that in the SQL?

This is the line for the address (from the first tab) - but you need to make
it exclude @ - which so far, I can't do without crashing.
"http://schemas.microsoft.com/mapi/proptag/0x0c1a001f" <>'@'

--

"urn:schemas:httpmail:fromname" <> '%@%' does not exclude the ones I want
either

:

I editted the SQL to try
"urn:schemas:httpmail:fromname" NOT LIKE '%@%'
but I get an SQL error:
error parsing your SQL text

:

FWIW, it won't work to use the tabs - you want to hide the ones with @,
not
show them - you need to use Querybuilder or SQL and my very slow
outlook is
crashing when I edit the SQL created by the From field on the first tab
to
use <> '@'. I'll have to wait for the updates to install and reboot
before
I try again.


--
I'll bet the From field is the problem - the From field on the
General tab
is the email address and the one in Advanced tab is display name. It
worked correctly in 2007. (although it probably shouldn't have). I'm
not
sure which one querybuilder uses - try @ in the organizer field on
the
first tab and show time as on the advanced tab.




--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point
your
newsreader to msnews.microsoft.com.


Thanks for your help with this.

I used Querybuilder and generated the same SQL code, but the
calendar
event
with From = "Calendar
[[email protected]]"
is being displayed so the rule isn't finding the "@" in the
bracketed
From
information

I simplified the SQL code to:
"urn:schemas:httpmail:fromname" <> '@'
and it still did not filter out the calendar event from the outside
source.

P.S.
The user is running Outlook 2003.


:

Which filter tab are you using? Did you enabled Querybuilder? It
makes
it
easy to set up rules...

I used querybuilder and the resulting SQL is
("urn:schemas:httpmail:fromname" <> '@' AND
"http://schemas.microsoft.com/mapi/id/{00062002-0000-0000-C000-000000000046}/82180003"
= 2)

Querybuilder:
http://www.outlook-tips.net/archives/2004/20040927.htm


--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or
point
your
newsreader to msnews.microsoft.com.


I work for a county government. I have a request from a user who
wants me
to
create a filter that will hide certain calendar invitations.
They
want a
rule to hide any calendar invitation where: The user is outside
our
organization & the meeting status = tentatively accepted or not
yet
responded.

They want to filter out any unaccepted invitations (either
tentatively
accepted or not yet responded) if it had originated with anyone
who is
not
part of our global address list.

They want to see all approved calendar items regardless of who
originated
them, all reoccurring items, all items they created themselves as
reminders
and any calendar events originating from county employees that
are
tentatively accepted or not yet responded.

I found out how to look at the meta-data associated with calendar
events
( |
Tools | Forms | Design this form | (All Fields) |) but I don't
see
where
to
find the field to search for non "forsythco.com" originators. I
can
see
the
web-based email address in the body of the calendar event but I
can't
find
a
meta-data field with this information in it. In the "All Mail
Fields" -
From
field, it shows "Calendar
[[email protected]]" but if I
build
a
rule
saying to include only calendar events where From does not
contain "@"
(thinking that anyone on our global address list would not have
their
email
address in here), this calendar event still shows up so I'm
assuming
that
the
info inside the [] brackets is not searchable in the rule.

Where would I find the email address of the Originator and how do
I
use
that
in a filtering rule.

 

[Rick Young]

Correction - it's PR_SENT_REPRESENTING_EMAIL_ADDRESS
Found it using Outlook Spy
Now, how can I get access to this property in the SQL code in a rule??

I've done some additional research and the MAPI Property PS_INTERNET_HEADERS
is documented to contain the return path. I found this at:
http://blogs.msdn.com/stephen_griffin/archive/2007/03/06/outlook-2007-rtm-docs-properties.aspx

I looked at the inbound Inbox invitation and the perfect meta-data property
to look at would be "Return Path". Can we reference that in the SQL?

This is the line for the address (from the first tab) - but you need to make
it exclude @ - which so far, I can't do without crashing.
"http://schemas.microsoft.com/mapi/proptag/0x0c1a001f" <>'@'

--


"urn:schemas:httpmail:fromname" <> '%@%' does not exclude the ones I want
either

:

I editted the SQL to try
"urn:schemas:httpmail:fromname" NOT LIKE '%@%'
but I get an SQL error:
error parsing your SQL text

:

FWIW, it won't work to use the tabs - you want to hide the ones with @,
not
show them - you need to use Querybuilder or SQL and my very slow
outlook is
crashing when I edit the SQL created by the From field on the first tab
to
use <> '@'. I'll have to wait for the updates to install and reboot
before
I try again.


--
I'll bet the From field is the problem - the From field on the
General tab
is the email address and the one in Advanced tab is display name. It
worked correctly in 2007. (although it probably shouldn't have). I'm
not
sure which one querybuilder uses - try @ in the organizer field on
the
first tab and show time as on the advanced tab.




--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point
your
newsreader to msnews.microsoft.com.


Thanks for your help with this.

I used Querybuilder and generated the same SQL code, but the
calendar
event
with From = "Calendar
[[email protected]]"
is being displayed so the rule isn't finding the "@" in the
bracketed
From
information

I simplified the SQL code to:
"urn:schemas:httpmail:fromname" <> '@'
and it still did not filter out the calendar event from the outside
source.

P.S.
The user is running Outlook 2003.


:

Which filter tab are you using? Did you enabled Querybuilder? It
makes
it
easy to set up rules...

I used querybuilder and the resulting SQL is
("urn:schemas:httpmail:fromname" <> '@' AND
"http://schemas.microsoft.com/mapi/id/{00062002-0000-0000-C000-000000000046}/82180003"
= 2)

Querybuilder:
http://www.outlook-tips.net/archives/2004/20040927.htm


--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or
point
your
newsreader to msnews.microsoft.com.


I work for a county government. I have a request from a user who
wants me
to
create a filter that will hide certain calendar invitations.
They
want a
rule to hide any calendar invitation where: The user is outside
our
organization & the meeting status = tentatively accepted or not
yet
responded.

They want to filter out any unaccepted invitations (either
tentatively
accepted or not yet responded) if it had originated with anyone
who is
not
part of our global address list.

They want to see all approved calendar items regardless of who
originated
them, all reoccurring items, all items they created themselves as
reminders
and any calendar events originating from county employees that
are
tentatively accepted or not yet responded.

I found out how to look at the meta-data associated with calendar
events
( |
Tools | Forms | Design this form | (All Fields) |) but I don't
see
where
to
find the field to search for non "forsythco.com" originators. I
can
see
the
web-based email address in the body of the calendar event but I
can't
find
a
meta-data field with this information in it. In the "All Mail
Fields" -
From
field, it shows "Calendar
[[email protected]]" but if I
build
a
rule
saying to include only calendar events where From does not
contain "@"
(thinking that anyone on our global address list would not have
their
email
address in here), this calendar event still shows up so I'm
assuming
that
the
info inside the [] brackets is not searchable in the rule.

Where would I find the email address of the Originator and how do
I
use
that
in a filtering rule.

 

[Rick Young]

I went in a different direction AND IT WORKED!!!
The user wants to filter his calendar invitations so he sees:
Approved invitations from anyone &
To-be-reviewed requests from internal people

I've been trying to exclude based on the @ in the email address and could
NOT get that to work.
I found that the property PR_SENDER_ADDRTYPE contains "EX" for Exchange
email addresses (internal) and SMTP for external email addresses.
I found that this property can be queried by using:
http://schemas.microsoft.com/mapi/proptag/0x0C1E001E

So, my SQL code (THAT WORKS!!) to limit

This is the line for the address (from the first tab) - but you need to make
it exclude @ - which so far, I can't do without crashing.
"http://schemas.microsoft.com/mapi/proptag/0x0c1a001f" <>'@'

--

"urn:schemas:httpmail:fromname" <> '%@%' does not exclude the ones I want
either

I editted the SQL to try
"urn:schemas:httpmail:fromname" NOT LIKE '%@%'
but I get an SQL error:
error parsing your SQL text

:

FWIW, it won't work to use the tabs - you want to hide the ones with @,
not
show them - you need to use Querybuilder or SQL and my very slow
outlook is
crashing when I edit the SQL created by the From field on the first tab
to
use <> '@'. I'll have to wait for the updates to install and reboot
before
I try again.


--
I'll bet the From field is the problem - the From field on the
General tab
is the email address and the one in Advanced tab is display name. It
worked correctly in 2007. (although it probably shouldn't have). I'm
not
sure which one querybuilder uses - try @ in the organizer field on
the
first tab and show time as on the advanced tab.




--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point
your
newsreader to msnews.microsoft.com.


Thanks for your help with this.

I used Querybuilder and generated the same SQL code, but the
calendar
event
with From = "Calendar
[[email protected]]"
is being displayed so the rule isn't finding the "@" in the
bracketed
From
information

I simplified the SQL code to:
"urn:schemas:httpmail:fromname" <> '@'
and it still did not filter out the calendar event from the outside
source.

P.S.
The user is running Outlook 2003.


:

Which filter tab are you using? Did you enabled Querybuilder? It
makes
it
easy to set up rules...

I used querybuilder and the resulting SQL is
("urn:schemas:httpmail:fromname" <> '@' AND
"http://schemas.microsoft.com/mapi/id/{00062002-0000-0000-C000-000000000046}/82180003"
= 2)

Querybuilder:
http://www.outlook-tips.net/archives/2004/20040927.htm


--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or
point
your
newsreader to msnews.microsoft.com.


I work for a county government. I have a request from a user who
wants me
to
create a filter that will hide certain calendar invitations.
They
want a
rule to hide any calendar invitation where: The user is outside
our
organization & the meeting status = tentatively accepted or not
yet
responded.

They want to filter out any unaccepted invitations (either
tentatively
accepted or not yet responded) if it had originated with anyone
who is
not
part of our global address list.

They want to see all approved calendar items regardless of who
originated
them, all reoccurring items, all items they created themselves as
reminders
and any calendar events originating from county employees that
are
tentatively accepted or not yet responded.

I found out how to look at the meta-data associated with calendar
events
( |
Tools | Forms | Design this form | (All Fields) |) but I don't
see
where
to
find the field to search for non "forsythco.com" originators. I
can
see
the
web-based email address in the body of the calendar event but I
can't
find
a
meta-data field with this information in it. In the "All Mail
Fields" -
From
field, it shows "Calendar
[[email protected]]" but if I
build
a
rule
saying to include only calendar events where From does not
contain "@"
(thinking that anyone on our global address list would not have
their
email
address in here), this calendar event still shows up so I'm
assuming
that
the
info inside the [] brackets is not searchable in the rule.

Where would I find the email address of the Originator and how do
I
use
that
in a filtering rule.

 

[Rick Young]

I went in a different direction AND IT WORKED!!!
The user wants to filter his calendar invitations so he sees:
Approved invitations from anyone &
To-be-reviewed requests from internal people

I've been trying to exclude based on the @ in the email address and could
NOT get that to work.
I found that the property PR_SENDER_ADDRTYPE contains "EX" for Exchange
email addresses (internal) and SMTP for external email addresses.
I found that this property can be queried by using:
http://schemas.microsoft.com/mapi/proptag/0x0C1E001E

So, my SQL code (THAT WORKS!!) to hide tentatively accepted and not
responded invitations from anyone not part of our Exchange is:

NOT (("http://schemas.microsoft.com/mapi/proptag/0x0C1E001E" = 'SMTP') AND
("http://schemas.microsoft.com/mapi/id/{00062002-0000-0000-C000-000000000046}/82180003"
= 2 OR
"http://schemas.microsoft.com/mapi/id/{00062002-0000-0000-C000-000000000046}/82180003" = 5))

FWIW, it won't work to use the tabs - you want to hide the ones with @, not
show them - you need to use Querybuilder or SQL and my very slow outlook is
crashing when I edit the SQL created by the From field on the first tab to
use <> '@'. I'll have to wait for the updates to install and reboot before
I try again.


--

I'll bet the From field is the problem - the From field on the General tab
is the email address and the one in Advanced tab is display name. It
worked correctly in 2007. (although it probably shouldn't have). I'm not
sure which one querybuilder uses - try @ in the organizer field on the
first tab and show time as on the advanced tab.




--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

Thanks for your help with this.

I used Querybuilder and generated the same SQL code, but the calendar
event
with From = "Calendar
[[email protected]]"
is being displayed so the rule isn't finding the "@" in the bracketed
From
information

I simplified the SQL code to:
"urn:schemas:httpmail:fromname" <> '@'
and it still did not filter out the calendar event from the outside
source.

P.S.
The user is running Outlook 2003.


:

Which filter tab are you using? Did you enabled Querybuilder? It makes
it
easy to set up rules...

I used querybuilder and the resulting SQL is
("urn:schemas:httpmail:fromname" <> '@' AND
"http://schemas.microsoft.com/mapi/id/{00062002-0000-0000-C000-000000000046}/82180003"
= 2)

Querybuilder: http://www.outlook-tips.net/archives/2004/20040927.htm


--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point
your
newsreader to msnews.microsoft.com.


I work for a county government. I have a request from a user who
wants me
to
create a filter that will hide certain calendar invitations. They
want a
rule to hide any calendar invitation where: The user is outside our
organization & the meeting status = tentatively accepted or not yet
responded.

They want to filter out any unaccepted invitations (either tentatively
accepted or not yet responded) if it had originated with anyone who is
not
part of our global address list.

They want to see all approved calendar items regardless of who
originated
them, all reoccurring items, all items they created themselves as
reminders
and any calendar events originating from county employees that are
tentatively accepted or not yet responded.

I found out how to look at the meta-data associated with calendar
events
( |
Tools | Forms | Design this form | (All Fields) |) but I don't see
where
to
find the field to search for non "forsythco.com" originators. I can
see
the
web-based email address in the body of the calendar event but I can't
find
a
meta-data field with this information in it. In the "All Mail
Fields" -
From
field, it shows "Calendar
[[email protected]]" but if I build
a
rule
saying to include only calendar events where From does not contain "@"
(thinking that anyone on our global address list would not have their
email
address in here), this calendar event still shows up so I'm assuming
that
the
info inside the [] brackets is not searchable in the rule.

Where would I find the email address of the Originator and how do I
use
that
in a filtering rule.

 

[Diane Poremsky [MVP]]

Cool. Thanks for sharing.

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

I went in a different direction AND IT WORKED!!!
The user wants to filter his calendar invitations so he sees:
Approved invitations from anyone &
To-be-reviewed requests from internal people

I've been trying to exclude based on the @ in the email address and could
NOT get that to work.
I found that the property PR_SENDER_ADDRTYPE contains "EX" for Exchange
email addresses (internal) and SMTP for external email addresses.
I found that this property can be queried by using:
http://schemas.microsoft.com/mapi/proptag/0x0C1E001E

So, my SQL code (THAT WORKS!!) to limit

This is the line for the address (from the first tab) - but you need to
make
it exclude @ - which so far, I can't do without crashing.
"http://schemas.microsoft.com/mapi/proptag/0x0c1a001f" <>'@'

--

"urn:schemas:httpmail:fromname" <> '%@%' does not exclude the ones I
want
either

:

I editted the SQL to try
"urn:schemas:httpmail:fromname" NOT LIKE '%@%'
but I get an SQL error:
error parsing your SQL text

:

FWIW, it won't work to use the tabs - you want to hide the ones with
@,
not
show them - you need to use Querybuilder or SQL and my very slow
outlook is
crashing when I edit the SQL created by the From field on the first
tab
to
use <> '@'. I'll have to wait for the updates to install and reboot
before
I try again.


--
I'll bet the From field is the problem - the From field on the
General tab
is the email address and the one in Advanced tab is display name.
It
worked correctly in 2007. (although it probably shouldn't have).
I'm
not
sure which one querybuilder uses - try @ in the organizer field on
the
first tab and show time as on the advanced tab.




--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or
point
your
newsreader to msnews.microsoft.com.


message
Thanks for your help with this.

I used Querybuilder and generated the same SQL code, but the
calendar
event
with From = "Calendar
[[email protected]]"
is being displayed so the rule isn't finding the "@" in the
bracketed
From
information

I simplified the SQL code to:
"urn:schemas:httpmail:fromname" <> '@'
and it still did not filter out the calendar event from the
outside
source.

P.S.
The user is running Outlook 2003.


:

Which filter tab are you using? Did you enabled Querybuilder? It
makes
it
easy to set up rules...

I used querybuilder and the resulting SQL is
("urn:schemas:httpmail:fromname" <> '@' AND
"http://schemas.microsoft.com/mapi/id/{00062002-0000-0000-C000-000000000046}/82180003"
= 2)

Querybuilder:
http://www.outlook-tips.net/archives/2004/20040927.htm


--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks?
http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or
point
your
newsreader to msnews.microsoft.com.


message
I work for a county government. I have a request from a user
who
wants me
to
create a filter that will hide certain calendar invitations.
They
want a
rule to hide any calendar invitation where: The user is
outside
our
organization & the meeting status = tentatively accepted or
not
yet
responded.

They want to filter out any unaccepted invitations (either
tentatively
accepted or not yet responded) if it had originated with
anyone
who is
not
part of our global address list.

They want to see all approved calendar items regardless of who
originated
them, all reoccurring items, all items they created themselves
as
reminders
and any calendar events originating from county employees that
are
tentatively accepted or not yet responded.

I found out how to look at the meta-data associated with
calendar
events
( |
Tools | Forms | Design this form | (All Fields) |) but I don't
see
where
to
find the field to search for non "forsythco.com" originators.
I
can
see
the
web-based email address in the body of the calendar event but
I
can't
find
a
meta-data field with this information in it. In the "All Mail
Fields" -
From
field, it shows "Calendar
[[email protected]]" but if
I
build
a
rule
saying to include only calendar events where From does not
contain "@"
(thinking that anyone on our global address list would not
have
their
email
address in here), this calendar event still shows up so I'm
assuming
that
the
info inside the [] brackets is not searchable in the rule.

Where would I find the email address of the Originator and how
do
I
use
that
in a filtering rule.