I want to format column I (highlight cell) under the following condition
the value in same row column F is > 0 and the cell in column I is empty. I
have put the following code in the formula bar for conditional formatting and
I'm getting an error. How do I fix the problem?
First I select column I, and then I select conditional formatting. Then I
change "cell value is" to "formula" and enter the following in the formula
=F1>0 and I1 = ""
When I click OK, I get an error. What is the error?
Place the cursor in I1 cell and pres...Pivot Table not valid error message when formatting data 'button'.
Created Pivot table/chart, password-protected and put onto website (ie NOt
saved file as Web Page). Click on link, get warning message concerning macros
and prompted for password. If attempt to change data button by rightclicking
on it and selecting format - get error message 'Pivot Table not valid'. Note,
accessing the file directly (ie not via the web) works perfectly Ok.
PS Also get visual basic error message ' Run time error 1004 :Unable to set
the default property of the Pivotitem class'
CP = "(All)"
pf = "Year First Seen"...I can send but not receive emails in outlook
I have just installed Outlook 2003. I can send emails but cannot receive
them. I have confirmed my internet settings with my ISP. If I return to
Outlook Express which was installed with Microsoft Works I can still access
my incoming mail from there
Do you receive any errors when trying to receive?
"TeeJay" <TeeJay@discussions.microsoft.com> wrote in message
>I have just installed Outlook 2003. I can send emails but cannot receive
> them. I have confirmed my internet settings with my ISP. If I return to
>...Exchange Freezes on SBS2003
This is a multi-part message in MIME format.
I have a SBS2003 that has been operational for 6 months.
Something is wrong and the whole mail system freezes up.
Rebooting the Server seems to solve the problem for a day or two...
This is one of the Event Viewer messages:
An error occurred on database "First Storage Group\Mailbox Store =
Function name or description of problem: Restrict/SetSearchCriteria
Error: -1102 Warning: fa...Junk E-Mail Lists Error in Outlook 2003 with Exchange 2003
I have seen several people post about this error message that comes up
in Outlook, but so far I haven't seen anyone respond. I am running an
Exchange 2003 server with SP1 and my client is Outlook 2003. I
installed IMF a few weeks ago, and it appears that this message
started soon afterwards. I have now uninstalled IMF, but am still
receiving the message. My end users are getting frustrated, as am I.
There also appears to be an error in the IMF deployment guide about
adding a registry key to increase the list size in Exchange. It
states to "right click System", but there is n...Publisher 2007 -how to view all pages in bottom row of taskbar
I've upgraded from 2003, and now the pages of my webpage listed on the bottom
of the Publisher window are all missing (my website pub. document contains 10
pages, which were visible as number rows at the bottom underneath the
document within the publisher taskbar frame). I cannot select a page any
more. How can I get this page row back?
Thank you in advance for your replies.
> I've upgraded from 2003, and now the pages of my webpage listed on
> the bottom of the Publisher window are all missing (my website pub.
> document contains 10 pages, which were ...URLScan OWA 2003 Exchange
We are running a front end 2003 OWA server and I have followed the
documentation for allowing OWA pages to be server but it does not work. I
have even cut and pasted and actual .ini file from Microsoft. The furthest
that I have got to the point of login but after that both left and right
panes say Page not found.
I would appreciate any ideas.
I'd check out the urlscan log files to see if there is content being blocked
by urlscan. The logs should be in the windir\system32\inetsrv\urlscan\logs.
What do they say?
Also, can you indicate which documentation you used? Are...Outlook 2003 won't send 1 message
I'm having the same problem as Joshua..and it just
started today after I loaded a lot of Windows XP
Professional updates off the Microsoft site. One message
is hung in my outbox; if I write a new message, it moves
to the hung position and won't send.
I am having the same problem with Outlook 2003. I just can't send the
message. Anyone have any ideas?
"kenc" <email@example.com> wrote in message
> I'm having the same problem as Joshua..and it just
> started today after I loa...2 questions about Exchange Server 2000
1. How, or where, do I find out where Service Pack level I have installed? I
see that I downloaded SP3, but I can't tell if it was ever installed.
2. Clients have Outlook 2000. Inbox is open. Last message is selected. No
new mail. Then, if you click on a different message, you get the "new mail
has arrived..." message. It seems to only deliver new mail when you change
1. In Exchange System Manager, highlight the Servers container. It should
show you all servers in the right pane along with their service pack level.
2. Sounds like something is b...Excel 2007 dates and conditional formats
Can anyone please tell me why I can not use a conditional format (<>=)
to identify if a date is greater or smaller then another. Everytime I
try it, Excel does it right in the first column but misses by 2 days
in all following. It also appears to have problems with the years.
Date of propposed compleation of a task is 10/10/07; if the date of
actual completion is 10/10/07 or sooner, turn GREEN. If the date of
completion is 10/11/07 or older, turn RED.
Can anyone help??
First thing to check:
What does 10/11/07 mean?
November 10 1907?
November 10 2007?
O...Importing Exchange Rates
We currently enter currency exchange rates manually into Dynamics GP9. Now
we are looking for a FREE automated option. Someone suggested we use a RSS
feed to get the info- we would then have to convert/prepare the data and use
Integration Manager to import the info into GP (not sure yet how to automate
Has anyone else done this before or have any other suggestions?
There is a sample Exchange Rate integration in Integration Manager. You
should review the source file and destination mapping details in this
integration to gain a sense of what data will be required for the
...distribution group / delivery report exchange 2003
an originator from outside my exchange 2003 organisation
is sending an email to a distribution list,
but he never receive a delivery report
global config, message format for domain * (is ok)
[x] delivery report
[x] non delivery report
"Ronald" <firstname.lastname@example.org> wrote:
>an originator from outside my exchange 2003 organisation
>is sending an email to a distribution list,
>but he never receive a delivery report
Did he request one?
MCSE+I, Exchange MVP
MS Exchange FAQ at http://www.swinc.com/resource/exch_faq.htm
...Error in posting 4 times! Frustrating problems with html signatures and styles (normal.dot)
I just learned that the message posted 4 times; I thought I had canceled
the previous posts where I had not filled in the right newsgroups....
On my machine, it only shows posted 1 time; but I guess that the news
server does not support cancellations of posts.
Sorry about that......
...Error During Send/Receive in Outlook 2003
When i try and send/receive in outlook 2003 it sends out
my mail fine however when it gets to receiving or updating
the inbox i come up with the following error:
Task 'Microsoft Exchange Server' reported error
(0x8007000E) : 'Out of memory or system resources. Close
some windows or programs and try again.'
I do not have any windows open. Below are the few things
that i have tried already.
-make sure no windows are open
-finaly restarted the computer and still no luck.
Well Hope to get a solution.
What are you system specs ? CPU...Outlook XP and 2003
Weird Outlook 2002 and 2003 problem.
If I start a message from within Outlook and attach a file it sends
normally, but if I try and send by hitting the 'mail' button from within
Word or Excel (filling in the pertinent info and hit send) the message just
goes to the Outlook's outbox and will not go out no matter how many times I
hit 'send and receive'. The same goes for files or pictures if I go to the
file 1st and do a R-click send to mail. They just end up in the outbox and
will not send.
"I don't cheat to survive. I cheat to LIVE!!"
...Non responsive MTA on Exchange 5.5
I got the following problem:
The MTA on an Exchange 5.5 box is for some reason not responding anylonger
to a STOP service (probably due to a corrupted message in the queue).
I want to have the least downtime possible and wanna run an MTACHECK asap.
Two solutions available:
-reboot the server (stopping the MTA doesn't work using the regular ways)
-kill the MTA process using the KILL.EXE tool.
It seems to me that killing the MTA process would be faster that having to
restart the whole server. Moreover users can still access their mailboxes
even though the MTA is running amok.
...Excel 2007 exits without asking if I want to save
I just started using Excel 2007 recently. I notice it exits when I keys in
Alt-F4, without confirming if I want to save, even if I had made changes to
Is there an option which I can set and make Excel 2007 verify if the user,
wants to save before exiting? This is the default in earlier Excel versions.
Thanks for help.
have you recently run a macro in which you forgot to turn on
Application.DisplayAlerts =3D True?
On Nov 24, 5:25=A0am, ch <c...@discussions.microsoft.com> wrote:
> Hi All,
> I just started using Excel 200...default mail format based on domain
After 20_ years of Eudora and Thunderbird (in that order), I'm looking
at Outlook for the first time (we're moving to an Exchange backend,
so...worth a look, for obvious reasons). In Thunderbird, if I want to
set a default HTML format for emails sent to a certain domain, I can
specify that. For any other domain(s), plain text.
Is there an easy way to do that in Outlook (I'm using 2007)?
Basically, I want emails sent to my enterprise domain (i.e., my place
of employment) to be in HTML or perhaps RTF, but mail sent to other
domains to be plain text only.
Again, I want ...Microsoft CRM Exchange
From previous listings I came across the fact that the email router or
Microsoft CRM Exchange Connector sends and receives emails to and from CRM.
Also that we can receive an email in outlook then click the Promote E-mail
to CRM Activity button to move it into crm.
Where is this button located. Should I be working on the server where CRM is
installed to get this working?
You will only have the Promote button if you have installed Sales For
Outlook (or a third part add-in)
This will be on the client pc, not (definitely not!) the server
"Gautam" <email@example.com>...Outloook asks for old exchange server
A couple of months ago we did a migration from exchange 5.5 to exchange 2003.
Now I have a couple of users that are getting the cancel request box. I
created another profile in outlook but it still does the same thing. Do or
should I remove all profiles and start a new one from scratch? Any ideas are
Delete the old profile and start anew. If this problem recurs, post your
question to an Exchange group as I seem to recall there is something in
Exchange that you can configure.
> A couple of months ago we did a migration from exchange 5.5 to...business contact manager will not import ACT! 2007
Just upgraded, but my new version of ACT! 2007 will not work. I tried
exporting to CSV but mapping was off.
...Incompatible file format.
Have been using Money for years and have Money Deluxe 2007 installed on both
my home (Vista) machine and my notebook (XP) machine. Problem is when I go
on the road and take my Money file with me, my XP machine says that the file
is incompatible and was created with a newer or updated version of Money.
Both machines have the same version and are both include the latest updates.
What gives? Did Microsoft create something in Vista that precludes using the
Money file under any other operating system? I may have to switch to Quicken
or even a Linux version if they keep this up.............kill formatting brought over from reports
When I export a report from various sources (crystal reports or an Access
Database that has an option to send to Excel), the worksheet format buttons
stop working, or work erratically depending on something that must be coming
over. Also, sometimes I get a sheet sent to me from someone who has done
weird formatting, and it overrides my buttons (where the $ sign button
produces some custom symbol, for example).
I can copy the detail and paste to another worksheet, where the buttons will
work, but is there a way to tell Excel to ignore this type of menu change
when it receives a spreadsh...print multiple attachments outlook 2007
How do I print multiple attachments to an email in outlook 2007 without
selecting each one individually?
File-> Print...-> select option: Print attached files
This will of course print the message itself as well.
In order to print only the attachments or a selection of your attachments in
one go, you'll need a printing add-in. Some are listed here;
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
I want to send some HTML emails from Outlook 2003. I created an HTML
page, with very clean HTML code and CSS in the <head> to control the
formatting. The company logo is held on the website and I have an
absolute link to it.
Ideally I would like this page to become some stationary, so in the
Stationary Picker I selected this HTML file to use as a template.
However Outlook overrides my styles with <font> tags and adds other bits
of HTML to what was a nice clean piece of code.
Is there anyway to stop Outlook doing this?
Vix <firstname.lastname@example.org> wrote:...