IF Function #3
thanks Domenic that works a treat
sgrech's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1450
View this thread: http://www.excelforum.com/showthread.php?threadid=27163
...3 email accounts, 3 folders
Office 2003, Windows X
I have 3 email accounts with Earthlink. I have created 3 folders in Outlook. I want mail from each account to go into the appropriate folder Inbox
In Outlook/email accounts I select each account name and find the matching name in "deliver email to the following location", and click Finish. But next time I check, all accounts have switched to the last folder I entered
Either it's not possible to do what I want to do, or I have done something wrong in the setup. I would appreciate any guidance towards my intent to keep mail from each account seperate from ...Scrolling problem #3
I have one ListCtrl and one listbox. when i scroll listctrl i want to
scroll listbox also.
using this code It is working fine. But my problem is, when i scroll it
using mouse scroll button listctrl is scrolling but no change in
You need to handle the WM_MOUSEWHEEL message.
BOOL CScrollingList::OnMouseWheel(UINT nFlags, short zDelta, CPoint pt)
return CListCtr...Queue #3
I am having a problem with Exchange 2000. My queue is filling up and U don't
seem to have any problems (that I can see). All of the e-mails are
legitimate e-mails, I do not have an open relay. Some e-mail goes out while
others do not. I am running Exchange 2000 on Windows 2000. This just
When I delete e-mail out of the quest I get a NDR that says:
This message was rejected due to the current administrative policy by the
Enable logging on the server and check application log for more info.
What queues are building up? Local, Routin...Obtaining Post-Office 2000 Service Pack 3 (SP-3) hotfix AKA Outlook 2000 Hangs after opening 20003
I have a number of users using both Outlook 2003 and Outlook 2000 on our
Exchange 2000 server.. Many of them are now having hang problems when
exiting Outlook 2000. I am pretty sure this post hot-fix MS describes will
fix the problem but I don't know how to DL it. We are MSDN susbscribers.
Call 1-800-936-4900 (press 3 for hotfixes) and tell them you're calling to
obtain the hotfix described in KB [number] and they should fix you right up.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneN...copying messages #3
I was wondering on a way to back up my Outlook Express
messages, because i am planning on formatting, any way i
could do this by copying them from a certain or
something, email me. or relply thx
...Deleting Cell with formulas with Numbers Ex. =2+3 not = A+B
Deleting Cell with formulas with Numbers Ex. =2+3 not = A+B
I am trying to create a copy of workbook with only formulas, but some cells
=2+3 which I do Not wanted. How can I delete all of this in a single click
If you wish to delete *all* numeric formulas,
Try this on a copy of your sheet:
<F5> and click on "Special".
Then click on "Formulas", and make sure that
"numbers" is checked.
You will see that cells containing numeric formulas are selected.
Now, just hit <Delete>.
-- ...FRx #3
Thanks in advance for any info.
When launching a report via FRx, a user is receiving an error "no catalogs
exist". Any ideas? Couldn't find anything on customer source.
User restarted, now it's working. Whats up with that???
"Morgan" <email@example.com> wrote in message
> Thanks in advance for any info.
> When launching a report via FRx, a user is receiving an error "no catalogs
> exist". Any ideas? Couldn't find anything on customer source.
> Tha...Link to last entry #3
Thanks for clearing that up. I pasted it from the Google link and i
works fine now. Just a tip if anyone else reads this - when I paste
it in, it didn't seem to want to be entered as an array formula, so
just deleted one of the brackets and replaced it, then pressed ctr
-shift-enter and it worked.
> Believe the site/place where you're posting to or reading posts from
> unfortunately removes all the "greater than", "less than" or "not equa
> symbols from posts, including from within formulas, that's the t...Linest
I am having difficulty with the order of the coefficients outputed by linest
when doing a multivariable regression. My problem is that the order is
reversed from the input x variables. While for displaying the coefficients I
do not have a problem, the problem is that my sheet is setup so that the
column order is x1,x2,x3,x4... and I would like to use
mmult(inputs,transpose(output coefficient)) or Sum(inputs*ouput
coefficients) ) to fill in dataspace in other operations.
Any suggestions on a way reverse the order so that I can use it with matrix
operations without creating new columns...Licensing #3
Operating System: Mac OS X 10.6 (Snow Leopard)
How many computers can I use my Office 2008 Home and Student Edition on? Will the one disk spread on two or three?
Read the license agreement that was attached to your purchase. On the
version I bought it allowed me to install on 3 machines.
> Version: 2008
> Operating System: Mac OS X 10.6 (Snow Leopard)
> Processor: Intel
> How many computers can I use my Office 2008 Home and Student Edition on? Will the one disk spread on ...owa redirect #3
redirect.asp is not working on windows and exchan ge 2003. When set up by
the book I get this error -
"Secure Channel Required
This Virtual Directory requires a browser that supports the configured
If i surf to /owaasp/redirect.asp it works fine.
This was working before i started to set up forms access then it quit
working. Not sure if it's a permissions thing or not. Don't know where that
exact error is comming from either. It's not a 403.4 error. If i return the
custom error to it's original location I get the full full error 403....OE Attachments #3
My OE seems to repeatedly screen out attachments from my
email messages. I don't seem to know why or how this is
happening. Does anyone have any ideas?
firstname.lastname@example.org <email@example.com> wrote:
> My OE seems to repeatedly screen out attachments from my
> email messages. I don't seem to know why or how this is
> happening. Does anyone have any ideas?
Ask in an Outlook Express newsgroup. (Hint: Tools>Options>Security)
...Installing Service Pack 3 on top if IE7
After doing all the critical updates I'm ready to install SP3. I've already
installed IE7, and I know that if I install SP3 on top of IE7, IE7 will
become non-removable. Since IE6 is obsolete and IE7 seems to work OK, is
there any good reason to uninstall IE7, install SP3 and then reinstall IE7?
That is, is there any reason SP3 should be installed befoe IE7 other than
the latter's non-removability?
IE8 has been out for awhile and it is better than 6 or 7
Do SP3 and then IE8
If you find a posting or message from me offensive,inappro...Copying data #3
I need help in copying data.
I have data exported from a text file and has somthing
like following format -
Main Grp: 600
Sub Grp: 11890
grp desc amount
7878 ABCDEMF 89887
Main Grp: 600
Sub Grp: 11900
grp desc amount
7900 ABCDEMF 56844
so need to copy 'grp' below alongwith the lines of data
within the group and 'sub grp' also alongside the data..
may be on right side after amount.
I tried with Edit/Go to.. and spe...Address Book Access #3
I recently downloaded an update for my MS Office Pro from
the MS website. Directly afterwards and ever since,
whenever a piece of spam slips through into my Inbox and I
add it to the list of spam (using Norton) I get the
"A program is trying to access addresses you have stored
in Outlook. Do you want to allow this?" "If this is
unexpected you should click on NO".
I keep clicking on NO for each piece of spam but it keeps
on happening for every piece of spam I get. How can I
determine whether it is MS (or not) who is trying to
access my mailbox?
In...Internet email #3
How is the best way to authorize some users to receive internet email?!
I have only five users (on 1000) that must have to receive internet email...
I don't want to use recipient policy...is possible?
"MMC" <firstname.lastname@example.org> wrote in
> How is the best way to authorize some users to receive internet
> email?! I have only five users (on 1000) that must have to receive
> internet email... I don't want to use recipient policy...is possible?
...Data Consolidation #3
I hope someone can help me. I have a list of about 30k PCs for a
Enterprise Dollar estimate thing. I need to find out how much money
each Business Unit has in PCs. I have a list of PCs, Cost Center, and
Device Type, but like I said I have about 30k of them. I need to find
out how I can tell Excel to look for how many instances of each there
are per Cost Center. Any ideas?
Make a Pivot Table. Drag the Cost Center into the left or top. Double-click the heading
and set it for count. Drag it again into the data area. This is a bit different in earlier...SQL Replication with CRM 3.0?
Is SQL Server replication supported with CRM 3.0? If so, is there a
whitepaper on how to set this up?
yes it is supported.
"Ted" <Ted@discussions.microsoft.com> wrote in message
> Is SQL Server replication supported with CRM 3.0? If so, is there a
> whitepaper on how to set this up?
Thanks Benjamin. Do you know of any whitepapers specific to CRM on setting
"Benjamin Fallar III" wrote:
> yes it is supported.
> "Ted" <Ted@discussions.microsoft.com> wrote i...Windows Vista Update hanging on 3 of 3
I'm installing automatic Windows Vista update and it's restarted the laptop
and has been stuck on "Configuring updates: Stage 3 of 3 - 0% complete" for
2.5 hours plus any ideas?
> I'm installing automatic Windows Vista update and it's restarted
> the laptop and has been stuck on "Configuring updates: Stage 3 of 3
> - 0% complete" for
> 2.5 hours plus any ideas?
Wait a little longer...
Force a shutdown.
How To Ask Questions The Smart Way
http://www.catb.org/~...CRM 3 Implementation Guide
I am currently "renting" a hosted Exchange/CRM 3 solution with a service
provider. Therefore, I was not given an implementation guide. Does anyone
know where I can get an implementation guide from? Thanks!
"iamdavid" <email@example.com> wrote in message
>I am currently "renting" a hosted Exchange/CRM 3 solution with a service
> provider. Therefore, I was not giv...Need help with Outlook 2000 #3
I just started trying to use this program and find it difficult and
frustrating. Is there a simple, online tutorial (preferably free) that
I have 9 columns of data that represent candidate 'x' values along
with a column of data that represents the 'y' values.
Without having to create multiple rearrangements of this data, I would
like to determine the output of the linest function for various
=linest (included X columns, Y column, 0, true)
each cell that includes this function should have a different unique
permutation of each of the 9 potential candidates
Scenario 1: column A,B,D,E,F,G,H,I; column L, 0, true
Scenario 2: column A,B,C,E,F,G,H,I; column L, 0, true
Scenario 3: column A,C,D,E,F,G,H...B & C Eagle 238X099RC 2-3/8-Inch by .099-Inch by 15 Degree Ring Shank Wire Collated Coil Framing Nail (3,000 per Box)
Best deal: http://specialdealfinder.info/index.php?id=B0000225FO
These nails work fine in my Makita coil nailer- the problem is that when they arrive they are smashed flat by the poor packing and/or careless handling.
REALLY LIKE THE NAILS. JUST DIDN'''T CARE FOR THE WAY I RECIEVED THEM. SORTA BENT IN THE BOX AND HAD TO STRAIGHTEN THE COILS.
B & C Eagle, 3,000 Count, 2-3/8" x .099, Ring Shank, Coil Framing Nails, Fit The Following Nail Guns: Hitachi NV83A, NV83A2, Bostitch N80C, N80CB, N86C, N...Unspecified errors after upgrading to 3.0
Upgraded from 1.2 to 3 on 2003 SP1 SQL 2005 when I try to create an
Invoice off an order I get Server Error in App Unspecified Error
Same set up for Unable to save opportunity ComException 0x80040217
Any Help would be appreciated.