Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA)
Hello Excel Problem Gurus,
First of all, let me thank you in advance. I find it exemplary that
you all can devote time to helping others who are having issues with
their work. Hopefully one day I can be at a mentor level, and help
Hope you can help! I have an issue where I don't know how to write the
formula that I need without going over on the nesting. The current
formula that I have is as follows:
Data",IF(V7="Yes",&qu...Cannot download mail
I am having a problem downloading my mail - I keep on
getting the following error messages - please help
Task 'brilnet.co.za - Sending and Receiving' reported
error (0x800CCC0F) : 'The connection to the server was
interrupted. If this problem continues, contact your
server administrator or Internet service provider (ISP).'
Task 'Hotmail - Sending' reported error
(0x800CCCF0) : 'Unknown Error 0x800CCCF0'
Task 'Hotmail: Folder:Inbox Synchronizing headers.'
reported error (0x800CCCF0) : 'The service is currently
unavailable. Try again later....Office 2003 on WinXP is receiving an error...
This operating is not presently configured to run this application.' This
nmessage keeps popping up after I install WInXP Sp2. Right after I install
office 2003, and I try to open MS word 2003, the above message appears. Can
anyone point me in the right direction?
Insert office cd>repair
"RodneyJ" <u58446@uwe> wrote in message news:a43130535cd3e@uwe...
> This operating is not presently configured to run this application.' This
> nmessage keeps popping up after I install WInXP Sp2. Right after I
> office 2003, and I t...Killer macro idea for business mailings
One of you programmers should write a macro to validate a city from zip
code. I receive excel files from response cards and a lot of people will put
some random letters for their city instead of the actual city name, or maybe
they'll put the wrong abrieviation for their state. It would be awesome if
all the zipcodes could validate the state field and change if necessary and
the same for the city fields too.
Okay, have at it :)
Okay, well good idea I think anyways, but it turns out that my columns just
weren't wide enough so it didn't display more then 2 letters.
...send the same e-mail with one or two fields changed.......
I would like to send the same e-mail to many differnet people with
one or two fields changed (for example the name of recipient and the
date).How canthis be done?? I would also like to be able to save the
e-mail and use it again and again.
can anyone help
If you have Word installed and it's the same version as Outlook (both 2003,
for example), you can do a mail merge between the two. This would allow you
to set up the text the way you want it to, and you can save the document for
future use. Look at the following page for further information:
http://www.slipstick.com/con...Accessing Windows Office Templates
There are some very nice templates at the Windows Office Template
Gallery. I would like to download (mostly Word, but a few Excel) some
of these templates, but the format comes out with a ".cab" extension
that Office v.X doesn't understand.
Is there any way to get these templates? Unfortunately, they make the
Mac template archive look very weak.
Microsoft has a Mac template download page:
There's a link to the on-line gallery on that page. It looks like a newly
re-designed gallery to m...Errors saving to network drive
When my users open an Excel spreadsheet located on a
network drive, make their changes, and then try to save
the spreadsheet, they get an error message saying "Your
changes could not be saved to Whateverfile.xls, but were
saved to XXXXXXXX ( 8 digit hex number ). Close the
existing document, then open the temporary document and
save it under a new name"
The users have been explicitly granted full rights,
including Delete and Modify, to the shared folder in
which the spreadsheet resides.
I have disabled their Symantec Antivirus realtime
protection for the time being.
This pr...Mysterious e-mails
i keep getting e-mails that look and appear that they have
come from people either in my phone book or in some cases
from people that have ligitimately e-mailed me or that I
In fact the e-mail has come from somewhere else even
though the sender appears to be ligitimate.
Most of these e-mails are dated 3 or four weeks old and
show that they have been read in my inbox.
I've asked a few people if they have forwarded the mail to
me but they havn't.
Most e-mails are selling Viagra or some other product.
??? any clue ???
Thanks in advance
You're being spammed. First...Cannot open Excel attachment from e-mail when Excel is already ope
This is driving me crazy. If I already have Excel open (with or with out a
spreadsheet open) I cannot open an Excel spreadsheet attached to an e-mail.
If I close Excel and retry it will open Excel and the spreadsheet.
Any ideas? I hate having to close all my open spreadsheets when I want to
open a spreadsheet that's been e-mailed to me!
One of these usually works with a similar problem starting workbooks by double
clicking them in Windows Explorer. Maybe one will work for you and your email
Tools|Options|General|Ignore other applications (uncheck it)
--- or ---
Close E...Memory Leak #10
I added to the main MFC dll class sterilization support.
In the InitInstance I added the following (and a corresponding code in the
It seems to work fine but I get memory leak on the program shutdown.
Can someone advise please?
CArchive archive(&theFile, CArchive::load, 4096);
Do you know what/where the memory leak is happening. There are some things
in MFC that just get allocated once and perhaps they just never clea...How to make Run Integration work in GP 10
Can anyone tell me how to make the Run Integration tool work in GP 10. We
just did our first client upgrade to GP 10 and the client has only 1
integration that they used to be able to run via the RUN INTEGRATION Tool.
Any help would be greatly appreciated.
I have the same probelm...did you get any answers to this?
I have to go into Integration Manager to run it b/c Tools>Run Integration
does nothing. I even checked the ini files to make sure the path is correct.
"Tammy Chavez" wrote:
> Can anyone tell me how to make the Run Integration tool work in...Mail will not Send/Receive automatically
I have outlook set up to send/receive every minute but it suddenly stopped
doing so. Anyone have ideas why?
Several. For starters, a one minute polling interval is just nuts.
It is difficult to determine why automatic polling is failing when you do
not post your mail account type, connection type and polling settings. If
automatic polling once worked and now fails, you also need to examine what
changes were made to your setup before automatic polling stopped working.
In general, here are the reasons automatic polling might fail in Outlook:
1. You have created an unrealistic po...Here is fix for Windows file problems
If you have installed a Windows update and started having problems opening,
closing, copying files, see:
A better solution is offered at
http://support.microsoft.com/kb/918165 "Problems in Windows
Explorer or the Windows shell after you install security update
Patricia Shannon wrote:
> If you have installed a Windows update and started having problems opening,
> closing, copying files, see:
> http://ww...Access 97 can't resize database window
My database window with the listings of forms tables etc was adjusted to a
smaller width, but resizing it is completely disabled and renders Access
2007 utterly useless for me. Is there anyway to 'reset' the window?
...About Exit and close window.
I have a dialogue base application. There's an Exit button in it. Eachtime
when exit the program by clicking Exit button, fun() and OnOK() executed,
but if the window is close by clicking (x) on the upper-right coner, fun()
will not be executed. How to make this function--fun()--executed when click
(x) button on the upper-right coner?
Rather than calling your fun() from the Exit event handler, call it from the
dialog closing event handler, so that no matter how it is shut down, that
method is called, and so is fun().
hope that helps.
"sxy7711" <sxy771...Outlook Mail via a PROXY SERVER?
If I am using a shared Internet service on a second computer using a PROXY
server on the host (first) computer. I can access the net using the PROXY
settings on the Internet explorer. However, how do I download mail with
OUTLOOK 2000? The proxy server is CCPROXY from YoungZSoft (this runs on XP)
and it has the MAIL Settings enabled but the difficulty is what to do on the
That would be determined by the proxy manufacturer - check with their
> If I am using a shared Internet service on a second computer ...Microsoft Outlook 03-11-10
I have just got a message saying not installed for the current user and it
will not load. But I've been using it for years.
> I have just got a message saying not installed for the current user and
> will not load. But I've been using it for years.
> GeorgeGeorge, welcome to the forum. When you post (here or in any forum), you
will get faster and less frustrating replies if you do a few standard
- try to define the problem in the thread title. Since this is an
Outlook forum, simply stating "Mic...Mail enabled public folders / spam
For each of my users inbox I have exchange mark mail with the SCL and move
anything over my threshold into their junk mail folder. This works pretty
well and eliminates nearly all of the spam we get.
I have not thus far managed to work out how to get this working for mail
enabled public folders. How can I set this up (perhaps nominating anotehr
folder as the 'junk mail' folder) or something similar?
...Using Company Wide Mail Templates.
I do not know if i am at the right spot here, or if it is evne possible, but
i got the following question.
My boss would like me to make sure that every outgoing mail has the same
looks. It starts by adding a signature that is the same for everyone, except
with ofcourse personalized information. This was easily done by giving
everyone a signature.
The next question is however, to put the head of our website, also above our
mail. This means that every user that sends a mail, the mail will have a nice
header, underneath that header, the mail is typed, and then its ended with
the si...140 MB file went to 5.08 MB after editting 1 table
Hello All -
I need some ACCESS insight...please...
Several years ago, I built an access db to track my business
scheduling and accounts payable/receivable.
So this database is EXTREMELY IMPORTANT TO ME.
The file has grown to 140 MB.
Today I made a copy of the file and then edited my calendar table.
I removed all columns which had 2006 data (72 totals columns) - the
table had about 144 columns originally.
I then added 72 columns with 2008 headers. These columns are now
blank since I have not added any 2008 data yet. Afterwards, I looked
around and everything looks good - my 2007 data is the...Office installation and Windows 7
I got a new computer today with Windows7. It is a 64bit system where I had 32
before. I tried to install my Office Professional 2007 and it would not
install. I got a message that Microsoft would check the problem and get back
to me, then another message that the program was shutting down. I am in
school and really need my Office. Is there a way around this so that I can
get it installed?
Doesnt make any difference, 64 / 32 bit.
Does your new PC have a Trial Version of Office & Activation Assistant that
you failed to uninstall first, then rebooted?
"Linda...Error loading XML into DataSet
When I try to load this xml file (see below) into an asp.net dataset
using the following code:
I get the following error:
"The same table (description) cannot be the child table in two nested
If I take out the anchor tag in the description it works fine,
however, I need the anchor tag in there. Does
anyone have any suggestions?
<?xml version="1.0" ?>
<link>http://liftoff.msf...WLM Beta Junk Mail Filter
The junk mail filters has stopped filtering mail. The address shows in the
list of blocked addresses but the mail is not filtered. The filter worked
fine in WLM but I don't think it has worked since I loaded the Beta.
Where exactly are you looking when you say the address is the same as the one
in your Blocked Senders? The From line may not show the true entry, look at the
entry in the From field you see after pressing Ctrl+F3 on that message.
Gary VanderMolen, Microsoft MVP (Mail)
"DickW2" wrote in message news:O7$LTHNMLHA.4084@TK2MSFTNGP05.phx.gbl...
T...how create Quota filter in WIndows 2003 R2 using Script
I need create quota filter in Server 2003 R2 using vbscript. quota
filter should be applied to directories and not by users.
I searched information about it on google without success.
thank's in advance
First you need open your FSRM (File Server Resource Manager), then you
create a quota template, you must specify if your quota is "software" (just
monitoring, but never deny the user) or "hardaware" (deny users when they
use 100% of the quota), you must specify if you want send e-mail to user
when this user use...Run time error 5 : HQClient
When I double click HQ Client I have message box "Run time error 5 : Invalid
procedure call or argument"
how should I do? I used RMS 2.0
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.