Using cell reference with logical operator in DGET expression
I am using DGET to search an array in the worksheet to find a particular
percent to use in a calculation elsewhere in the spreadsheet. The row members
of the array contain a series of from and to values that I use to identify
which row has the percent I am looking for. I have defined the array as a
range and I can use the logical operatirs with numeric values in the range
criteria and everything works fine. For example, I can use <500 in the
appropriate cell in range criteria to find the percent to use when the value
for that column in the array is less than 500. All working f...Outlook TASKS
I have a user with outlook 2002 on our exchanger server.
When they click on tasks. We get the error
"Outlook has encountered a problem and needs to close. We
are sorry for the inconvenience."
There is a check box to restart outlook after it closes
I have reinstalled outlook 2002. I have copied the tasks
folder to a *.pst and sent my self the *.pst to see if
the tasks were corrupt. When I click on the tasks the
tasks open up no problem.
I don't know what to do next.
Please some one help me
Has your Exchange admin checked to see if your mailbox is corrupt?
"...Combine Duplicate Folders in Outlook 2002
I recently imported my Outlook folders onto another
computer... I now have duplicate folders (i.e. Contacts,
How do I combine them into 1 and delete the ones I don't
Erik S. <firstname.lastname@example.org> wrote:
> I recently imported my Outlook folders onto another
> computer... I now have duplicate folders (i.e. Contacts,
> Inbox, etc.
> How do I combine them into 1 and delete the ones I don't
Drag the items in the ones you don't want into the ones you do. Once done,
close the PST you just emptied. Now you have one set....outlook always default email application
I use Outlook 2003 for my callender and OE6 for email
Until a week ago, OE6 always remained the default email application unless I
installed a patch or updated Outlook, at which time it would set itself as
default. Fair enough.
Last week I upgraded by BIOS (not sure if this is relevant, but just so you
Now everytime I turn on Outlook, it becomes default mail programme.
In options/ general, OE6 tells me it is not the default.
Internet options lists Outlook as default
But in Outlook/Options/other the default mail,calender,contacts box is not
I change it all back and OE6 ...outlook 2000 embedded pictures
I am running XP with IE7.
When I send an email with embedded pictures Outlook or something? removes
the pictures and replaces them with a RED X in the box. The removed pictures
go as attachments.
What version of Office Outlook?
"hairbychemo" <MJKEELEYJR@worldnet.att.net> wrote in message
>I am running XP with IE7.
> When I send an email with embedded pictures Outlook or something? removes
> the pictures and replaces them with a RED X in the box. The removed
> pictures go as ...Help
My Regional Manager insists on things being perfect -
need assistance with this problem.
Working in Governemtn department - we have many users
with unusal names and surnames - not common to standard
My Rm wants to forward emails received with these peoples
names in the original message - without outlook spell
checking each of these names before sending.
I have set up the email options under spelling - to
ignore original message when forwarding - which it does
but still spell checks the original message's recipients
How do I set this up to exclude the n...outlook 2003 and http email
Outlook's support for Http Email seems to be real bad.
Is there no way of setting up rules within Outlook
that checks what is delivered into a HTTP Inbox and runs the rules
It's so annoying that I have to manually move all the messages
Is there no way to import rules set in msn to outlook
archiving does not work for http e-mails.
Is there any kind of http-to-pop3 converter available?
On Tue, 28 Sep 2004 14:01:11 +0530, "__jakal__" <email@example.com> wrote:
>Outlook's support for Http Email seems to be real bad.
>Is there no way of setting up ...outlook macro security issue
In my Outlook I have set security level Low. Even though I am unable
to run macros in my outlook but I am able to run word and excel. When
tryied to run a macro I am getting following message.
I set secrurity level low using the menu Tools>Macros>security.
"The macro in this project are disabled. Please refer to the online
help or documentaion of host application to determine how to enable
Please help me with the solution.
Thanks & Regards
After changin the security level you need to restart Outl...Removing web access from outlook address bar
Is there a way to remove or restrict someone's access to
the web from the address bar in outlook 2002? I have
users who do not have IE priviledges but are able to
slide the address bar over and type in a web address to
get to websites. Any help would be appreciated.
Can you block their web access at the firewall?
Perhaps this is not a technical problem but rather a behavior problem. If
these people are employees (or children) perhaps you need to create a policy
that forbids them doing this along with some consequences for violating it.
Ben M. Schorr, On...how i can change default file format Outlook uses to save message
I my saving message in my inbox using "File->Save As" menu.
"Save As.." dialog by default shows "Save As Type:" as "HTML".
How I can change default file format Outlook uses to save messages to as
"Outlook Message Format - Unicode" ??????
Rajkumar <Rajkumar@discussions.microsoft.com> wrote:
> I my saving message in my inbox using "File->Save As" menu.
> "Save As.." dialog by default shows "Save As Type:" as "HTML".
> How I can change default file format Outlook uses to save messages...Eliminating all of the little outlooks
I know that there is a program that will automatically shut down Outlook,
for sync and backup purposes. I would like to know if there is any utility
that will go one step further and inspect the Processes that are running and
eliminate all of the instances of Outlook.exe that love to take up residence
there. I swear the number of instances of Outlook that hibernate there are
like the coat hangers in a closet...
If you have multiple instances of OUTLOOK.EXE running in processes, it's not
shutting down properly. The most likely causes are:
i need to define a server side rule, which will copy attachments from
received mails locally on PC/server.
Any idea, scripts, anything?
Seems like ftp would be more appropriate than e-mail. But if you insist
> i need to define a server side rule, which will copy attachments from
> received mails locally on PC/ser...How can I connfigure my outlook to access same profile accross mu.
How can I connfigure my outlook to access same profile accross multiple user
ids on a computer
Krishna <Krishna@discussions.microsoft.com> wrote:
> How can I connfigure my outlook to access same profile accross
> multiple user ids on a computer
You can't. Each user ID will have its own profile, sicne profile
information is kept in the registry in a user-specific area. However, you
can certainly reference the same message store within each profile. For POP
accounts, just put the PST somewhere in the Shared Documents hierarchy and
point to it within each profile.
B...Outlook client for CRM V3
We have a client who has users who want to make changes to the 'my contacts'
local data group, so they sync their Outlook contacts with CRM. They all use
the desktop client.
But the save button is greyed out.
They have a CRM role assigned with the Outlook sync permission and they have
local admin rights. I've also checked they have write permissions to the
C:\Documents and Settings\User.Name\Application Data\Microsoft\MSCRM folder
and it's subfolders.
What else could be disabling the save option?
Becuase My Contacts is a default group, I don't think you can make c...Outlook 2000 Tracking Tab
I don't have tracking tabs. I can't find any online
help. It tells me were the tab should be, but when I pull
up the sent email, no tabs at all. I do have receipts
requested, thus I think I should have tracking. Would
appreciate anyones help. Thanks.
...can not delete in outlook
When I try to delete anything out of outlook i get the
The messaging interface have returned an unknown error.
If problem presists restart outlook
> When I try to delete anything out of outlook i get the
> following errror
> The messaging interface have returned an unknown error.
> If problem presists restart outlook
OL2000: Error Message: The Messaging Interface Has Returned an Unknown Error
Getting "The messaging interface has returned an unknown
error. If problem persits, restart Outlook." when
attempting to forward, send or reply, using Outlook 2003.
Restarting does not help. If you delete the NT Profile the
problem goes away for a few days and then returns. We have
also tried "Detect and repair" and Uninstall / re-install
without good results. Only replacing the NT Profile seems
to have an impact. Help!
...OutLook 2003 Calendar
i am trying to set the starting day of the week to sunday, but cannot do
it. I have gone to TOOLS/options/Calendar options and selected sunday as
the starting day in both the ckeck boxesand the dropdown menu, but no Luck
I have selected any other day of the eekand the will show as first day of
week, but not sunday?
What calendar view are you using? If the monthly calendar view, you need to
uncompress weekend days to have Sunday show as the first day of the week.
View->Current View->Customize Current View->Other Settings.
Milly Staples [MVP - Outlook]
P...Outlook Connector Plugin is Inactive
I have installed the Outlook Connector on both my laptop and desktop. The
laptop works just fine with three MSN email accounts. The desktop, however,
is not working at all. It shows the "COM Add-in for Microsoft Outlook
Connector" as inactive and when I go to "Manage COM Add-ins", the connector
is not checked and it says there was a runtime error loading it. I tried to
check it, but as soon as I return to that location the check mark has
disappeared. The Outlook menu does not show the additional Outlook Connector
menu that is on the laptop. Both machines are r...Outlook IMAP Error
I'm getting the following intermittent error when Outlook tries to
receive mail from an IMAP server:
Task 'Checking for new mail in subscribed folders on <email address>.'
reported error (0x8004DF0B) : 'Outlook is unable to download folder
(null) from the IMAP e-mail server for account <email address>. Error:
The connection to the server is unavailable. Outlook must be online or
connected to complete this action. If you continue to receive this
message, contact your server administrator or Internet service provider
We are on a wired LAN, and ...Problem with versions of word and outlook
My access app uses word and outlook references which I can not get rid of
due to certain features that my app has. I have this problem that I need to
send me app to various clients who have varying versions of outlook and word
and thus my app fails to run. Is there anyway my app can find the versions
of outlook/word at start-up and readjust links to appropriate versions of
outlook/word before continuing? If not, is there another way to fix this
Many thanks. Any help would be appreciated. I am really stuck.
Whoa: no need to include so many newsgroups!
Consider u...Calendar issues with Outlook Connector
Any help would be appreciated on this one-
Is there a way to utilize Outlook Connector SOLELY for email (i.e.,
Hotmail), without it adding another Calendar profile, etc.? I utilize the
seperate "Calendar in Personal Folder" for all my calendar needs. When I
load Outlook Connector and add my Hotmail account, Outlook automatically sets
a new, blank Calendar as the default. Aside from it being an annoyance, when
I try to set a new appointment with a reminder in my "Calendar in Personal
Folder", I get an error message that "The reminder for ___ will not a...sending email from outlook using AOL
After much exasperation have finally got outlook to send email whilst using
my AOL internet connection. The issue is that I have to have my aol email
address entered in the Outlook email box but I use my outlook email address
in the reply email address box.
The problem is that any recipient of an email from outlook will see my aol
email address in the from box and if they click on reply it will be sent to
my aol email box and not to my outlook email box.
If my aol email address is not entered, in the Outlook email box, the email
is rejected by aol.
Using AOL 9 & Outlook 2002
Any ...Outlook on 60 day free trial
My hard drive crashed and my son has my Microsoft Office disk at his
apartment at his college. I bought a new computor and need to use Office
programs now, my son will mail me the disks when he returns to college. I
have downloaded the free 60 day trial to use until then but I do not see
outlook on it. What do I need to do to get outlook as I have alot of contacts
in there that I need to use.
Which trial version did you download? Not all have Outlook.
"RB" <RB@discussions.microsoft.com> wrote in message
news:AA6FA178-E942-4BD0-B1DD-F79E8980997B@micros...Blocked and safe senders file in Outlook 2003
I am wondering where outlook 2003 saves the address that
you add to the safe sender/recipient and blocked sender
list. Outlook XP saved the junk senders in a file
called "Junk senders" in C:\Documents and
I used to backup that file, so I would like to know where
Outlook keeps the file now.
The lists are kept in binary values in the Windows registry and also
in a hidden item in the mail store (mailbox or PST file). Both lists
are kept in one multivalued property although no one has decoded it
yet, the bits also s...