Some OWA users cant login but some can
We upgraded to Exchange 2003 from 5.5 and rolled out OWA. Some of the users
can access the OWA system, But some cant. What should I check?
Are the mailboxes all on 2003 yet? Are you still in mixed mode? How
long ago did you migrate the mailboxes? I've experienced a similar
situation where I needed to wait for either SRS or the ADC to replicate
information for migrated mailbox before OWA could be used. This took
up to an hour sometimes. Also, did you check the permissions of the
user account to make sure they have access to OWA?
I am having the same issue. It has been 3 weeks f...Can I delete OE and just use Microsoft Outlook 2002
I would like to delete Outlook Express is this advisable?
I am going to be using Microsoft Outlook 2002 which I
recieved w/Toshiba PDA and already have it set up on the
same PC as OE. Can I use Microsoft Outlook for multiple e-
Differences Between Outlook and Outlook Express
With Outlook, you can integrate and manage e-mail from multiple e-mail
accounts, personal and group calendars, contacts, and tasks.
"Delia Marlowe" <firstname.lastname@example.org> wrote in message
news:780901c4025...How can I use my calendar and other features wo using Outlook emai
I have Windows7 OS.
I upgraded to MSO 2007.
I cannot access the calendar, etc. without setting up an email profile which
my ISP will not allow using the email address.
How can I use my calendar and other features without using Outlook email? I
could use the calendar on previous versions without setting up an email
Why can't you use Outlook w/o a mail profile? What happens when you try?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
ALWAYS post your Outlook version.
How to ask a question: http://support.microsoft....Need VB code to edit cell values
I need some VB to do the following please (My VB is not good enough yet)
Starting from the active cell (call it the StartCell)
In the cell to the left..
ThreeChars = Value.right(3) (the last three chars)
Value = Value - last three characters (assume value is text & at least 3
value = ThreeChars (as text, overwrite any contents of StartCell)
move active cell one down from StartCell
Examples of before/after
Microsoft MVP Excel
"Stephen Ford" <Stephen_Ford_no@spam_uwclub....Search for a text in a cell and give the outcome later
C30 to C60 contains some data.
I wan to find piano and use =MATCH("*piano*",C30:C60,0) in cell D31
It gives me the anwer 20 in D31. 20 is the squence of piano.
How can I use the function and use return the the whole cell content which
is "Play Piano"? I only know where it is. How to locate where and give the
whole content in D32 please?
„Elton Law” ezt írta:
&g...merging into Word with filtered data
I'm trying to do a merge in Word using data from Excel. However, I don't
want to merge using data from the whole worksheet, but just filtered data
(all people from London - place is one of the fields in the worksheet. I have
no idea how I might do this. Any help gratefully received.
I believe you can accomplish this from Word by using "Query Options" and
selecting to merge only those records you're seeking.
"Italian Pete" <ItalianPete@discussions.microsoft.com> wrote in message
news:3E62FCDC-42EC-48DB-92AC-857B224F085F@microsoft.c...merging 3 spreadsheets into one based upon a single common data field
OK I hope you guys can help me out. Here is the scenario. I have 3
spreadsheets. The main spreadsheet I working with has 500 lines with a
unique number string. The next two spreadsheets have about 12000 lines
but also contain the same unique string as the first spreadsheet. I
want to search the 2nd and 3rd spreadsheet using the first spreadsheets
unique id number and then take the information from the 2nd and 3rd
spreadsheet and then merge it into the first. Does that make since?
Any help would be great.
--------------------------------------------------------------------...Can't Change Text direction in office 2007
i have installed office 2007 ( Pro Plus Edition) on a machine. i have faced
a strange thing that i have never seen. the option of changing text direction
from right to left or left to right does not exist. it come by default with
What's the Problem ?
You need to enable a right-to-left language, such as Hebrew or Arabic.
To do this, perform the following steps:
1. Close Word.
2. Click Start, click All Programs, click Microsoft Office, click Microsoft
Office Tools, and then click Microsoft Office 2007 Language Settings.
3. In the "Available...Changing a cell color....
Can someone help me how can I change a cell color using the"IF" command???
On Mon, 27 Oct 2003 22:27:56 +0200, Shaul <email@example.com> wrote=
> Can someone help me how can I change a cell color using the"IF" =
Under the Format menu, pick Conditional Formatting.
dvt at psu dot edu
...How can I put a text box in every cell?
-How can I put a text box in every cell that I am using WITHOUT having to
insert on manually every time?
- How can I make sure that a text box inserts itself automatically into a
new row whenever I add a row?
One way is to select the row with the text box and copy it to the next row.
Copy and paste it several times and then select the rows and paste them as a
> Two questions:
> -How can I put a text box in every cell that I am using WITHOUT having to
> insert on manually every time?
&g...mail merge problems #2
I have Vista and Office 2007.
When I try to do a mail merge with Publisher and a comma-separated-values
file exported from Outlook, I get the message, "An operation cannot be
completed because of database engine errors."
It used to work fine, but not any more.
There isn't a solution specific to 2007, but this article addresses your error
and probably will work
You receive a "The operation cannot be completed because of dialog or data base
engine failures" error message when you try to perform a mail merge by using an
Outlook 2003 contact folder in Publish...Office Outlook
my office outlook is not working properly, error message : "the procedure
entry point GETiums could not be located in the dynamic link library
MSDART.DLL " .
what should I do?? pls advise. Thanks.
Download and install the latest version of MDAC from Microsoft.
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"david" <firstname.lastname@example.org> wrote in message
> Hi...group of numbers
How can I make a bunch of numbers being recognized as a group?
I've got the following numbers: 1, 2, 3, 4, 5 and 6.
I want them to be considered as a group.
How can I achieve it?
Thank you for your attention
Message posted from http://www.ExcelForum.com/
You can name the range of cells that contain the numbers. There are
If that's not what you're trying to do, perhaps you could give a bit
PeaceMaker < wrote:
> How can I make a bunch of numbers being recognized as a group?
> I&...Can not empty clipboard #2
I have started getting a strange message in several of my MAC Office
products including Word and Excel that says Can Not Empty Clipboard. I
also can not copy and paste in any program including Safari. Does
anyone have any ideas?
Reboot and then run Disk Utility Repair Permissions.
The clipboard is a file. I suspect it has overflowed or become corrupted.
The reboot may take a long time: during a reboot, Unix cleans out its
temporary files, and that may fix the issue...
If it doesn't, I have no idea :-)
On 16/11/06 2:17 PM, in article
1163647035.202984.70550@m73g2...Can't save new contacts in Outlook 2007
When I try to save new contacts in Outlook 2007, I get an error message:
"Could not complete the operation. One or more parameter values are not
valid." It's been suggested that I clear the forms cache but cannot find
how to do that in 2007 (recommended link was for 2003 version). Can anyone
help with that or is there another possible solution?
P.S. I am working off line in Outlook, if that matters.
Also, I can revise and save revisions to existing contacts with no problem.
Why are you starting a new thread?
Suggest following the recommendations in ...mail merge and cc
I use Word 2007 mail merge to Outlook. I also want to CC to one person
during the mail merge. I cannot find a way to put CC.
The built-in mail merge feature does not offer a way to do this. You can use
a mail merge add-in to achieve this though;
The Mail Merge Toolkit from MAPILab fully integrates with the Mail Merge
feature of Word and will add the CC and even an attachment option when doing
a mail merge;
If you decide to order use 4PM76A8 to get a discount.
Robert Sparnaa...How can be detected if an Outlook profile is corrupted ?
I would like to verify in a program if an Outlook profile is valid or not
( is not corrupted ). Is there a method to do this ?
Valid or corrupted are different things.
Valid; account exists
Corrupted; errors in mail profile
Valid; Test Account button in Account Setup
Corrupted; not possible as it can be many many things, you'll know when
working with it
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Create an Office XP CD slipstreamed with Service Pack 3
"kistvan" <email@example.com> wrote in mess...Can I use Free Excel Viewer 97/2000 in Windows XP?
Microsoft downloads doesn't list the free excel viewer compatible with
Windows XP. Is there a free download to view and print excel spreadsheets,
that's compatible with Windows XP?
The Viewer for Office 97/2000 works fine under Windows XP.
Gord Dibben Excel MVP
On Fri, 22 Oct 2004 15:11:01 -0700, "Linda" <Linda@discussions.microsoft.com>
>Microsoft downloads doesn't list the free excel viewer compatible with
>Windows XP. Is there a free download to view and print excel spreadsheets,
>that's compatible with Windows XP?
An...Maximum number of process....Windows
Is there any limit of number of process or thread that can run at a time in
Win9X and win2k/XP OS.
Well, on the toy systems (Win9x), the process limit is fairly small, probably reasonably
on the order of a few hundred, but I've never measured it. The limit is based on the
available real memory, the available paging space, the amount of GDI space, the number of
windows, etc. (the USER and GDI space is shared system-wide under MS-DOS), and, or course,
the sizes of the processes. On real operating systems, you will probably run out of
patience before you r...can not save or view attachments
I can seem to be able to save or view attachments the
reason is that it greyed out what do i do to ungrey it??
See http://www.slipstick.com/outlook/esecup/getexe.htm to learn how to get
the attachments off. One popular method is Attachment Options from
For more information on the security features, see
If you use OE, hit Forward on a message and open or save the attachment,
then close the message. Or disable it using tools | options | security.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 i...Can I calculate a field with 2 different filter criteria in one q
Hi, I have a data source table with a customer name field and various metrics
fields, I'd like to sum metric "a" based on customer name being like "abc"
and another sum of metric "a" where the customer name is NOT LIKE "abc" in
one query, but I can't seem to figure this out, but, I'm a novice at this.
Best I can figure is 2 different queries, then a 3rd query to bring the two
>Hi, I have a data source table with a customer name field and various metrics
>fields, I'd like to sum metric &...how do i ignore a number when using MODE function?
I have a list of numbers that I want to find the MODE in:
But I want to be able to ignore the Zeros
How do i go about doing this so the mode function gives me the #2 only
Dev4me's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29709
View this thread: http://www.excelforum.com/showthread.php?threadid=498091
which is an array formula, so commit with Ctrl-Shift-Enter
(remove nothere from the...How can i print 1 page only??
We have Microsoft Outlook 2002.
If an e-mail initially generated by us becomes very long owing to back
and forth replies we would like to print only the first page containing
the latest reply.
However, the only option we are given is to print 'all/even/odd'
Some mails we receive which are not initially generated by us however
give us the option of which page to print.
It is this type of print option we would like to have for all e-mails!
its driving us up the wall, there must be a simple way to do it but we
just cant find out how! HELP!
--------------------------------...how can I split one cell's data into two cells?
I am using Excel as a database, and have a column with cells with a person's
name (text) in it...e.g., John Smith. NOW, after the fact, I wish to have a
column with just John in it, and another column with just Smith...but I have
NO idea how to do this! Help would be appreciated. Thank you.
Please refrain from multiposting, you have answers in one of the 4!
newsgroups you posted the same question in. Multiposting is frowned upon and
even the MS web interface states so
Excel 95 - Excel 2007
Northwest Excel Solutions
"It ...Can't send attachments #3
Whenever I try to send any attachment, Outlook 2003 won't
finish the send 'task'. There are no other programs
running that would restrict this. Messages without
Attachments send OK though. How can I fix this?