Outlook 2003 Arrange By Bug? #2
We have noticed on machines running Outlook 2003 that when you have a
particular e-mail selected and you click on the column heading "From", that
instead of sorting by "From" and starting the list on the first message from
this sender, the list is sorted by "From" and the top of the list is shown.
In other words, it does not position the display as it did in Outlook 2k to
the first message from the selected sender. This behavior is not consistent
however. It appears that it works the first time you try it, but subsequent
attempts don't. If you switch out of...How to filter a spread sheet ?
From my financial package periodically Excell sheets are generated with lot of financial
information. Unfortanely I cant make a selection from that package, so it generates all the
information available. So, my idea was just to filter the spread sheet in order to get the
Therefore, on a second file I put a list of required relevant items, I want to extract from my
My question is, is there a simple way to do that ?
To make it more concrete, consider the following example:
Imagine the spreads...Junk E-Mail filter unavailable in online mode
We had Outlook 2003 clients on an Exch 2000 server, and, as expected, the
Junk E-Mail filter was not available when working in online mode. In cached
mode it was working fine. Now, after upgrading the organization and server
to Exch 2003, the Junk E-Mail filter is still not available in online mode.
According to all the MS documentation this should be working.
All of the documentation that I have know of says that it works on in Cache Mode. Can you give us a link to the documentation that you saw that shows it will work with online profiles?
Matth...Junkmail filtering outlook 2000
Is there a way to add "key words" to the junk mail filter
to eliminate additional junk emails? Is there a download
which updates the initial list of junkmail words.
On the next junk mail you receive go to tools and Junk Mail filter and add
"Andy" <email@example.com> wrote in message
> Is there a way to add "key words" to the junk mail filter
> to eliminate additional junk emails? Is there a download
> which updates the initial list of junkmail words.
This does not work because...help for filtering email needed
please excuse my bad english first.
Our Problem: since weeks we receive email from adresses all over the web -
especially from accounts at yahoo, hotmail etc. from peaople who wanted to
sell us viagra and other stuff not needed within ou office. Due to the fact,
that they wrote viagar lie v*i*a*g*r*a a filter in the clients outlook
cannot match. I tried to setup the filterlist within the exchange admin
console and entered adresse like '*@yahoo.com' and so on, to reject mail
from these adresses. Nevertheless this does not work. We still receive mail
from these senders. What did ...Workflow PostURL error/bug
Is there a way to set the timeout for a PostURL workflow step. We have
noticed that if the PostURL takes more than 8-10 seconds to complete, then
the workflow step becomes paused in the workflow monitor.
We have created the following simple web service that can be used to
reproduce the problem. Create a new web service or ASP page and paste the
following function to reproduce the problem. your times may vary, but when
we pause for 10 seconds then the workflow step becomes paused in the
<WebMethod()> Public Function SendEmail(ByVal accountid As String) As
Try...ndislwf (NDIS 6.0 Sample Filter Driver) to monitor native wifi adapter
I have built sample Filter Driver (ndislwf) from WDK and trying to install it with INF settings
HKR, Ndi,FilterClass,, Custom
HKR, Ndi\Interfaces, FilterMediaTypes,,"wlan"
HKR, Ndi,FilterRunType, 0x00010001, 1 ;
In above INF settings FilterClass is specified as "custom", bcoz it'll have the lowest position in the stack. I've also modified FilterAttach to accept bindings with only native-WiFi adapters. With above set...Refresh on Open
Can i get a worksheet to refresh after a set amount of time or as i
opens. or both
i have also posted this on
'also posted here
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
used this link to complete
~~ Message posted from http://www.ExcelTip.com
~~View and pos...Advanced Filter Causes Crash
When I try to use an advanced filter on a fairly large list (500+ rows)
I get the error message: "EXCEL.exe has genereated problems and will b
closed by Windows." I've noticed that the list actually does ge
filtered successfully, but excel always crashes immediately after.
I have around 100 rows of criteria. ( I have a list of about 70
account numbers in one coloumn and their corresponding GL codes in th
next column, and I'm trying to filter only the numbers that I'm payin
in a given period (the 100 rows of criteria).
I'm running excel 2000 on win 2000. This is ...Where is the bug in my array?
I've created an array of grade values:
The problem is that when use LOOKUP to look for "C-", I get 2.7 (which is
the value for B-) when I should get 1.7. (I.e., LOOKUP("C-", Array) returns
2.7, where Array is the array above.)
Here is the same array, formatted in rows (all I did was copy and paste it
into Notepad and add spaces):
...Printing only filtered data in a form
I'm of new to Access 2007. I have created a form and a report. Is it
possible to have the user use the built in filter Access provides and click
the report button and print only that data. Each time I open the form
different data will need to be selected by the user.
For a simple filter, you can just use the form's Filter string as the
WhereCondition for OpenReport.
This example assumes a command button named cmdPreview, that is to open
Report1 filtered the same way as the form:
Private Sub cmdPreview_Click()
Dim strWhere As String
If Me.Dirty The...Bug part of rounding issues?
Paste any of the following into a cell and the last digit gets changed to a
zero. This is screwing up our call detail records that contain international
numbers dialed by customers.
If I format the cell as text, Excel changes the contents to 9.01139E+15 no
matter how wide the column is.
Is ther any way to make Excel just display the numbers as entered?
Not a bug - see "Specifications" in XL Help: XL only retains 15 ...Filtering on multiple columns
I have similar data in multiple columns and I want to filter on all
columsn togather to get unique values. Is there a good way to do so.
wammer's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=12452
View this thread: http://www.excelforum.com/showthread.php?threadid=399224
I'd create a new worksheet and copy all the data into one column. Then I'd use
data|filter|Advanced filter to extract just the unique records.
Debra Dalgleish explains the data|filter|advanced filt...Dynamic filters on a report
What I am trying to acieve is an on-screen report with user-selectable
filters. The app is a detention-logging system for a school. What I want to
be able to do is to see a summary of all of the detentions for the school,
but allow the user to filter this down to either a particular year group or
even a particular tutor group. I also want them to be able to alter the
date-range for the report.
What I'd ideally like to do is to have a form do this, but forms don't seem
to support grouping of data and I can't have a sub-form on a continuous form.
I have two (current) pro...Filtering all incoming mail for a particular sender or senders.
I work in a bank, we have had several people with non-compete agreements
leave recently and they appear to be violating their non-compete agreements,
contacting existing employees to try and hire them.
I would like to setup a filter in Exchange so that when an e-mail comes in
from 'firstname.lastname@example.org' comes in, it gets routed to a different
internal e-mail box, and is never delivered to the intended recipient.
Is this possible to setup somewhere in Exchange 2003?
You can't selectively route inbound email from particular address(es) to a
particular internal recipient ...misc data filter
Item Activity Time
ABC IN 100
DEF OUT 110
ABC OUT 120
DEF IN 130
IN & OUT are pairs, if one item is IN, it must be OUT.
I am looking for a way to find items which are IN but no OUT. In this
example data, "DEF" was OUT and IN again, then I need to locate that DEF.
For a case of "ABC", it is already out, then I am not interested.
I have tried this with pivot table but in vain.
I would appreciate much if somebody can find a solution for this.
With your table in A:C starting in row 1, enter this array formula in...Is it possible to change the blue colour of an activated Auto Filter button?
When Auto Filtering is on and one of the filters is active, the button's
colour is changed to blue. Often, I find it difficult to distinct this blue
colour with the black colour of an inactive filter.
Can the colour of this blue Auto Filter button be changed?
Message posted via http://www.officekb.com
AFAIK, no one has found a way to change the autofilter arrow colour.
If you can use programming, there's a sample file that uses a User
Defined Function and conditional formatting to colour the heading cells:
under the heading '...need query to filter combobox row source list by table records
I hope my subject line made sense. I'd like to specify a list for the
rowsource of a combobox, but I want the list to omit items that have already
been used in a the underlying table.
The values ID phone numbers, and are "Home", "Work 1", "Work 2", "Fax",
"Mobile", and Pager". The underlying table has a record for each existing
number with the person's ID code, the label, and the phone number. When new
numbers are added, the user gets one of the listed labels from a combobox. I
want it to display only o...Outlopk do not refresh(2) ?
My situation is Server 2003, Exchange 2003, Windows 2000 Pro, Office 2000.
All patches are current. Most machines are identical. All machines with XP
Pro will show that you have e-mail immeadiatly, BUT Windows 2000 Pro will not
show new e-mail unless you click on another folder, or on "Jog" outlook. I
know exchange is getting the messages and making them available because I see
them come in via the web access. This is a client problem, as a user can go
to a different machine, and not have a problem. It's like Outlook is
sleeping, and we do not have it set in cach ...Adding Filtering to a Rating Equation?
I am using the following formula to determine the individual rating of a
group of players running a race.
A B C D E F G H
2 ID. No. Time #1 Time #2 Time #3 Average Time Rating Gender Level
3 6 01:01.1 02:59.6 01:59.9 02:00.2 5 Male U14
4 5 03:00.0 01:01.1 02:24.7 02:08.6 5 Male U14
5 16 03:02.8 02:47.7 01:01.1 02:17.2 5 Male U14
6 4 02:24.7 01:59.9 02:32.6 02:19.1 5 Male U14
7 17 02:25.2 02:11.3 02:47.4 02:28.0 4 Male U14
8 19 02:15.6 02:21.2 02:47.7 02:28.2 4 Male U14
9 11 01:59.9 02:25.8 03:01.9 ...Data Refresh Speed
I have a spreadsheet that extracts data from Sharepoint and then performs
multiple calculations on that data. When I refresh the data, it then also
recalculates every formula and this is starting to take a long time due to
the sheer number of calculations that are being performed.
I'm wondering if there is anything I can do to speed up the processing, like
multi-threading or something? Any settings or options I can change to make
See my website
and white paper
_________...F9 Calc refresh does not work...
I have a spreadsheet which has some formulas which do not refresh properly.
They are simple "IF" formulas.
If I press F9 or Options / Calculate Now, they do not refresh.
They only way I can get them to work is F2 when I'm on the cell (revealing
the formula in the Formula Line) and when it closes it refreshes.
I have this formula in other sheets in the same spreadsheet but I don't have
Thanks (and happy new year to all!)
<They are simple "IF" formulas>
Why not show the formulas?
Sometimes it helps to rebu...SPAM FILTER
Can anyone recommended a spam filtering product to use on Exhchange 5.5? We
send and receive via a SMTP ISP.
We use Appriver.com. Excellent service. They block spam and virus's. Free
30 trial will sell itself.
[You can observe a lot by just watching]
"Pete C" <email@example.com> wrote in message
> Can anyone recommended a spam filtering product to use on Exhchange 5.5?
> send and receive via a SMTP ISP.
We use Hexamail Guard from Hex...Filter Problem after Upsizing DB to SQL 2000
We have an Access 2000 application which we recently
upsized to use SQL Server ... Everything seems fine
except when we try to use the "Apply Filter Using
Selection" button on a DATE field ... Doing so results in
no filter being applied on most computers (we do have one
that works correctly and the only difference we can find
is that the one that works is running WindowsXP Pro,
while all the rest are running Windows2000 Pro) ...
Anyone have any ideas or suggestions?
...refresh static text overwriting old values -- Graphical problem
Please... I really need help with this problem. I have been stuck on this
for a long time and my software deadline is almost here.
I have a tiled bitmap as a background on my app. Problem is when I update
static text over top of it, the text will just sit there and overwrite itself
over and over again until it is unreadable. It will refresh if I use an
Invalidate(TRUE) but I have to do it every second and the window will flicker
The text is transparent so I can see the bitmap from behind show through.
I have tried everything I know to make it work correctly. Does anyone know...