Reply:

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 --=20 Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for=20 Administrators, Power Users, and Developers ...

Help Modified Opportunity Statuscode
Hello: 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 opportunity. thank you in advance Nevermind I figured out a workaround. "Jason Sparks" wrote: > Hello: > > 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 this? IE main is Internet. Mail sent to web@here.com should go to Internet but then get moved to the 'WEB' folder based on the web@here.com 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. TB The Bear <buck_roggers@hotmail.com> wrote: > I know this is an Outlook ng. but I'm using Outlook Express Then you should ask in an Outlook Express newsgroup. news://msnews.microsoft.com/microsoft.public.windows.inetexplorer.ie6_outlookexpress is one. -- Brian Tillman ...

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 formula...=IF(D2>0,INDEX(Sheet2!A:F,MATCH('Sheet1'!D2,Sheet2!A:A,0),6),"") 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" Thank you. Begin where you left off: =IF(D2>0,IF(ISNUMBER(MATCH(Sh...

Color rule
Hi 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. steve "Darrell Bartels" <Darrell Bartels@discussions.microsoft.com> wrote in message news:3B3A29A3-739A-433A-9A2C-7EF6ED93EA08@microsoft.com... > Why don't the mes...

[Help] OnPaint Skipped?
I have an CTestWnd defined as follow class CTestWnd : public CWnd { DECLARE_DYNAMIC(CTestWnd) public: CTestWnd(); virtual ~CTestWnd(); protected: DECLARE_MESSAGE_MAP() public: afx_msg void OnPaint(); }; and i create an instance of CTestWnd as a child window of hWndParent LPCTSTR lpClassName; lpClassName=AfxRegisterWndClass(CS_VREDRAW | CS_HREDRAW |CS_GLOBALCLASS, ::LoadCursor(NULL, IDC_ARROW),(HBRUSH) ::GetStockObject(WHITE_BRUSH), ::LoadIcon(NULL, IDI_APPLICATION)); RECT rect; ::GetClientRect(hWndParent, &rect); 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 it? 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 each recipient. 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..)
Hi all, 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, Bibif they are stored in views - did you change views on the folder where you lost them? 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. Rick 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 deleted. 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 location. 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 one column. 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): =IF(ROW()<=COUNTA(C:C),C1,IF(ROW()<=(COUNTA(C:C)+COUNTA(D:D)),OFFSET(D1,(COU NTA(C:C)),0,1,1),IF(ROW()<=(COUNTA(C:C)+COUNTA(D:D)+COUNTA(E:E)),OFFSET(E1,- (COUNTA(C:C)+COUNTA(D:D)),0,1,1),""))) 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 : namespace MyNameSpace { [System.Xml.Serialization.XmlRootAttribute("StationData", Namespace="", IsNullable=false)] public class StationData { [System.Xml.Serialization.XmlElementAttribute("Station")] public Station[] Station; } public class Station { public int ID; [System.Xml.Serialization.XmlIgnoreAttribute()] public bool IDSpecified; public string Name; [System.Xml.Serialization.XmlElementAttribute("GameSets")] 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? Thanks B "Battleax" <unavailable@thistime.net> wrote in message news:0radnYU5TeeI6XeiRVn-iQ@magma.ca... > Running Outlook 2002, I don't seem to have the "message rules" installed. I > 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. Jerry Egglesto -- Message posted from http://www.ExcelForum.com Hi Jerry, This may get you started. Private Sub Worksheet_Change(ByVal Target As Range) If Range("A4").Value = Ran...

OL 2007 Rules
Hello people, 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 working again. I running Outlook 2007 (12.0.6423.1000) SP2 MSO (12.0.6425.1000) Anyone else having any issues with rules? Thanks Mark ...

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: http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html 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. Sue 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 2 15 3 20 Y 1 10 2 15 3 20 Z 1 10 2 15 3 20 I want to display as Contractor Circle ...