determine mail flow problem!!!!!!!!
Our mailflow from 2 backend 2003 exchange servers keeps queuing up in the
outbound queue (which is set to always run delivery). Messages stay in there
from 10 to 120 minutes before being sent to our gateway MTA and then sent
off site (to hotmail.com for example). However when I telnet from a backend
server to the gateway over port 25 and send a test message it goes right
I can't for the life of me figure out why.
One example when viewed in message tracking history says:
10:16am - smtp: store driver, message submitted from store
10:16am - smtp: message submitted to ...Exchange Rate on Bank Transfer
Is there a way to modify the exchange rate on a bank transfer in the bank
transfer screen? It seems I have to enter the Exchange Rate tables and modify
the system wide exchange rate. What if the exchange rate for one transaction
is different from that of another (since I have multiple bank accounts)?
You can always change the exchange rate on the foreign currency checkbook
whether you are transferring from or to it. If the exchange rate does not
exist for the date of the transaction, the system will prompt you for a valid
exchange rate depending on whether your exchange rates ar...Update online prices and exchange rates
I have Money 2001 OEM Version 9
About four months ago I started getting error messages for downloads of
stock exchange indices for Sydney, London and Hong Kong. Eg "Money was
unable to retrieve an online price for All Ordinaries (Sydney). The symbol
$US:SYDI is not recognised."
Money allows me to select stock exchange indices but I cannot find how to
change the symbol. Any Suggestions?
These stopped working for 2001 versions in May i think. Microsoft made
changes to the MSN Money site, and they didn't check versions as far back as
2001, which appeared to break these ty...Determine columns used
I have 100+ spreadsheets which i have to edit into a certain format. The
spreadsheets currently have 100 columns (from 1-100). From there i have to
reduce the number of columns set to 8 columns.
1 2 3 4 5 6 7 8
0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 (from column 9 onwards, it
goes to the
0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 next rows' column 1)
0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
How do i do that without altering the order of the value of the cell?
Let me make sure we understand the question.
You have ...Dynamically determining when a month ends
Ok, I have a simple excel spreadsheet, where I keep track of my
spending on one tab, my income in another and my summary in a thrid.
My problem happens when I try to dynamically calc. avg's for months in
the summary page. For instance, if I want to see how much money I
spent on average per month, or even per day, I draw from the data
entered into the spending page.
Now, the spending page is set up with the following columns:
Date:: Description:: Amount
The problem with this is that I can't predefine a max row # for each
month, since I might have 80 entries in spending...how to determine the size of the sheet
I had a collegue who told me once a way to dtermine the number of the rows
in a sheet of the workbook I am working at.
It is known that when you open a new workbook each sheet has maybe 65365 or
something like that rows.
MY QUESTION IS: HOW TO MAKE THE SHEET 1000 ROWS OR WHATEVER NUMBERS OF
ROWS I ONLY NEED?
Thanks in Advance,
The number of rows and columns are fixed. Your workaround would be to hide
the ones you consider unneeded.
HTH. Best wishes Harald
"Ahmed SHEBL" <firstname.lastname@example.org> skrev i melding
news:%231uFO3IcHHA.4720@TK2MSFTNGP0...APR intrest rates
anybody know any formulas for working out the monthy interest rate you would
get from an APR and any other bank rate systems?
...How do I determine
I have X number of rows that show employee names and a column (A2)
that lists the value of products sold by each employee and I want to
pay them a percentage based upon value of sales. For example:
If they sell up to =A31,000 worth of products, I will pay them 3% of the
Between =A31,000 & =A32,000, I will pay them 5% of the value
Over =A32,000, I will pay them 10% of the value
The amount paid to them in commission will be show in column (A3).
"Hastey" <email@example.com> wrote in message
news:6a0a4fa9-adcd-484a-80...How do you determine if you have access to remote files
I'm trying to scan a list of servers for a specific file (say for example
\\<servername>\C$\MyApp\Test.ini\which may exist on some servers but not on
others. In addition, I may not have have access to all servers that I'm
When using any commands in Powershell (1.0) that attempt to get the file
(such as Get-Item) PowerShell returns the same "Cannot find path '<filename>'
because it does not exist.)" error message in the following two scenarions:
1. I have access to the remote filesystem and the file does not exist
(expected beha...projected sales forecast broken down into an hourly rate not linea
I'm trying to make a spreadsheet program that allowes me to predict
projected sales per hour when given a projected total for the day, but I
idea of how to make a spreadsheet like that. In addition to this I would like
to add a column that will allow me to write in the acutual sales per hour so
as to decide whether or not I should call more people in or send people
home. As noted above I do not want to make it as a linear equation but rather
use something to get an accurate gage for sales per hour based on peak hours
...Determining A Rating
Suppose I have the following table:
A B C
1 3 <3.80
2 3- 3.80 3.99
3 4+ 4.00 4.19
4 4 4.20 4.79
5 4- 4.80 4.99
6 5+ 5.00 5.19
7 5 5.20 5.79
8 5- 5.80 5.99
9 6+ 6.00 6.19
10 6 6.20 6.79
11 6- 6.80 6.99
12 7 7.50 7.99
13 8 8.50 8.99
Where A is a rating/score
B is the low value range
C is the high value range
If I have a value in A15 of 4.91 (which is in the range of 4.80 and
4.99), I would like to return a rating in A16 of 4-. I've tried using
a series of IF statements, ...How do I determine the size of an excel worksheet?
How do I determine the size of an individual worksheet in an Office Excel
2003 file? The Properties featue only tells me the size of the whole file.
not directly supported by Excel. One workaround: Export this sheet to a
separate workbook (with only this sheet) and measure its size
"rajivsahib" <firstname.lastname@example.org> schrieb im
> How do I determine the size of an individual worksheet in an Office
> 2003 file? The Properties featue o...Display SCL rating
Is it possible to display SCL rating in OWA and/or Outlook2k/2k3 ?
On Thu, 8 Dec 2005 17:55:37 +1100, "Steven Wong"
>Is it possible to display SCL rating in OWA and/or Outlook2k/2k3 ?
More of an application thing. The rating is in the headers so you
could get it out. It's not an Exchange question because Exchange does
already display it, it's just Outlook chooses not to display it. You
might like to do some checking on the public featureset of the new
version of Office and yo...Determine if a sheet is protected?
How can I determine if a sheet is protected or not?
"Robert Crandal" <email@example.com> wrote in message
> How can I determine if a sheet is protected or not?
> thank u
MsgBox ActiveSheet.ProtectionMode 'returns true or false
Gord Dibben MS Excel MVP
On Mon, 18 Jan 2010 16:28:18 -0700, "Robert Crandal" <firstname.lastname@example.org>
>How can I determine if a sheet is protected o...Determining OS?
Is there a method to determine the operating system (98, XP, ME, etc)
that a program is running under?
>Is there a method to determine the operating system (98, XP, ME, etc)
>that a program is running under?
See the GetVersionEx API.
MVP VC++ FAQ: http://www.mvps.org/vcfaq
David Lowndes wrote:
>>Is there a method to determine the operating system (98, XP, ME, etc)
>>that a program is running under?
> See the GetVersionEx API.
email s/n...Other field Determination
Imagine this situation...there are:
Pets (tblPets, child records of tblOwners)
Medicines (tblMeds, child records of tblPets)
Owners can have multiple pets.
Pets have multiple medicines. Easy so far.
Here's the tricky part. The Pets can be of different species (cat,
dog, bird, snake, etc). Depending on what the species is, I want to
determine the other data that needs to be stored for the pet. So
instead of just height, weight, age, as fields in the pet table, I
want to see number of whiskers, declawed? if its a cat...wingspan,
beaklength, feather color if its a bi...How to determine Resources for a ServiceAppointment?
I am creating a custom view to list resources for each serviceappointment.
Here is the basic query I have used that seems to produce the correct results:
JOIN ActivityParty ON (ServiceAppointment.ActivityId =
ActivityParty.ActivityId) AND (ActivityParty.PartyObjectTypeCode = 112)
JOIN systemuser ON (ActivityParty.OwningUser = systemuser.systemuserid)
WHERE (serviceappointment.StateCode <> 2)
My question is why ObjectTypeCode = 112. Isn't that for Incident, not for
ServiceAppointment? Can anyone clarify for me please?
...Determining a Date
I have a column which is title, Expected Completition Date. Therefore
multiple dates can be used. For example, July 1, July 17, August 31, August,
9, September 16, August 2, July 31, in that order. So for this project to be
completed, it would be on September 16. I want the total field at the bottom
to display the latest date of completion.
"Mark" <Mark@discussions.microsoft.com> wrote in message
>I have a column which is title, Expected Completition Date. Therefore
> multiple da...how to determine schemas for validation
I am trying to validate document parts of Office 2007 documents. The method
I have tried using is to sort through each XML file to see which namespaces are
used, load the corresponding schemas for those namespaces, then try to validate
the document against that schema set. When it gets to more complicated documents,
for example a Word document utilizing many features, several open office XML schemas
might be used. When I try to load them all into a XmlSchemaSet, it won't compile
because certain elements will have been declared more than once.
For example, if I load the following schemas ...IMFv2 SCL rating in the header
I have configured the following setting in order to see the SCL rating for
the blocked messages. Is there a way to have all messages that get
processed by IMF (not just the rejected ones) marked with a SCL rating
rating in the header?
Fairly certain you can't. However, there's a way to have them show up in
or in OWA
blog: www....Vista UAC/Privilege determination
I have two intercommunicating processes. Process A sets a hook into process B (for
purposes I can't talk about due to NDA issues). The problem I'm having is this:
if I run A as an ordinary user, it can't set a hook in B
if I run A as administrator, it can hook B, but when the hook runs in B, it can't
PostMessage back to A.
It appears that I have a situation where if A is an administrator, then B is running at a
privilege level lower than A but higher than an ordinary user. So while I can hook it, I
can't have it send back to me. But running as a limited user, I can...determine what program is used to view html link in outlook message
where do I set up the program that will be used to view links in html
Last I knew Outlook used the default browser on your system.
"Allan J. Behr" <email@example.com> wrote in message
> where do I set up the program that will be used to view links in html
> outlook messages?
...Help me determine what I whould buy.
I'm a DB programmer running Windows ME on my home system, while all my
customers are running Windows XP. I want to be able to take screen shots of
forms that I create. Latter I may want to produce DB diagrams, but that's
not important now. If I need to upgrade my system to XP, I will. What version
of Visio should I buy? I know how simple this is to someone knowing this
product, but I'm not there yet, sorry.
You need Visio Professional edition for Software and Database functionality.
The latest version is Visio 2003, which only runs on Windows 2000 or Windows
XP. If you de...How to determine the ranking positions?
Does anyone have any suggestions on how to determine the ranking positions?
There is a list of numbers under column A, I would like to determine the
ranking number starting from max to min.
Does anyone have any suggestions?
5 Rank (3) 3 should be returned under column B
4 Rank (4) 4 should be returned under column B
6 Rank (2) 2 should be returned under column B
8 Rank (1) 1 should be returned under column B
1. In cells A2 to A5 enter:-
2. Give the above a Range Name of:-
3. In cell B2 type:-
=RANK(A2,RankRange...data determines which table to use
I have a table that has the fields "Extension code" and "Description" and
I have a form where an "Extension code" is going to be entered following
(a) If the extension code is known it will be entered by the user and the
field "Description" is filled by the form
(b) If the extension code is unknown a 000 will be entered by the user and
the "Description" is filled by the user
My problem is that the "extension code" 000 has a relationship of
one-to-many while the rest of the extension codes are a one-to-...