How do I fix this so I don't get an "Error 2015"
Dim x
x = Application.CountIf("E5,E6000", "T13065")
How do I fix this so I don't get an "Error 2015"
Thanks, Rick
Not tried it but I would think
x=Application.Countif(Range("E5:E6000"),"T13065")
Providing T13065 is a string you are counting. If it's a range reference
x=Application.Countif(Range("E5:E6000"),Range("T13065"))
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
www.nickhodge.co.uk
"2D Rick" <rbrowniii@compuserve.com> wrote in m...
forwarding in Exchange 2003 #2I configured the server (Exchange 2003) to forward a user��s emails to
test@xyz.com. It is very strange that all messages sent from xyz.com are
rejected (please see the sample NDR below), there is not problem to other
domains. test@xyz.com did not receive the message while the envelope
recipient (admin@abc.com) did.
Does anyone know how to solve this? Any help would be appreciated.
Thanks.
SC
--------------------------------------------------------------------------------------------------------------------------------------------
Your message
To: admin@abc.com
S...
Exchange 5.5 to Exchange 2003 Migration Question: No ADC??Hello all:
I have an environment where I need do do an Exch 5.5 to 2003 Migration.
The domain has already been migrated from NT4 to 2003. The only thing
is, is that there is no Active Directory Connector setup anywhere in
the environment. That leads me to my first question I guess. How is
this possible that Exch 5.5 is even working with AD?
In terms of upgrading, what would recommendations be? It is a single
Site. I was thinking about bringing up a new Exch 2003 server, and
using "Move Mailbox" to the new exch server. Replicate all the
necessary public folders, decomission the old ...
help installing exchange 2000 in one of 3 sitesI have a domain cotoso.com installed and configured as AD for 3 companies
interlinked together. and + a total of 3 DC in 3 different sites that are
connected by VPN. i have exchange installed in each site connected on the
same domain contoso.Local(+ E-mail -->contoso.com) + hosting their own
companie domain name such as x.com or y.co or z.com for each company.
I have a routing link configured + 3 administrative groups in exchange
system manger for each company.
one DC in one site that also has exchange 2000 installed on it has to be
changed because of poor performance. now i'm ...
Getting an Error when there is nothing to show
--
The bottom of my report which is a statement shows #Error when there is no
Invoices to add up. Can I have it blank instead. this my text Box Control
Source
thanks for any Help....Bob
=Reports!rptOwnerPaymentMethod!subChildOwnerInvoiceAmount!tbAmount.Value
Try:
=IIf([subChildOwnerInvoiceAmount].[HasData],
[subChildOwnerInvoiceAmount].[tbAmount])
Explanation in:
Bring the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.h...
Cannot send mail from outlook, error 0x800CCC78This message started to appear back in Sept and I haven't been able to send
e-mail from Outlook ever since (apart from a 2 day period in Novemeber when
the issue disappeared just as quickly as it appeared).
I now have to cut and paste e-mail i recieve into the e-mail interface of my
provider in order to get e-mail sent.
I have posted this error 3 times now and haven't got a solution, plenty of
questions about versions, platforms, port numbers etc etc, but no fix.
Judging by the hits on google to this, it is and established problem.
Come on Microsoft, do your stuff.....
Restore Exchange 5.5 on 2000 using ArcServeI've got
- Windows NT 4 Server SP6
- Exchange 5.5 SP3
- ArcServeIT 6.61 with Exchange Agent
I'm trying to restore the Exchange information (database, mailbox...
everything) on another computer.
That computer has
- Windows 2000 Server SP4
- Exchange 2000
- Brighstore ArcServe 9 (build 2020) with Exchange Agent
-------------------
Now the situation: I need to verify that the backup was made correctly
(entirely) in order to confirm the total validity of the backup (to validate
my disaster recovery plan) and to update to SP4.
I tried to find documentation with both Microsoft (for Ex...
Change outbound server in header to fix 550 Can't verify your host name errorThe headers on the outbound emails show the internal DNS name of our
exchange server; obviously this won't resolve properly at the
destination.
How/where in Exchange 5.5 can I force the IMC to use a real fqdn on
outbound mail?
Thanks!
Frinky
You can do this in TCP/IP properties\Advanced\DNS tab of machine. And
yes, this is not just for Exchange, so you may consider forwarding all
outgoing mail to some relay server (your firewall or ISP's server).
Professor Frink wrote:
> The headers on the outbound emails show the internal DNS name of our
> exchange server; obviously this...
help!! smtp protocol error occurredexchange 2000 srv/windows 2k srv
smtp protocol error occurred when trying to send mails.
receives fine.
Still waiting for some relavent information so we can
help you solve your problem.
>-----Original Message-----
>exchange 2000 srv/windows 2k srv
>smtp protocol error occurred when trying to send mails.
>receives fine.
>
>
>.
>
I had that problem, I telneted into the servers that the error occurred and
found I was on a blacklist. Had to sumit to an open relay test, and bam, no
more problems.
...
copy of exchange 2000I don't suppose microsoft is providing Exchange 2000 as a free download
anywhere are they??
Until we can afford to move up to SBS 2008 (hopefully later this year), I
want to trash our SBS 2000 (too many issues with it) and simply install a
win2k server with Exchange until we can move on. We are not using any of
the other SBS components any longer anyway...
If anyone knows where I might be able to get this from, I would be very
appreciative!
Thanks, Brad
Why not look at BPOS? $10 per user a month it's a great inexpensive
solution. You may find you do not ne...
Visual Basic ErrorEvery time I shut down Outlook, I now get the following
Microsoft Visual Basic error: "Compile error in hidden
module: Autoexec" This started after I installed the
software for People PC Dial -up Service. They haven't
responded to my question and Tech Net/Knowledge base come
up empty. Help!!! Thanks
So, uninstall that software. It's obviously the problem and if they won't
support it then it's useless to you.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Exten...
can you tell me what an error 920 is?I'm trying to save a visio file out as a jpeg, or gif, or png. I keep
getting the error with no explanation of what the error means - any help is
appreciated
You can go to the following link and it explains the issue you are having and how to fix it: http://support.microsoft.com/default.aspx?kbid=295691
"Julie" wrote:
> I'm trying to save a visio file out as a jpeg, or gif, or png. I keep
> getting the error with no explanation of what the error means - any help is
> appreciated
>
>
>
...
Error- Project is used by another user -Please select another projPlease see the subject line, when im trying to open a particular project.
it gives me following error.
I checked the current users, there are no users. Apart from me.
There are some non PA users,i tried to remove them from activity.
inspite of me removing them from activity, im geting the same error.
Help !!!
Ramakrishnan
Hello Ram,
There is a stranded user in PA000001 table. You need to clear this
User/Project combination.
Ajay
"Ram" wrote:
> Please see the subject line, when im trying to open a particular project.
> it gives me following error.
>
> I che...
Deleted exchange 5.5 site not replicating over the ADC to Exchange 2000 sideWe are a part of a shared Exchange 5.5 organization but our site is
primarily Exchange 2000/2k3. We maintain a single 5.5 server as the
rest of the Org is 5.5. The problem we are seeing is when the folks
who control the Organization at the top level remove a site that is no
longer used, that deletion is not carrying over the CONFIG_CA agreement
to the Exchange 2000/AD side. Our Exchange 5.5 server executes the
deletion with no issue.
Any ideas on why this deletion is not replicating properly over the ADC
and throught the SRS database? In the past we have manually removed
the sites/recipie...
Saving User Settings in Outlook...Hello everyone,
Does anyone know how to save the user settings for MS outlook 2003?
Thanks to all who reply,
Ismael
The reason I would like to be able to save the user settings is so I'll be
able to restore these settings should I need to in case I had to do a clean
install of WinXP and office 2003 either on the same computer of on another
newly bought computer.
Thanks to all who reply,
Ismael
"Ismael" <I_Tena@hotmail.com> wrote in message
news:ueqwqfaHGHA.2948@TK2MSFTNGP10.phx.gbl...
> Hello everyone,
>
> Does anyone know how to save the user setting...
User Authentication ErrorHello All,
I am running CRM 3.0. I have the system administrator role. When attempting
to merge 2 account records I receive an error that states,
"The user authentication passed to the platform is not valid."
I cannot merge the records. If anyone can, please advise. thanks.
Keith
...
Report Error 11-24-04When attempting to run CRM Reports for the first time we are receiving the
error "Information is needed before this report can be processed" I have
found documentation that states that this can happen if your server has an
underscore. Our server does not it is named ourcompany.server.eeecrm Can
the periods have the same effect as the underscore. Or does anyone have
another cause?
Thank you
Hi There -
Hope you don't mind but I wish to piggy-back on your post.
I get the same error on our custom reports that use OLE DB to connect to
another SQL server other than the MS CRM ...
Userform combobox matchrequired = True; error with no selectionI have a userform that includes a combobox which is optional for the user,
but if they do use it, they have to select one of the three values provided
(no creativity allowed).
This works fine if the user ignores the field, or if they make a selection.
They can even click the combobox 'arrow' to see the values and then click to
another part of the form without making a selection. They can tab through
controls including this one without any problem. All good.
However, a user may enter the field (mouseclick) thinking they might want to
make a selection, then decide again...
Script Errors 08-12-04When launching CRM 1.2 through the web interface or
through Outlook I am experiencing errors. This occurs on
all the PCs on our network.
CRM installed on Windows 2000 Advanced Server
Client PCs running 2000 or XP Pro
Browser IE6 with all updates.
The main 3 I see are:
Error #1
Line: 3
Char: 1
Error: Syntax Error
Code: 0
URL: https://crm/home/home_home.aspx
Error #2
Line: 104
Char: 1
Error: 'ORG_DATE_START_DAY' is undefined
Code: 0
URL: https://crm/home/home_home.aspx
Error #3
Line: 15
Char: 3
Error: 'ORG_DATE_FORMAT' is undefined
Code: 0
URL: https://crm/home/home_home...
Outlook 2002 SP3- Runtime Error when opening OutlookI'm getting a runtime error- Microsoft Visual C++ Runtime
Library / Program C:/Program Files/ microsoftoffice/
office10 /outlook.exe. This App has requested the runtime
to terminate it in an unusal way.
This only happen the first time I open Outlook for the
day. It shuts down, then I can reopen it and all is fine.
I have try to debug it and the detect & repair option in
the help tab.
Any help is Appreciated!
...
Failed to open mmf error appearsA pop up window appears with the message 'failed to oepn
mmf'. I assume it is referring to Microsoft mail format.
What could be triggering this error.
What version of Outlook, and when do you see this error?
EllenB wrote:
> A pop up window appears with the message 'failed to oepn
> mmf'. I assume it is referring to Microsoft mail format.
>
>
> What could be triggering this error.
>-----Original Message-----
>What version of Outlook, and when do you see this error?
>
>EllenB wrote:
>> A pop up window appears with the message 'fail...
Unknown error codeHi, I'm trying to set up email in outlook 2007. After I put in all the
information and click on "test account settings", I'm getting an error
message. I mean, in the task tab, the "log onto incoming mail server (POP3),
the status is completed" but on "send test email message, the status is
Failed. and the error message is giving is "an unknown error code: 0x80040607
Does anybody knows out to fix this?
Have you been able to send mail out before using that account, possibly with
another mail client?
"DM" <DM@discussions.microsoft.com> ...
Autoenrollment errors after adding SSL certificateHello, I'm running an all Windows 2003 domain with an exchange server which
is setup so that Outlook web access is using SSL which required that I
installed a certificate. Ever since I've set up exchange to use this
certificate I receive the following errors in the Application log for both
my Domain Controllers (both also Windows Server 2003) which occurs every 8
hours.
Both Domain Controllers show the following errors in the Application Log
Source: AutoEnrollment
Type: Error
User: N/A
Computer: DomainController1 or 2
Event ID: 13
Description:
Automatic certificate enrollment for loc...
error message in Outlook after running windows and office updatesHello,
I am hoping someone can help me with this. When ever a
few staff tries to send a new e-mail, a message "Do you
want to save changes" come up and on the back of this
message I see the spell checker box come up. The problem
is that if you click on "no" on the error message, it
comes up with another message something like "running out
of memory". I just ran all the windows and office updates
on all the machines in the company and so far two
employees are having this problem. Is this something to
do with the updates? Any suggestions?
did you try ...
Mounting exchange 2000 public folder store on exchange 2003I have been told that this is not best practice we have gone ahead and done
this we where having a great deal of difficulty getting the public folders to
replicate. The public folder mail box was incorrectly named I used ADSIedit
to change the mail box name in AD but this didn't work.
So in the end we went for a dirty fix (users had lost access to public
folders for one day already) and dismounted then copied the exchange 2000
public databases to the 2003 box and mounted them there with apparent success.
I'm wondering if anyone has any experience with this? Can I expect this
s...