Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sending Automatic Email messages from in Actuate

Status
Not open for further replies.

tjcusick

Programmer
Dec 26, 2006
134
US
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
 
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:
Code:
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:
Code:
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top