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 ...Using fields within string functions?
First, let me explain what I am trying to do.
I have a field, a1:a1000, of email address usernames (e.g. the par
before the "@" symbol). I have another field, b1:b100, which is lis
of profanities, racial slurs, and all other kinds of bad words. What
need to do is flag each username that contains any of the bad words.
The flags can be placed in column C or whatever.
The SEARCH function works great if I'm only comparing two cells. But
I need to compare one cell with a field of cells.
COUNTIF will compare one cell to a field of cells, but it has to be a
exact match. It will ...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 ...Array to String
I am trying to capture a single field from multiple rows and concantenate
them into a delimited string.
Dim dbs As dao.Database
Dim rst As dao.Recordset
Dim varArray As Variant
Set rst = CurrentDb.OpenRecordset("SELECT * FROM tblPhotoNames ORDER BY
varArray = rstRSet.GetRows(10000)
'I would like to write this array to a delimited string.
Set rst = Nothing
Set dbs = Nothing
On 01.04.2010 15:35, vek wrote:
> I am trying to capture a single field from multiple rows and concantenate
> them in...Propercase, strings and arrays
I need to write some script that allows me to evaluate a cell values first 2
characters for "MC". If found Uppercase the 3rd Character. This way I can use
it and adapt it for any naming anomoly.
eg "MCCARTHY" - "McCarthy"
My thoughts were to put each character of the value and evaluate the first
character then the second. When a match is found re-write the value out of
the array in the correct casing format.
try this instead
if ucase(Range("A1")) = "MCCARTHY" then
Range("A1") ...Is there any limit for the size of std:string???
Hi, I made some code that compresses video data. And It lookes OK if I
compress data very much (few bytes) and not so well if data is not
compressed at all (many bytes). I have there a lot of variables but I
think there is something about std:string. Is there any limit for the
size of std:string???
Your question vary vague, but the answer to the question "Is there any limit
for the size of std:string?" is (as far as I know) computer memory.
My concern is that std:string is not a very good medium for holding video
data, since a 0 will terminate the string! And I am pretty sure th...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" <email@example.com> skrev i melding
news:%231uFO3IcHHA.4720@TK2MSFTNGP0...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...Transform XML string using XSL file (v1.1)
Having fits transforming an XML string using an XSL file. In the 1.1
version of the framework, I see that the XmlResolver is heavily used
in the XslTransform class. However, that looks like I am only
supposed to use that only when you have an xml ~file~... not an XML
string (my XML is coming from a database field).
Is there a cut & dry example out there on how to transform a simple
XML string using XSL?
I believe that you can use Nothing for the XMLResolver parameter in VB.Net
or null in C# if you so choose, thereby not enforcing the Security
ms-help://MS.MSDNQTR.20...Custom customer fields- Increse the size of the integer field
Hey- HOw come the number fields in the customer fields only go up to 10
integers??? Is there a way to increase the integer field for the numbers?
Let go, Elevate your life
...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...? Define Constant Name Strings to Integer Values
I'm looking for a way to convert a defined constant from its name to its value.
For example I need a way to take the input string "VK_ESCAPE" and derive its
integer value 0x1b.
Most scripting languages do this through the eval function, but I cannot figure
out a way to accomplish this with VC++.
(I'm writing a dialog app, and I need a way to allow the user to pass key names
on the command line without reinventing an entire key-map.)
Any ideas? Thanks.
There may be a trickier way, but I would just build a switch statement...String tables...
I have lots of #define values used in my project. I have
put them all in a separate file called definitions.h and
this file is available for all the files in the project.
Can I remove this file and and use the string table
instead? Pls advise.
If I understand the question, then yes. In fact, the recommended way would
be to create a string table resource for your application. You then use
LoadString to load one of the strings.
"Shirley" <email@example.com> wrote in message
ne...VB Assigning Values to a Series of Strings
In the VB Editor, I need to assign each letter of a 13 character string
(named JobScope) to individual Variables (K1 through K13). I'm using a
For/Next Loop to extract the indiv characters but cannot figure out how to
define the Variable K(x) where x = 1 to 13. Any suggestions?
Try making K an array with 14 elements (VBA numbers the first element as 0)
Then you can use the method you're trying at the moment.
For X = 1 To 13
K(X) = etc.
The only other change you'll have to make is how you address the variables
elsewhere. E.g, K5 w...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 change the record an email has been associated (Tracked)
Is there a way to change the Case record (or any for that matter) an email
that has been Tracked to in error to another case? I thought I succesffuly
deleted the email from the Case record and then inside Outlook opened the
same email and then click the REGARDING Button to track it to the correct
Case Record, but now I can no longer seem to do this. The regarding button
still show the name of the incorrect case and when i open the case, the email
is no longer part of the history of the case. When I click VIEW IN CRM in the
email, I get an error.
You can select the email from the main O...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...Replace null string with blank cell
I have a large table which was created via lookups from other tables.
Many of the entries are (or should be) blank. After the table was
created, I converted everything to values (Paste Special/Values) in
order to save memory. However, the table now contains a null string or
other unprintable character in each of the "blank" cells. Thus, if I
use END-DN or END-UP to find the next value in the table, the cursor
goes to the end of the table, as it sees something in each cell. If I
edit a "Blank" cell, I see no characters, and if I select the formula
bar & hit ENTER, ...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...How to find a string in a binary file?
I have a binary file and I want to search for a certain string, for
example "READ_FROM_HERE". After finding this I want to read on from this
Is there a way to find it?
thanks in advance
Open the file in binary. Read it until you see the string. Remember, however, that if you
have buffer boundaries you would have to deal with the situation READ_FRO|M_HERE where |
is a buffer boundary. A simpler method is to use a memory-mapped file, and so something
like strstr. Either it finds the string or it fails because of a NUL being found, so you
advance past t...Imports contacts associated with accounts
I have just imported a list of account in CRM (using the crm's import). I
would like to now import the contacts associated on these accounts. Out I
bind them well with "customer relative" by specifying well the type of
entity relationship (accounts) but the manager of importation returns me
only failures and no contact is created with the final one.
How can I import contacts who can be associated with the accounts I have
created before ?
Thank you for your assistance ans sorry for my bad english...
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...how to permanently associate category (Money 2002)
Is there any way to permanently assign a category to a
particular payee? I.E. a grocery store that appears
several times in my account that I don't want to have to
assign the category every time.
Not really, but setting up recurring payments in Bills and Deposits sort of
MVP for Microsoft Exchange Server
"boulderoo" <email@example.com> wrote in message
> Is there any way to permanently assign a category to a
> particular payee? I.E. a g...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...