Sending Automatic Email messages from in Actuate

[tjcusick]

I am using Actuate 8

I have a report and is scheduled to run automatically on the iServer every night at 4am. What I would like to do is, if there is an error in the creation i would like the report to generate an email and send it to the appropriate person.

Any suggestions as to how to do this?

Thanks in advance.

Tom C

 

[tjcusick]

Well i found some code that another programmer here used to do something similar and I am trying to fit it into my Actuate report. it seems to fit alright but when trying to test it i keep getting an error message:

Basic Error: 102 Module: NewReportApp%Finish Line: 19  Failed to access method or field.  Do you want to debug?

the code i am using for the Actuate Report to email is:

if XMLPolicyFailedBool=True then
  msgbox XMLWhichPolFailed  

  dim jch as Object
  dim jci as Object
  
  set jch = CreateJavaClassHandle("sendMail.sendMail")
  set jci = jch.sendMail()
 
  dim e as string
  e = jci.Send("mail.exchange.com",  'mail server
+ "ReportNotify", 			' user
+ "actuate", 				' password
+ "tcusick@email.com", 	' email address
+ "tcusick@email.com", 	'to ()
+ "", 						'cc
+ "", 						'bc
+ "IVANs Download Failed", 	'subject
+ "The following policy(s) cause IVANs to fail:" & vbCRLF & XMLWhichPolFailed, 'body
+ (fileName)) ' file    
end if

Any ideas or suggestions?

Thanks in advance

Tom C