From a drop down list of 15 names in A2, B1 returns a value of 1-1
depending on which name selected.
The idea is to show in column D the names of upto 24 players, the nam
chosen in A2 has played.
I use the following formula. ( a nested IF only allows 7 options??)
& so on to +IF($B$1=15,AW2,0)
This formula is repeated 24 times D4 through D27 to return text fro
cell reference I2, L2, O2 & so on.
It returns always returns #value! if I change text to numbers i...Distribution List error #2
I have Exchange running as part of a Small Biz Server.
When we try to create a DL of external address's (like 180 addresses) we get
an error saying that we have exceeded the max size of the DL.
I can't find anything that provides any indication of a limit such as this.
180 certainly isn't the limit of a multi-valued attribute in AD.... Did you
try creating another DL to confirm it wasn't specific to that particular
MVP - Exchange
NEW blog location:
-------------------------...Anyone getting error after running the Payroll tax update code?
We just ran the payroll tax update (Round 4) which included a code change.
Now when we go to print from the Financial Summary window or a GL Trail
Balance we get the following error message: Mem_Bad_Pointer. When the
report prints the account number is garbled and then it knocks you out of GP.
Anyone else getting this or have any ideas?
It's a known issue. You need to reimport your modified reports into new
Charles Allen, MVP
> We just ran the payroll tax update (Round 4) which included a code change.
> Now wh...Converting email from outlook express to outlook 2003
I recently purchased microsoft office professional
edition 2003 with outlook 2003. I previously had outlook
express. My email is still going to outlook express.
How do I get it to go to outlook 2003?
Tony <email@example.com> wrote:
> I recently purchased microsoft office professional
> edition 2003 with outlook 2003. I previously had outlook
> express. My email is still going to outlook express.
> How do I get it to go to outlook 2003?
Set up Outlook. Create your account so that its properties match the
account in OE. Then, open your Internet Op...Send/Recieve error getting out of hand
I keep getting the following error every time I send a message. I'm using
outlook 2003/Exchnage 2003 on win2k3 server.
Task 'Microsoft Exchange Server - Receiving' reported error (0x8004010F) :
'The operation failed. An object could not be found.'
I've looked it up in the KB and all I've found states that it is an error
from using outlook 2000, which has never been in stalled on this machine. I'm
getting this on a few other machines in my organization, can anyone tell me
what's going on. I'm up to date on all my patches and service packs.
Thank...No Attribute Error
i have a tab delimited file containing records i intend to use as leads in
CRM v1.2. i have customized the lead form a bit (added a few fields to the
schema, published, etc.) when i run the import wizard, everything seems to
be running smoothly, ie, i line up the fields from my tab file with the
appropriate crm fields, and click import.
i keep getting the error (No Attribute) i can't seem to find any help on
why this error would come up. i have removed constraints from all fields on
the leads form(s) but keep getting this error when tyring to import even
Anyone ...outlook express #70
I saved emails from my previous computer from Outlook
Express on CD. I am running the identical program on my
new computer and I cannot get my emails to load on this
computers Outlook Express. Could you help me to get these
emails off my CD.
"Joni Clark" <firstname.lastname@example.org> wrote in message
> I saved emails from my previous computer from Outlook
> Express on CD. I am running the identical program on my
> new computer and I cannot get my emails to load on this
> computers Outlook Express. Could you...Macros error
Operating System: Mac OS X 10.5 (Leopard)
Hi There, I have an apple mac G5 with mac os 10.5 Leopard. <br><br>I have Office 2008 installed, and I keep getting an error in Excel, it has happened recently as the document worked before and I have never gotten this error. <br><br>When I open this specific document I get an error explaining that the document contains Macro's and I can either open and remove macros or open. If i choose open, the document opens and it looks fine, once i click on a "button" i have on the document that work...HTTP Virtual Server Error
Hi All. I have a problem with my exchange server. We run outlook web access
from the server and the HTTP virtual server has been stopped, when I try to
restart it I get the following error message
Cannot create a file when that file already exists
ID no: 800700b7
Exchange System Manager
Has anyone else already come across this problem, and if so how do I get
round it. I have checked security permissions and they are correct.
any ideas would be really helpful.
...Error setting up Data File
I am using Outlook 2003 beta 2. When trying to set up another profile, I
have difficulty getting it to create a new data file.
In control panel, I do the following:
Mail, select profile, Properties, Data File, Add
Then, I get a window popup saying:
An unknown error occurred, error code: 0x80070002
Any idea why? I have installed OutlookFolders software if that makes any
...attachments on Outlook Express
The attachments on my incoming email are shadowed out and
I can't open them. How can I get the attachments to open?
"spencer" <email@example.com> wrote in message
> The attachments on my incoming email are shadowed out and
> I can't open them. How can I get the attachments to open?
Tools-Options-Security for the 160,000th time..........
This newsgroup is for support of Outlook
97/98/2000/2002/2003 from the Office suite of products. Outlook
Express is actually a separate program despite the similar name....Re-install Outlook Express 5
I up dated via download the OE version 6. Now some of my
programs do not work properly because of a lack of
available memory. Where can I find the old version 5, and
can I re-install it?
Larry <firstname.lastname@example.org> wrote:
> I up dated via download the OE version 6. Now some of my
> programs do not work properly because of a lack of
> available memory. Where can I find the old version 5, and
> can I re-install it?
Ask in an Outlook Express newsgroup.
...Archieving Error on MSN Deleted Items
I get this message everytime my archieving runs...it says:
Error while archiving folder "Deleted Items" in store "MSN". Some items
could not be copied. They were either moved or deleted, or access was
Does anyone know what this means exactly?
Windows XP Home
Office XP Professional
I get the very same message Outlook 2000. I am a software developer. If I was to display a worthless message like this, I would be fired on the spot. If an error was detected, the program could say what went wrong in the error message. It...Express
Can I import Outlook Express 6 into Outlook 2000?
Express seems to use dbx extensions and 2000 doesnt
Either in OE go to File-Export or in Outlook go to File-Import and export.
"Thom" <email@example.com> wrote in message
> Can I import Outlook Express 6 into Outlook 2000?
> Express seems to use dbx extensions and 2000 doesnt
> recognize them.
Ok. What do you select for IMPORT? OR What do you
select for EXPORT TO..
I can export to Excel but it errors during import. I ca...Option group & paramater error
I have a form that I wish to use an option group to filter a field on
I have input the following code:
Private Sub fraStatus_AfterUpdate()
If Me.fraStatus.Value = 2 Then
Me.Filter = "Status = Closed"
Me.FilterOn = True
ElseIf Me.fraStatus.Value = 1 Then
Me.Filter = "Status = Open"
Me.FilterOn = True
Me.FilterOn = False
I have also placed the following code in the subform:
Private Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer)
If ApplyType = acShowAllRecords Then
Me.fraStatus.Value = 3 'Show all...Insert object error
In Word 2006 when I try to insert an object from a file (another Word file,
Excel file, etc.) as an icon in a Word 2007 document I receive an error "Word
cnnot start the converter mswrd632.wpc."
What can I do to correct this problem. Thanks.
Click on the Fixit button at http://support.microsoft.com/kb/973904
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"JoeP" <JoeP@discussions.microsoft.com&g...ERROR when opening Excel file #2
Please let me know if you have seen this or know how to fix.
I'm getting this error(below) message when opening a pretty basic excel
Does anyone know how I can find out how it is attached to the file... I've
tried everything and can not get rid of it. I desperately need this file to
be clean, any suggestions would be greatly appreciated.
Cannot find 'c:\program files\IQSC\Q+E\[qe32.xla]qe32'$A1, which has been
assigned to run each time [File.xls]Sheet1 is opened. Continuing could cause
errors. Continu [yes] [no]
There are no macros that I can see att...Outlook Express opening slowly ??
I have WinXP Pro, running Outlook Express. Whenever i open OE6 it opens to
the inbox, sticks (freezes) for about 10 to 15 seconds, then opens up the
Inbox mail. It works fine from there on in.
What could be causing it to open this slowly, is it checking on something
and how can i stop it doing whatever it's doing in this time. It never used
I did put some basic filters on e-mails (junk mail etc), and i thought it
was that but i have removed them (i think) and it's just the same ???
it only works about 40% of the time. I get this
The connection to the server has failed.
Server: 'pop.sbcglobal.yahoo.com', Protocol: POP3, Port:
110, Secure(SSL): No, Socket Error: 10061, Error Number:
I have contacted my isp and everything is good on their
end and this is a chronic issue. Can you please help me
This newsgroup is for support of Outlook 97, 98, 2000 & 2002 from the Office
family for Windows PCs. For Outlook Express (OE) support try posting in one
these newsgrou...Have you seen this error?
Greetings. very basic programming knowlege here.
Using Win3K AD and Exchange3K SP1.
I have creaged a VB6 (no, I do not have .NET), program that creates a user
and an exchange mailbox. It worked fine until I upgraded my workstation
exchange management tools to Exchange3K SP1.
I get Run-Time Error 13. Type Mismatch on the 'SET OMAILBOX = OBJUSER'
The code I am using is canned from Microsoft. ADSI portion. Link is below.
When I unregister the Exch3K SP1 CDO...Syntax Error
I have just bought a Lexmark Pro 700 Series Printer but I have received the
following error message
Error Syntax Error
I have been told it is something to do with my Internet browser settings has
anyone any ideas ?
Always state your full Windows version (e.g., WinXP SP3; WinXP 64-bit SP2;
Vista SP1; Vista 64-bit SP2; Win7; Win7 64-bit) as well as your IE version
when posting in an IE-specific forum or newsgroup. Please do so in your next
Assuming Vista...importar emails y cuentas desde Outlook Express 6 a Windows Mail
Me acabo de comprar un laptop con Windows Vista, mi anterior Laptop tenia XP
y usaba el Outlook Express 6 y necesito pasar todos esos emails a Windows
Mail, alguien me puede explicar como??
...memory instruction error
I have a customer with about 35 employees running Windows
2000 SP4 and Outlook 2000 SP3. All of a sudden today
there are about 6 or 7 computers that are getting the
following error "The instruction at "XXXXXXXXXX"
referrenced memory at "XXXXXXXXXX". The memory could not
be 'read'". I have gone to microsoft's site and research
the error and did everything that I could find including
unchecking the net folders, renaming the outcmd.dat and
deleting some log files. If anyone has some assistance
that would be great.
...IE 6 sp1 error with owa
I sometime get blue boxes around icons in IE 6 sp1 on xp sp2. It does not
happen all the time. If I use the ssl version it is fine. This is the
script error that I get:
This is what's running:
windows 2003 server
Exchange 2003 sp1
i always get #name?? error when am trying to do something with
like date difff or date add
when i have this expression in the control sourse
eg: review date-1=dateadd("m",[evaluation period-1],[hire date])
can anyone help me
kashi <firstname.lastname@example.org> wrote:
> i always get #name?? error when am trying to do something with
> like date difff or date add
> when i have this expression in the control sourse
> eg: review date-1=dateadd("m",[evaluation period-1],...