When I just open up Properties on the SQLAdmin operator, it won't let me send an email.  It is still saying the same thing.  I have been reading different things...

SQLAdmin is and when I click test, it works.  Why won't it work when I try to do a test email for a job?

Yes, I have stopped and started MSSQLSERVER and SQLSERVERAGENT. 

When I try to run a test email on an operator, it says:

Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is...

So does anyone out there have any ideas about what would be going wrong? 

I think it has something to do with MAPI.

Thanks!

Ok, I have done all of that now.  I have set up my SQLAdmin account on both MSSQLSERVER and SQLSERVERAGENT.  Also, the mail profile is setup.  When I try to run...

I have gone through all of those articles.  I have setup Outlook also.  When is use the QA and do this:

exec master..xp_sendmail @recipients='brenda@capitaltracer.com', @subject='Mail Test'

It works, but setting up notificationss...

Thanks!  It's perfect!  Where did you get all of your knowledge?

So what should I put in the WHERE clause then?  If a case number already exists in the table, I don't want to insert it.  Otherwise, I do want to...

Do I have to have a WHERE clause at the end or can I just do this:

IF NOT EXISTS(SELECT * from tblCapRec) INSERT INTO tblCapRec (CaseNumber,PartNumber,Status,LastName,FirstName,Others,SSN,OtherSSN,OtherNotes,InGDB,DocsOrdered,DocsHere,AppHere,Suspended,SentToHUD,SentToTSI,SentToCredit,SpanishCase,MailAddress,MailAddress2,MailCity,MailState,MailZipCode,CareOf,HomePhone,WorkPhone,CellPhone,FaxPhone,OtherPhone,SpousePhone,SpouseWork,SpouseCell,SpouseOther,PropAddress,PropCity,PropState,PropZipCode,Updated,MailKey,MailedFirst,FirstRcvd,AppSent,AppSent2,AppSent3,AppSent4,AppSent5,OrderedDocs,AppRcvd,Paid,FirstBillSent,SecondBillSent,FinalBillSent,FeePaid,MortgageAmt,PaidUpFront,EndorseDate,Term,MatureDate,EncumDate,HoldingMor,ServingMor,RcvdFromOld,RcvdFromRegular,RcvdFromRtn,RcvdFrom2s,RcvdText,RefundAmt,RateCharged,AmtPaid,LateFees,Contract,TFC,Application,Docs,Other,Notes) SELECT t1.CaseNumber,1,1,t1.Lastname,t1.FirstName,NULL,t2.akas_ssn_1,t2.akas_ssn_2,t2.subj_first_1+t2.subj_middle_1+t2.subj_last_1+t2.subj_suffix_1,0,0,0,0,0,0,0,0,0,t2.subj_address_1,NULL,t2.subj_city_1,t2.subj_state_1,t2.subj_zipcode_1,NULL,t2.subj_phone10_1,subj_phone10_2,NULL,NULL,t2.subj_phone10_3,NULL,NULL,NULL,NULL,t1.PropAddress,t1.PropCity,t1.PropState,t1.PropZipCode,GETDATE(),1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,t1.MortAmount,t1.PaidUpFront,t1.EndorseMonth+'/'+t1.EndorseDay+'/'+t1.EndorseYear,t1.Term,t1.MaturityMonth+'/'+t1.MaturityDay+'/'+t1.MaturityYear,t1.EncumMonth+'/'+t1.EncumDay+'/'+t1.EncumYear,t1.HoldingMor,t1.ServingMor,0,0,0,0,NULL,t1.RefundAmount,t1.RateCharged,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL FROM...

Where do I put the "'WHERE NOT EXISTS"?  Can you show me?  Thanks!