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 ...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 ...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" <email@example.com> skrev i melding
news:%231uFO3IcHHA.4720@TK2MSFTNGP0...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 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" <firstname.lastname@example.org> 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...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" <email@example.com> schrieb im
> How do I determine the size of an individual worksheet in an Office
> 2003 file? The Properties featue o...Determine if a sheet is protected?
How can I determine if a sheet is protected or not?
"Robert Crandal" <firstname.lastname@example.org> 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" <email@example.com>
>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...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 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?
...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 ...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" <firstname.lastname@example.org> 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...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...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-...How do I determine if I have Exchange?
"Home users typically do not have an Exchange Server e-mail account; instead
they use a POP3 e-mail account with an Internet service provider (ISP) or use
a web-based e-mail service, such as MSN Hotmail. If you use a POP3 e-mail
account, your ISP can provide you with your specific account information.
People without Exchange Server accounts cannot use the features in Outlook
that require an Exchange Server."
The above message appears in the HELP file, but I still need help
determining if I do have an "Exchange Server"?
Did you purchase Exchange Server and ...Determine current cursor appearance
I use docmd.hourglass true/false throughout my code to provide some feedback
to the user when a process is running.
Occassionally, I have nested processes that do this, so before I set it to
false, I really need to check what its value was when it entered the
subroutine. In Excel, I can use application.cursor to determine the current
value of the cursor. Is there something similar in Access?
email address is invalid
Please reply to newsgroup only.
Dale Fye wrote:
> In Excel, I can use application.cursor to determine the current
> value of the cursor. Is th...Determining length of trend before significant retrace
In range of data I need to find jthe largest numerical movement in one
direction without (x) retrace. (x in this case being a specified whole
Please help with a formula or direct me to where I could find this
Using Excel 2007
For example: in range of numerical data, the largest directional integer
movement was 300 before the data moved 25 in reverse.
Example 2: The largest directional integer movement was 224 before
the data moved 30 in reverse.
Assuming you have a column of numerical integer data in column B,
In C2, enter
to calculate the magnitude ...Determine Updates
I'm taking over an existing Exchange environment, how do I determine what
updates have been applied.
Open the Exchange System Manager. Right-click the server in question
and choose "Properties".
The first tab should give you details on the current service pack which
is installed. As for hotfixes and rollup packages, I'm not exactly
you can find what hotfixes have been installed on a server by going to
"add/remove" programs...they should all be listed...
"shifty" <shifty_MyU@yahoo.com> wrote in message
news:1105566510.641295.1...CWinThread determining if a thread is still alive
I create a CWinThread object and have a pointer to it. I do the
AfxBeginThread and then a ResumeThread to get it going.
Is there way to determine, via the pointer to the thread (or otherwise),
whether the thread is still running at some later time?
The simplest method, perhaps, is to call::WaitForSingleObject(thread->m_hThread, 0); this
will return WAIT_OBJECT_0 if the thread is stopped and WAIT_TIMEOUT if it is not. Another
method is to GetExitCodeThread(thread->m_hThread, &exitcode); if exitcode == STILL_ACTIVE
then the thread is still active.
However, it is very important t...Event ID: 7519
Is somebody trying to hide their IP address? Do I need to worry about this?
Event ID: 7519
Category: SMTP Protocol
The originating IP address of message with ID <emailaddress> could not be
determined based on its Received headers.
On Wed, 1 Feb 2006 12:04:36 -0500, "Fritz" <email@example.com> wrote:
>Is somebody trying to hide their IP address? Do I need to worry about this?
>Event ID: 7519
>Category: SMTP Protocol
>The originating IP address of message with ID <emailaddress&g...