Either \ or conditions in rules
Is it possible in Outlook 2003 to create a rule with either \ or conditions,
eg If the message has certain words in the subject line OR if there are
certain words in the body of the message? As far as I can see, you can only
create conditions linked with AND.
In that scenario, you would need to create two separate rules, each with =
the same actions.=20
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developers
...Help Modified Opportunity Statuscode
I need some help. I mistakenly deleted the default statuscode "In Progress"
for an opporunity. Now, if I try to reopen an opportunity I get invalid
status code. I cannot readd the default "1" "In Progress". I have looked
through the database to see if I could find it.
Can someone please tell me how to add the default status code for an
thank you in advance
Nevermind I figured out a workaround.
"Jason Sparks" wrote:
> I need some help. I mistakenly deleted the default statuscode "In Progress&quo...rules based on recipient address
We have one mailbox that has different email addresses that point to it. We
have within this mailbox folders. Depending on what email address mail was
sent to we want rules to move them into the relevent folder. Outlook and/or
Exchange shows the name of the account in the 'to' feild so that our rules do
not work as they are based on where the email was sent. how can we get over
IE main is Internet. Mail sent to email@example.com should go to Internet but
then get moved to the 'WEB' folder based on the firstname.lastname@example.org address. But
Internet is showing in the recpient field.
...Help! Exchange 2003 Disaster Recovery problem!!
Dealing with a disaster recovery situation, to a new box. Only 1 Exchange
server in the domain. Here's what's happened so far:
All servers are running Windows 2003 Standard. When I arrived onsite, I
backed up the Exchange databases off the old "Mailserver2", which is
crashing due to hardware failure/age/being improperly configured. I then
turned it off. Next, on the server "Applied", I ran NTDSUTIL, and removed
any erroneous DC entries (there were many DCs that the previous tech didn't
demote when he took them offline), along with removing Mailserv...Sent Message Rule
I know this is an Outlook ng. but I'm using Outlook Express and can't seem
to create a rule that copies my sent messages to a particular folder. 2
e-mail addresses in one Account. I want to send the sent messages from the
Sent Items folder to another.
The Bear <email@example.com> wrote:
> I know this is an Outlook ng. but I'm using Outlook Express
Then you should ask in an Outlook Express newsgroup.
...Need help with ISNA, INDEX, MATCH
I am trying to write a formula using the ISNA for finding the name to an ID.
In Sheet 1 cell E2, I tried the following
On Sheet 2 the ID is in column A but I need the name of the ID that is found
in column F. If the ID in column D on Sheet1 is blank, I want the name on
Sheet 1 to be blank. If the ID in column D on SHeet 1 is not found in column
A on Sheet 2, then I want the result to be "Invalid ID"
Begin where you left off:
I would like to use colors to change an email when
received from 1 of a group of like 60 people. (All 60
senders I would like to color their email when recieved)
I am limited by the number of color rules that I am
allowed to put into place.
I am unable to create one rule for the group of users as
well, as I get an error and outlook closes on me.
There is probably a very simple script that can be
written but I am not that familiar with writing those.
I have tried to assign category through a rule on the
list of these people, but it will not allow me to upload
to the exchange ...Message Rules
Why don't the message rules work? I keep making messages to block the word
Viagra (any combination of spelling variations) and numerous other words, and
delete the messages. I have over 400 rule, most about Viagra, and NONE of
them are working.
What exactly are you specifying? See http://www.insideoe.com/tips/rules.htm
The rules are the same in WinMail except they added the junk folder.
"Darrell Bartels" <Darrell Bartels@discussions.microsoft.com> wrote in
> Why don't the mes...[Help] OnPaint Skipped?
I have an CTestWnd defined as follow
class CTestWnd : public CWnd
afx_msg void OnPaint();
and i create an instance of CTestWnd as a child window of hWndParent
lpClassName=AfxRegisterWndClass(CS_VREDRAW | CS_HREDRAW |CS_GLOBALCLASS,
::LoadCursor(NULL, IDC_ARROW),(HBRUSH) ::GetStockObject(WHITE_BRUSH),
m_Wnd.CreateEx(NULL,lpClassName, _T("TEST"...How do I set up Server Rule to move Emails to a an Exchange 2007 public Folder?
Dear Exchange people,
We are using Exchange 2007 and Outlook 2003 and Outlook 2007. I have
emails that come in every day that need to be moved to an Exchange
public folder based on words in the emails subject. I set up a rule
in Outlook 2003 to move it to the public folder automatically and it
usually works when Outlook is open, but I need it to just run on the
server and not require Outlook to be open to run it. Would anyone be
so kind and friendly as to share with me an example of how to get it
to work on the server and not require the Outlook client to process
Thanks in...Emulate Out of Office Assistant in a rule?
I want to be able to emulate the OoO assistant in a server
side rule, specifically I want it to only reply once to
Currently we have several customer service and tech
support mailboxes that have server side reply rules that
reply with a template directing them to our website for
support. However, this rule EASILY gets caught up in loops
to the point where I have to check it daily and turn off
the rule temporarily to break the loop.
I would use the Out of office assistant on the mailboxes,
but the subject text "Out of Office:" seems to be static
which wouldn...Outlook2003: Display rules disappear (Tools/Organize/Colors/Automatic..)
Some help needed re rules created in Tools/Organize/Colors/Automatic..:
Those rules disappear randomly and without obvious reason. Some of them move
to an other folder, where they are useless.
Is there any way to save/restore those rules in order to avoid rekeying
everything again and again?
Where are they located? Are they accessible?
Thanks for your help,
they are stored in views - did you change views on the folder where you lost
The best way to keep them is to copy the current view or make a new view and
set the rules.
Diane Poremsky [MVP - Outlook]
...GP10 Upgrade error Help Please.
I am upgrading from 8.0 sp5 to 10
I am tryingto run the script on page 27.
select RTV_Return_Status from SVC05002 group by RTV_Return_Status having
count(*) > 1
I get the following error
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'SVC05002'.
Page 27 say to call Microsoft or email support if results are retured after
running the script.
Support is closed and I was hoping to get this done over the weekend.
Anyone out there have any ideas?
Thanks in advance for your help.
Aftere further review I am thinking maybe I do not have this table because we...Can't get my head around this query..help!
I have a table that records when a form is returned (by year, 2008/09,
2009/10, 2010/11), every company in the table is sent a form.
When the business returns the form, their record is updated with the year
and the date when it was returned.
I am trying to figure out how to enter criteria into a query so that it
filters what companies have not yet sent in a form for 2010/11 without
displaying previous years records (if applicable, e.g. they may have only
joined us in 2010/11)
Ideally, a "date_form_sent" would have been extremely helpful in this
circumstance, but ...Rules in Error
I have a number of rules in place to reduce spam by
permanently deleting certain messages upon their arrival
based on content. But every day the "Rules in Error"
window pops up with the message "You don't have
appropriate permission to perform this operation" and the
applicable rule is deactivated from that point on. This
seems to occur randomly for no particular reason. If I
subsequently run the rule manually, the messages are then
Is there a way to stop this?
...Help needed, setting up conditions
I am not exactly sure how to word this, I'll try my best.. I know I've come
to the right place, that's for sure!
I have been given a spreadsheet - as follows:
First column (A) is a list of locations.
Column B, C, D, E, F, & G are 6 individual items.
Down each of these columns are year to date sales of each of these 6 items,
which correspond with each location listed in column A.
The next 6 columns would show the remaining inventory of each item, at each
I would like to set up a third set of columns that would alert me when
inventory falls below a certain poi...using variable length named ranges problem
I have 3 variable length lists of data that need to be concatenated in to
Presently the following formula works (This is typed in to A1 and copied
down the column using the drag handle so in cell A2 refs to C1,D1,E1 are
automatically changed to C2,D2,E2 and so on):
Result - a list of data in column A which is the list of data in column C
plus data in column D plus ...help with serializing
hi, i am trying to serialize the following class :
public class StationData
public Station Station;
public class Station
public int ID;
public bool IDSpecified;
public string Name;
public GameSetData GameSets;
public class GameSetData
public int ID;
...Message Rules Unavailable (2002)
Running Outlook 2002, I don't seem to have the "message rules" installed. I
did select Junk-Mail during custom setup, but no rules option under Tools.
Also when right clicking on a message there is "Junk Email" but it results
in a blank submenu.
I seem to be missing the rules wizard. How can I remedy this?
"Battleax" <firstname.lastname@example.org> wrote in message
> Running Outlook 2002, I don't seem to have the "message rules" installed.
> did select Junk-Mail during custom setup, b...Help with a conditional macro
I have seen something like this here before but can't seem to searc
correctly for it. Say I have a city name in cell A4. Then I input
city into cell B4. If there entries match I would like nothing t
happen. however if a different city is entered, I would like to run
macro. I'm sure that I have seen a similar question asked here but ca
not remember when.
Any help would be appreciated.
Message posted from http://www.ExcelForum.com
This may get you started.
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A4").Value = Ran...OL 2007 Rules
I am having some weird problems with the rules in Outlook.They seem to
stop working after awhile. I have to create a new one for them to start
I running Outlook 2007 (12.0.6423.1000) SP2 MSO (12.0.6425.1000)
Anyone else having any issues with rules?
...Rules, Rules, Rules
I am trying to make a rule that tells people I am out of
office because I don't have an out of office menu (do not
use Exchange). When I select "reply using a specific
template" I run into a problem. I do not have
any "Standard Templates" loaded so I want to create one
under "User Template in File System". But this is looking
for a *.oft file. What is a *.oft file and how do I create
one? Any other way to accomplish making this rule?
Create your out of office message using Outlook's mail editor, not word.
then use file->save as->outlook templ...Fonts AA Excel Report from Distribution Query Wizard
The Distribution Query Analyzer generates a font of Arial Regular 8 and I
need to go to an Arial 11 on the Excel report. Can this be done?
...Albert Kallal or Marshall Barton Help please
Multi Select Example:
From another post Marshall, you suggested the code above to solve my problem
of an undbound check box in a continous form. This really looks like it will
work for me. I have spent about 2 hours going over the code and trying to
change it for my database, but I am missing something. Would either of you
be willing to help? Please.
Not sure if this will help but here is the entire code for the form I am
trying to use the code on. I am so sure I have missed something simple to
those who know th...Help on Pivot table
When i do pivot i get the data displayed as
Contractor Circle Count
X 1 10
Y 1 10
Z 1 10
I want to display as
Contractor Circle ...