I have the following formula.
It now needs to be changed to a formula that can handle text instead of
How do i do it?
Use Countif instead of Sumif
Do you really have a function Countifs with an "S" at the end? thie
maybe an UDF that needs to be modified.
joel's Profile: 229
View this th...Outlook VERY slow / extra traffic while selecting multiple emails
I have purchased a new computer recently which is a
1.8GHz powerhouse with a ton of memory. The thing is
that outlook crawls on this computer, while it flies on
my p450. This behavior happens when i select multiple
emails for any reason, ie, to delete them, move them,
etc. After i am done selecting them (let go of the mouse
key with a shift key multiple select)I see the network
traffic going crazy, and outlook locks up until the
traffic ends. It can take 5 minutes to select 100
records for instance. I have looked everywhere, but i
cannot find the problem. Any ideas?
I have a si...Help !
I need to create a data input screen on excel where multiple users
at the same time will use them & input data.
This data then needs to be stored as a database as well, where i can
use it to understand trends
and the question is ...?
<firstname.lastname@example.org> wrote in message
>I need to create a data input screen on excel where multiple users
> at the same time will use them & input data.
> This data then needs to be stored as a database as well, where i can
> use it to understand trends
>...Help with this thing
It was working in the window "Transactions >> Sales >> Transactions of
Sales", but exactly were publishing a Quotation, which i wanna print, more
nevertheless was shut up to me network, then I closed the window and it threw
several messages to me of error, and from that then it was blocked the
quotation that was working.
My question is as I can unblock this document?
...Outlook crashes when typing recipient
Every time I try to send an email message in Outlook, it crashes as
soon as I start typing in the recipient address. Does anyone know what
could be causing this and how to fix it? I do not have any Add-Ins
It would be helpful if you provided at least some basic information such as:
1. Outlook version
2. Mail account type
3. Information store
4. The steps used to break Outlook. I suspect this didn't just start
happening on its own for no reason.
<email@example.com> wrote in message
news:firstname.lastname@example.org...can deleted folders be re-stored?
Accidently deleted some important folders and I wanted to know if they could
possibly be re-stored someway? HELP PLEASE!!!
Did you empty your Deleted Items folder already? If not, there should be a +
sign beside your Deleted Items Folder. Click it to locate your deleted
If not, try this:
"Lydia" <Lydia@discussions.microsoft.com> wrote in message
> Accidently deleted some important folders and I wanted to k...Help with Outlook Setup!!!
I have XP Professional installed and Office XP Professional. I have several
users setup for kids, as well as my admin account.
I want to setup a Limited Account in addition to the Admin account for
myself for daily use. Am I just suppose to pick a different account name
and login password and then setup my MSN Messenger and Outlook POP email
with same username and password that I used to setup the Admin account? I
don't need to share any contacts or anything, I just setup the admin email
in order to setup Outlook. I want to input my contact info etc., into the
Limited account and use ..."No more new fonts" error message
I have a 444 KB xls with 38 sheets. I keep getting a "No
more new fonts may be applied in this workbook" whenever I
add another sheet and attempt to modify it. Any ideas?
See this KB article
XL2000: Error Copying Worksheets Containing Charts
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
"TS" <email@example.com> wrote in message news:firstname.lastname@example.org...
> I have a 444 KB xls with 38 sheets. I keep getting a "No...BCM History Import?
I was SO hoping that the 4.0 DM wizard would handle Business Contact manager
history, but no such luck. Guess I'll have to create my own data map. Has
anyone done this? (and would be willing to share?)
I've spent way too much time redoing the maps for linking Accounts and
Contacts together for importing BCM 2007 data into CRM Live. The problem
with history is not being able to export it to .CSV and then linking it to
the correct contact and/or account. Do you know of a way?
L...Auto Archive problem
We use Outlook 2003 Sp3. One of my users has this problem with the Auto
Archive feature: certain folders of his mailbox don't get archived. The
emails stay in these folders and others folders emails get moved to the PST
file according to the Auto Archive settings.
Even if I try to archive manually some of the forlers that don't work,
nothing gets archived. What can I do with this?
Are you aware that the Date used to archive is the Date Last Modified? This
may be causing what you think is unsual behaviour. When were the items last
Judy ...HELP !!! I have a ARRAY Formula HELP !!!
Here is the ARRAY Formula I have and this is what I am using it for.
The situation is that it worked 1 time and than not again.
I have a row of number that appear hourly (DOLLAR AMOUNTS), the numbe
are anything from nothing to 10000. I want the hourly number to appea
in specified cell. Here is an example. (I am using EXCEL 2000)
Row D48:K48 answer in cell G2
D48 = $100.00 G2 Should be $100.00
D48 = $100.00 E48 = (nothing) G2 Should be (nothing)
D48 = $1...Import data using macro
Hi, how do you use excel to import a text file using a macro to do the work
I start by creating a new workbook.
Then turn on the macro recorder and open that text file. (Try not to make
errors--it can make clean up troublesome.)
Then format the worksheet (headers/footers/page layout/filters,freeze panes)
exactly the way you want.
When you're done, turn off the macro recorder. Close the imported file and back
to your other workbook.
Insert a giant button from the forms toolbar on the first worksheet (with
Then save it.
Now go into the vbe and start tweakin...Possible to set up a timer in Outlook?
I would like to have one of Outlook's reminders appear. Then, when I
acknowlege it, I would like Outlook to, in effect, 'count down' until a
certain period of time has elapsed, then pop up another reminder.
In short, rather than a reminder that occurs at a specific time of day, I'd
like a recurring reminder that only appears when a certain amount of time
has elapsed after I manually acknowlege the last reminder.
Is there an easy way to set up such a thing in Outlook?
Thanks for any answers or suggestions.
Schuh is my hero <no@mail> wrote:
> I would like to ha...1 email account, 2 mail address, 2 computers, Outlook 2000
I have 1 email account, with is shared between me and my girlfreind, we
each have our own email address, but all our mails go in to one joint
inbox, using something called Email Alias, that our ISP use.
The problem is that we get each others mails, and we would like to
setup a rule so that the mails not intented for the person that recives
them is automaticly deleted in his/her outlook and is left on the
server so the other can get it when checking their mail.
I have been looking for guides to do this for a while and have been
able to find a few for Outlook 2002 and 2003, but none for th...exch 5.5 help
I am in a progress to upgrade Exchange 5.5 (on NT4) to Exhange 2k3 (on 2k3).
I setup a test machine and upgrade the OS to w2k3.
1st I want to connect the 5.5 to AD, so I should install ADC.
Can anyone tell me the steps?
Frorestprep, domainprep, setup adc, and upgrade to exchange 2k3?
If you run through the steps in the E2K3 deployment tools they will walk you
Hope that helps.
Enterprise Messaging Support
This posting is provided "AS IS" with no warranties, and confers no rights.
� 2004 Microsoft Corporation. Al...Help with Formula Please 02-19-10
Need a Formula for the following:
A B C D E F G H I
1 Tom A W 2 H 30 84 30
2 Peter A W 3 H
3 Nick B L 1 A 70
Columns F1:I3 from Data Table has break scores for each player.
Below is the Result Table where I need to show a summary report for high
breaks. I have no problem with Break as I use the Large function. I need a
formula to insert in A1 and A2 to place the name for the corresponding breaks
I just installed Microsoft Office XP Professionaql with
no problem. However, whenever I try to perform any task
such as opening contacts area in order to create an
entry, I receive a dialog box with Microsoft Outlook and
a yellow exclamation point. Also, included in the dialog
box are the words could not open the item, try again.
Other information that might be important is that I use a
pst file. The error message also occurs when I try to
open the Contact folder from the folder list as well as
when I try to perform any function. It was a clean
install not an upgrade. Could you ...Need help in data copying.
I have an invoicing file in excel (Sheet1). I need to store the dat
which is invoiced into another sheet. My Invoice Data starting from Ro
8 and column B to F (The first item is from B8-F8, second item i
B9-F9). B-Item Code, C-Item Name, D-Qty, E-Price, F-Total.
Once I print the invoice, I need to transfer the data to another shee
When I create another invoice, the new data should be added below t
the previous data in Sheet2. So that I can have all the items I sol
Can someone help me sending a macro for it???
I will be grateful to you.
Thanks in advance
-...Multiple POP3 Domains
I currently have Exchange 2003 up and running with Internet Mail (POP3), all
What I would like to do is set up another POP3 Domain on the same server. Is
current internet email: mydomain.ca
add new domain email: mydomain.ca
Yes it is possible. You need to make a new recipient policy for it. You can
then choose who is going to be on the new domain or if all will be on both.
This will be easiest to control via OU groups.
"Mr Techie" <email@example.com> wrote in message
I had alot of help yesterday from Jacob with the following macro, but am
getting a 'run time error 13' when trying to run the macro, and i cannot see
Any help much appreciated
Dim objOL As Object, objApp As Object, lngRow As Long
Set objOL = CreateObject("Outlook.Application")
For lngRow = 9 To Cells(Rows.Count, "A").End(xlUp).Row
If Range("E" & lngRow) = "" Then
Set objApp = objOL.CreateItem(1)
..Subject = "Change Password for system" & Range("A" & lngRow)...Import from MS Outlook 2000
I need to import into my Entourage 2004 all my data from an Outlook.pst file
created in Microsoft Outlook 2000 for Windows. Can you please tell me how I
can do it???
Thanks and Happy Holidays!!
This newsgroup is for questions about converting between versions of
Microsoft Access database software, and hardly anyone here uses Macs.
Probably what you'l have to do is to use Outlook to open the PST file
and export the items it contains to a format that Entourage can import.
If there's a better answer, you're more likely to get it from an
Entourage forum. ...help me #2
how to restrict entering of same values or data in excel
if you mean the 'preventing of duplicate entries' you may check the
mangesh khati wrote:
> how to restrict entering of same values or data in excel
...outlook is too slowly
Is there someone can help me,
My outlook is too slowly and it cost too many memory.
I'm using outlook 2003 and CRM3 client. They are all install nearly so
not many emails.
when I open the outlook 2003,I can see that
outlook cost 180M and CRM3 client cost 150M memory.
...Multiple incoming emails
Why do I get mulitples in incoming emails (5)? I've check under accounts, and
only have one active. Just started 2 days ago.
"momof2" <firstname.lastname@example.org> wrote in message
> Why do I get mulitples in incoming emails (5)? I've check under accounts,
> only have one active. Just started 2 days ago.
See if something here helps: http://www.howto-outlook.com/faq/duplicates.htm
Brian Tillman [MVP-Outlook]
...HQ & Store Operations Manager item synchronization
I have certain Items created only in stores but not in the HQ manager, how
can items created at store level be oploaded to HQ Manager.
This is not possible in RMS, you may find addon that handle it
"Kami" <Kami@discussions.microsoft.com> wrote in message
>I have certain Items created only in stores but not in the HQ manager, how
> can items created at store level be oploaded to HQ Manager.
This is a multi-part message in MIME format.