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
[(E-Mail Removed)]" 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.

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:
dailytips-subscribe-(E-Mail Removed)

Exchange Messaging Outlook newsletter:
EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


"Rick Young" <(E-Mail Removed)> wrote in message
news:B0E17E6B-9130-4737-AFAA-(E-Mail Removed)...
> 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
> [(E-Mail Removed)]" 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.

Thanks for your help with this.

I used Querybuilder and generated the same SQL code, but the calendar event
with From = "Calendar [(E-Mail Removed)]"
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.


"Diane Poremsky [MVP]" wrote:

> 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:
> dailytips-subscribe-(E-Mail Removed)
>
> Exchange Messaging Outlook newsletter:
> EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)
>
> Outlook Tips: http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center: http://www.slipstick.com
>
> You can access this newsgroup by visiting
> http://www.microsoft.com/office/comm...s/default.mspx or point your
> newsreader to msnews.microsoft.com.
>
>
> "Rick Young" <(E-Mail Removed)> wrote in message
> news:B0E17E6B-9130-4737-AFAA-(E-Mail Removed)...
> > 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
> > [(E-Mail Removed)]" 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.
>
>

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:
dailytips-subscribe-(E-Mail Removed)

Exchange Messaging Outlook newsletter:
EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


"Rick Young" <(E-Mail Removed)> wrote in message
news:1653637D-AA29-405F-8B98-(E-Mail Removed)...
> Thanks for your help with this.
>
> I used Querybuilder and generated the same SQL code, but the calendar
> event
> with From = "Calendar
> [(E-Mail Removed)]"
> 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.
>
>
> "Diane Poremsky [MVP]" wrote:
>
>> 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:
>> dailytips-subscribe-(E-Mail Removed)
>>
>> Exchange Messaging Outlook newsletter:
>> EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)
>>
>> Outlook Tips: http://www.outlook-tips.net/
>> Outlook & Exchange Solutions Center: http://www.slipstick.com
>>
>> You can access this newsgroup by visiting
>> http://www.microsoft.com/office/comm...s/default.mspx or point
>> your
>> newsreader to msnews.microsoft.com.
>>
>>
>> "Rick Young" <(E-Mail Removed)> wrote in message
>> news:B0E17E6B-9130-4737-AFAA-(E-Mail Removed)...
>> > 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
>> > [(E-Mail Removed)]" 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.
>>
>>

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:
dailytips-subscribe-(E-Mail Removed)

Exchange Messaging Outlook newsletter:
EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


"Rick Young" <(E-Mail Removed)> wrote in message
news:1653637D-AA29-405F-8B98-(E-Mail Removed)...
> Thanks for your help with this.
>
> I used Querybuilder and generated the same SQL code, but the calendar
> event
> with From = "Calendar
> [(E-Mail Removed)]"
> 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.
>
>
> "Diane Poremsky [MVP]" wrote:
>
>> 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:
>> dailytips-subscribe-(E-Mail Removed)
>>
>> Exchange Messaging Outlook newsletter:
>> EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)
>>
>> Outlook Tips: http://www.outlook-tips.net/
>> Outlook & Exchange Solutions Center: http://www.slipstick.com
>>
>> You can access this newsgroup by visiting
>> http://www.microsoft.com/office/comm...s/default.mspx or point
>> your
>> newsreader to msnews.microsoft.com.
>>
>>
>> "Rick Young" <(E-Mail Removed)> wrote in message
>> news:B0E17E6B-9130-4737-AFAA-(E-Mail Removed)...
>> > 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
>> > [(E-Mail Removed)]" 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.
>>
>>

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.

"Diane Poremsky [MVP]" wrote:

> 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:
> dailytips-subscribe-(E-Mail Removed)
>
> Exchange Messaging Outlook newsletter:
> EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)
>
> Outlook Tips: http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center: http://www.slipstick.com
>
> You can access this newsgroup by visiting
> http://www.microsoft.com/office/comm...s/default.mspx or point your
> newsreader to msnews.microsoft.com.
>
>
> "Rick Young" <(E-Mail Removed)> wrote in message
> news:1653637D-AA29-405F-8B98-(E-Mail Removed)...
> > Thanks for your help with this.
> >
> > I used Querybuilder and generated the same SQL code, but the calendar
> > event
> > with From = "Calendar
> > [(E-Mail Removed)]"
> > 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.
> >
> >
> > "Diane Poremsky [MVP]" wrote:
> >
> >> 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:
> >> dailytips-subscribe-(E-Mail Removed)
> >>
> >> Exchange Messaging Outlook newsletter:
> >> EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)
> >>
> >> Outlook Tips: http://www.outlook-tips.net/
> >> Outlook & Exchange Solutions Center: http://www.slipstick.com
> >>
> >> You can access this newsgroup by visiting
> >> http://www.microsoft.com/office/comm...s/default.mspx or point
> >> your
> >> newsreader to msnews.microsoft.com.
> >>
> >>
> >> "Rick Young" <(E-Mail Removed)> wrote in message
> >> news:B0E17E6B-9130-4737-AFAA-(E-Mail Removed)...
> >> > 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
> >> > [(E-Mail Removed)]" 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.
> >>
> >>
>

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.


--
"Diane Poremsky [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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:
> dailytips-subscribe-(E-Mail Removed)
>
> Exchange Messaging Outlook newsletter:
> EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)
>
> Outlook Tips: http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center: http://www.slipstick.com
>
> You can access this newsgroup by visiting
> http://www.microsoft.com/office/comm...s/default.mspx or point your
> newsreader to msnews.microsoft.com.
>
>
> "Rick Young" <(E-Mail Removed)> wrote in message
> news:1653637D-AA29-405F-8B98-(E-Mail Removed)...
>> Thanks for your help with this.
>>
>> I used Querybuilder and generated the same SQL code, but the calendar
>> event
>> with From = "Calendar
>> [(E-Mail Removed)]"
>> 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.
>>
>>
>> "Diane Poremsky [MVP]" wrote:
>>
>>> 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:
>>> dailytips-subscribe-(E-Mail Removed)
>>>
>>> Exchange Messaging Outlook newsletter:
>>> EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)
>>>
>>> Outlook Tips: http://www.outlook-tips.net/
>>> Outlook & Exchange Solutions Center: http://www.slipstick.com
>>>
>>> You can access this newsgroup by visiting
>>> http://www.microsoft.com/office/comm...s/default.mspx or point
>>> your
>>> newsreader to msnews.microsoft.com.
>>>
>>>
>>> "Rick Young" <(E-Mail Removed)> wrote in message
>>> news:B0E17E6B-9130-4737-AFAA-(E-Mail Removed)...
>>> > 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
>>> > [(E-Mail Removed)]" 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.
>>>
>>>

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

"Diane Poremsky [MVP]" wrote:

> 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.
>
>
> --
> "Diane Poremsky [MVP]" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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:
> > dailytips-subscribe-(E-Mail Removed)
> >
> > Exchange Messaging Outlook newsletter:
> > EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)
> >
> > Outlook Tips: http://www.outlook-tips.net/
> > Outlook & Exchange Solutions Center: http://www.slipstick.com
> >
> > You can access this newsgroup by visiting
> > http://www.microsoft.com/office/comm...s/default.mspx or point your
> > newsreader to msnews.microsoft.com.
> >
> >
> > "Rick Young" <(E-Mail Removed)> wrote in message
> > news:1653637D-AA29-405F-8B98-(E-Mail Removed)...
> >> Thanks for your help with this.
> >>
> >> I used Querybuilder and generated the same SQL code, but the calendar
> >> event
> >> with From = "Calendar
> >> [(E-Mail Removed)]"
> >> 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.
> >>
> >>
> >> "Diane Poremsky [MVP]" wrote:
> >>
> >>> 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:
> >>> dailytips-subscribe-(E-Mail Removed)
> >>>
> >>> Exchange Messaging Outlook newsletter:
> >>> EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)
> >>>
> >>> Outlook Tips: http://www.outlook-tips.net/
> >>> Outlook & Exchange Solutions Center: http://www.slipstick.com
> >>>
> >>> You can access this newsgroup by visiting
> >>> http://www.microsoft.com/office/comm...s/default.mspx or point
> >>> your
> >>> newsreader to msnews.microsoft.com.
> >>>
> >>>
> >>> "Rick Young" <(E-Mail Removed)> wrote in message
> >>> news:B0E17E6B-9130-4737-AFAA-(E-Mail Removed)...
> >>> > 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
> >>> > [(E-Mail Removed)]" 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.
> >>>
> >>>
>

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

"Rick Young" wrote:

> I editted the SQL to try
> "urn:schemas:httpmail:fromname" NOT LIKE '%@%'
> but I get an SQL error:
> error parsing your SQL text
>
> "Diane Poremsky [MVP]" wrote:
>
> > 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.
> >
> >
> > --
> > "Diane Poremsky [MVP]" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > 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:
> > > dailytips-subscribe-(E-Mail Removed)
> > >
> > > Exchange Messaging Outlook newsletter:
> > > EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)
> > >
> > > Outlook Tips: http://www.outlook-tips.net/
> > > Outlook & Exchange Solutions Center: http://www.slipstick.com
> > >
> > > You can access this newsgroup by visiting
> > > http://www.microsoft.com/office/comm...s/default.mspx or point your
> > > newsreader to msnews.microsoft.com.
> > >
> > >
> > > "Rick Young" <(E-Mail Removed)> wrote in message
> > > news:1653637D-AA29-405F-8B98-(E-Mail Removed)...
> > >> Thanks for your help with this.
> > >>
> > >> I used Querybuilder and generated the same SQL code, but the calendar
> > >> event
> > >> with From = "Calendar
> > >> [(E-Mail Removed)]"
> > >> 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.
> > >>
> > >>
> > >> "Diane Poremsky [MVP]" wrote:
> > >>
> > >>> 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:
> > >>> dailytips-subscribe-(E-Mail Removed)
> > >>>
> > >>> Exchange Messaging Outlook newsletter:
> > >>> EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)
> > >>>
> > >>> Outlook Tips: http://www.outlook-tips.net/
> > >>> Outlook & Exchange Solutions Center: http://www.slipstick.com
> > >>>
> > >>> You can access this newsgroup by visiting
> > >>> http://www.microsoft.com/office/comm...s/default.mspx or point
> > >>> your
> > >>> newsreader to msnews.microsoft.com.
> > >>>
> > >>>
> > >>> "Rick Young" <(E-Mail Removed)> wrote in message
> > >>> news:B0E17E6B-9130-4737-AFAA-(E-Mail Removed)...
> > >>> > 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
> > >>> > [(E-Mail Removed)]" 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.
> > >>>
> > >>>
> >

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" <>'@'

--


"Rick Young" <(E-Mail Removed)> wrote in message
news:A089FED2-D3A6-473F-81B5-(E-Mail Removed)...
> "urn:schemas:httpmail:fromname" <> '%@%' does not exclude the ones I want
> either
>
> "Rick Young" wrote:
>
>> I editted the SQL to try
>> "urn:schemas:httpmail:fromname" NOT LIKE '%@%'
>> but I get an SQL error:
>> error parsing your SQL text
>>
>> "Diane Poremsky [MVP]" wrote:
>>
>> > 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.
>> >
>> >
>> > --
>> > "Diane Poremsky [MVP]" <(E-Mail Removed)> wrote in message
>> > news:(E-Mail Removed)...
>> > > 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:
>> > > dailytips-subscribe-(E-Mail Removed)
>> > >
>> > > Exchange Messaging Outlook newsletter:
>> > > EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)
>> > >
>> > > Outlook Tips: http://www.outlook-tips.net/
>> > > Outlook & Exchange Solutions Center: http://www.slipstick.com
>> > >
>> > > You can access this newsgroup by visiting
>> > > http://www.microsoft.com/office/comm...s/default.mspx or point
>> > > your
>> > > newsreader to msnews.microsoft.com.
>> > >
>> > >
>> > > "Rick Young" <(E-Mail Removed)> wrote in message
>> > > news:1653637D-AA29-405F-8B98-(E-Mail Removed)...
>> > >> Thanks for your help with this.
>> > >>
>> > >> I used Querybuilder and generated the same SQL code, but the
>> > >> calendar
>> > >> event
>> > >> with From = "Calendar
>> > >> [(E-Mail Removed)]"
>> > >> 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.
>> > >>
>> > >>
>> > >> "Diane Poremsky [MVP]" wrote:
>> > >>
>> > >>> 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:
>> > >>> dailytips-subscribe-(E-Mail Removed)
>> > >>>
>> > >>> Exchange Messaging Outlook newsletter:
>> > >>> EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)
>> > >>>
>> > >>> Outlook Tips: http://www.outlook-tips.net/
>> > >>> Outlook & Exchange Solutions Center: http://www.slipstick.com
>> > >>>
>> > >>> You can access this newsgroup by visiting
>> > >>> http://www.microsoft.com/office/comm...s/default.mspx or
>> > >>> point
>> > >>> your
>> > >>> newsreader to msnews.microsoft.com.
>> > >>>
>> > >>>
>> > >>> "Rick Young" <(E-Mail Removed)> wrote in message
>> > >>> news:B0E17E6B-9130-4737-AFAA-(E-Mail Removed)...
>> > >>> > 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
>> > >>> > [(E-Mail Removed)]" 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.
>> > >>>
>> > >>>
>> >