How can I have this IIF query running?
This is my query :
strQuery = "SELECT DISTINCT ID_emp,name,adres,city, " _
& " sports = IIF(EXISTS(SELECT ID_sport FROM tblSports WHERE
ID_pers= tblArbCtr.persID), 1, 0)" _
& " FROM tblArbCtr,tblEmployee WHERE Contract = 0 AND
I want to find out the employees who don't have a contract (contract=0)
first, and after that I want to verify whether they have a sport with the
derived 'sports' column. The compiler fires the following error : '3061 :
Too few parameters. ...Major bug in Outlook 2K(SP3)? Puts emails into the Junk E-Mail folder randomly?! #2
My Junk Sender list is empty and "move to Junk E-Mail folder" is tuned off!.
Nevertheless, from time to time (once in a few days), Outlooks puts one
legitimate email into the
Junk E-Mail folder!
It is an old problem that existed ever since I installed the original
throughout all 3 SPs- 1, 2 & 3 upgrades.
If I would not see it with my own eyes, it would be hard to believe it.
I am using W2K+SP4.
Any knowledgeable hint is appreciated.
...invalid email address
In message to Candy FH Muffman wrote of having an invalid email address. I
use hotmail but would like to prevent ti being used by spammers.
Is there any way I can hide it or restrict it in some way?
Can I make it invalid?
You mean when posting to an online service like this? Sure, don't type your
(correct) email address. See my address or from many others to see an
Note: I've removed your valid address in my reply.
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add...From Outlook 2000 to Outllook 2003
How do I migrate I personal folders file (.pst) from Outlook 2000 to Outlook
Read the Help Files:
"rolo" <email@example.com> wrote in message
> How do I migrate I personal folders file (.pst) from Outlook 2000 to
Thanks Russ it helped. By the way how can I get to this useful help files?
"Russ Valentine [MVP-Outlook]" wrote:
> Read the Help Files:
> htt...Sorting emails by domains, from org to edu (right char is the most significant)
I need to sort the domains according their emails.
That is, how to sort, according to the domain name ( the right is the
most significant )?
On Feb 15, 11:09 pm, "duzhid...@gmail.com" <duzhid...@gmail.com>
> That is, how to sort, according to the domain name ( the right is the
> most significant )?
you'll probably need ...Unable to Save in Publisher 2000 to Flash Drive
I work in a school district and one of our teachers uses Flash Drives/Memory
Keys (whatever you want to call them) for her students to save their projets
on. She's starting a unit on Microsoft Publisher and had the students open a
template off the flash drive and change it and resave in a folder on the
flash drive but all the students are getting the following error:
"There is no disk in the floppy drive or the drive door is not closed.
Please make sure that the floppy drive is ready, then try again."
-It is not a permissions issue - even the teacher is unable to save to...Some Emails Cannot be Delivered
I have a problem that I cannot put a handle on with my exchange
server. Some outbound messages do not reach their destination. The
problem happens with certain destinations.
However the confusing part is that some messages are able to make it
through. This would mean that there are no problems with DNS or MX
lookup or any connectivity issue since some emails manage to make it
I'm at a loss and can't figure where to look first I hope that
someone might have an idea.
You'll have to provide more information. Are you receiving NDrs if so can
you share them? Is ther...Attaching Contacts to new email
Creating a new email. When contacts folder has "shared" contacts and
"personal" contacts how can you set your personal contacts as the default?
Example: creating a new email having never addressed the "send to" contact
before, you hit the "To" button. Currently my "shared" contacts opens up but
I would like my "personal" contacts page to open instead of having to drop
down to "contacts" to bring up that list.
Is there a solution to this?
On 2/26/2010 10:21 AM, assistantneedshelp wrote:
>...owa cant open ppt attachments
i have an exchange 2003 cluster
when a user tries to open or save a powerpoint attachment it hangs at 97%
all other attachments open fine
...Voice connector on Exchange server 2007.
Is there any functionality available in exchange server 2007 regarding voice
If not how can we create it?
Thanks in advance.
Exchange 2007 has the "Universal Messaging" role which is intended for this
purpose. Do you have a PBX?
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"Microsoft Exchange 2007 command shell"
<MicrosoftExchange2007commandshell@discussions.microsoft.com> wrote in
> Is there any functionality available in exch...Recieving email with nothing in them? Blank??
From time to time, I will recieve email from friends,
family, or business...and when I get the email, I open it
up to find nothing but white space. I can't find a common
thing between emails. I just know it is very frustrating
when I have to ask people to resend the email to me or to
a new address.
When I look at my mail on the server, it is fine. It is
when I open Outlook and it downloads it to my desktop. I
Any ideas? Cheers.. vg
Sorry, wanted to add that I am using OL2003 with WINXP and
everything is updated SP wise. I am starting to see some
articles on this...Outlook 2003 Drag and Drop Emails
I have an issue where there is a SBS 2003 server (newly
installed) & when I drag emails to the file system
(explorer window) in order to create file records of the
emails it generates an error.
Dialog Box Name: Error Copying File or Folder
Error Msg: Not enough storage is available to process
I can't find an error logged anywhere, either on the
server event logs or on the local machine event logs...
I have searched the MS KB & Office online, but no joy
yet... If anyone can help that would be great!!!
...Redirect Exchange 2000 IS backup to different Exchange 2003 server
I recently added an Exchange 2003 server to the same org as a 2000 server. I
have dbs from the 2000 server that I need to restore to retrieve email from a
user whose mailbox was moved to 2003. So I need to restore the db for that
mailbox from BEFORE it was moved because when you move mailboxes you lose any
deleted items that were being saved by retention policy.
Is this possible? I'm using Veritas Backup Exec 10 but nothing in their
support KB seems to follow this exact scenario.
If it helps, the old Exch 2000 server is currently empty of users and is
ready to be uninstalled. W...Emails #3
I was wondering if anyone knew of any web based email provder that I
could use that wont be bloked but the I.T Filer at my work. I require
use of emails during the day for personal use but work emails are
monitored. I have tired various sites i.e Hotmail, Yahoo, Gmail, lycos
etc but they are all blocked. Does anyone know of any that may not be
picked up buy the web filer.
It is difficult to answer because it depends on what your filter is and how
it is monitored. For instance, if it is actively monitored and somebody
found out you were accessing the site, then it coul...will CRM load on a 2003 server?
will CRM load on a 2003 server?
Microsoft CRM v1.2 supports Windows 2000/2003 Server.
>> Other Microsoft CRM Online Forum Resources:
>will CRM load on a 2003 server?
No problem. We just completed a 1.2 installation on a 2003 server, without
"Troy Hicks" <firstname.lastname@example.org> wrote in message
> will CRM load on a 2003 server?
CRM 1.2 will also load on Small business server 2003 as wel...Filters not working in Exchange 2003
I have been trying to turn on the Recipient, Connection, and Sender filters.
I have gone to the Default SMTP Virtual Server and turned it on there without
getting an error but when I go to the Properties and add senders to block and
the hit Apply, it tells me that I must manually turn the filtering on in the
SMTP VS. I have stopped and started the Default SMTP VS but still no luck.
That is a standard dialog box, it does not check to see if it is already
enabled, have you tested the sender filtering?
This posting is provided &quo...setup Windows Mail as Word 2003 default emailer
All I can do is setup Outlook. I do not use Outlook.
I would like to email Word docs using MS Windows Mail (new version of Express)
In the Windows Start area, type Regedit into the search bar and then start
the Registry Editor and go to
Right Click on the (Default) item and then on Modify and in the Value data:
field enter Windows Mail so that after you click OK, you have
(Default) REG_SZ WIndows Mail
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a pa...How do I Remove a Split from my Comments in Excel 2003? #2
I have set my current workbook to split/freeze the first column and first 2
rows. Now, when I add a comment to the second row (in any column) my comments
are cut off if I should scroll down.
I don't ever remember the behavior before. And I don't know what I've done
to enable it but it's really annoying.
How do turn this off ?
...Contacts in Exchange #2
We are running Exchange 2003 and Outlook 2003. I have tried to give a user
rights to her boss's contacts through delegation and setting the rights on
the contacts folder, however, while she has the rights she is unable to add
or see her boss's contact folder in her Outlook. She can see it if she runs
a search, but can not permanently put it in her list of contact folders. IS
there a way that I can accomplish this through the back-end?
...unable to paste Excel 2003 chart into Outlook 2003
(This was posted on "excel.charting" group.)
I have a user who's unable to paste an Excel 2003 chart into Outlook 2003
email message. In Outlook options, the checkbox is selected for "Use
Microsoft Office Word 2003 to edit e-mail messages".
When I tested this on my own computer running the same version of Office, if
the box is check, I have no problem pasting; if this box is cleared, I
cannot paste. But on his computer, it doesn't work regardless.
Thanks and regards,
...Disable Secure Sockets Layer on exchange server when using RPC over HTTP
Hi im trying to enable RPC over HTTP to enable users to establish contact to
my Excahger server 2003 over the internet.
Now, I dont want to use SSL (security not that important) and i am told by
this article that i can disable SSL in windows registry.
Note While RPC over HTTP does not require Secure Sockets Layer, you must
modify the registry to enable RPC over HTTP if you do not want to use Secure
Sockets Layer. Microsoft recommends that you enable and require Secure
Sockets Layer for your RPC over HTTP communications.
At this address: http://support.microsoft.com/?id=833401
But i ...Is anyone an expert with outlook that I can call on the phone?
How do I share calenders between outlook and my MSN Premier account?
Assuming you are using the outlook connector, you need to set the msn
account to be the default message store then outlook will use the msn
calendar as the default.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
You can access this...Save as .doc
In Outlook 2003 there is no option to save an eemail as .doc.
is there setting that can be turned on to allow this?
> In Outlook 2003 there is no option to save an eemail as .doc.
> is there setting that can be turned on to allow this?
Not that I know of. You can save as .txt, open in Word, and save as a Word
"Lanwench [MVP - Exchange]" wrote:
> REBeyer wrote:
> > In Outlook 2003 there is no option to save an eemail as .doc.
> > is there setting that can be turned on to allow this?
> Not that I know of. You can save as ...Having problem with spoofing email
Our users just received multiple email from different users outside the
company. In the To: line, it shows his user name correctly but when he print
those email, the To: line was showing somebody else name on the print out.
Is there a way to block this behavior? I'm using E2k3. For some reason our
spam (postini) didn't pick up these emails.
Could you please post the message in raw format (including the mail headers)
> Our users just received multiple email from different users outside the
> company. In the To: line, it shows his user name cor...outlook 97 and express email problems
I am currently on an IBM X21 laptop and is running windows
98 se with office 97 pro. I recently experienced some
problems with outlook (illegal operations etc) and
reinstalled office to fix the problem but since then I
have not been able to send or recieve emails with outlook
97 and outlook express 6. I simply get an error message
saying the host can't be found (but does exist and I can
ping it successfully). Any suggestions on what I might do?
I have tried creating new accounts in windows mail and
outlook express, but I still get the same error.
Thankyou in advance!