Home » Developer & Programmer » Forms » Run and send report as email from forms10g
Run and send report as email from forms10g [message #284686] Fri, 30 November 2007 09:49 Go to next message
vinodkumarn
Messages: 60
Registered: March 2005
Member
Hi,

we are generating a report from forms10g and sending it as an attachment in an email using RUN_REPORT_OBJECT and everyting is fine.

but we would like to use the parameter 'REPLYTO' in addition to FROM,CC,SUBJECT. i tried to use 'REPLYTO' but in the email i am not seeing the email address corresponding to the 'REPLYTO'

ADD_PARAMETER(thelist, 'REPLYTO',TEXT_PARAMETER, report_replyto_address);

can anyone guide me how to use this 'REPLYTO' parameter

Also is there anyways we can het a 'BODY' in the email, i think we do not have 'BODY' as the parameter

Thanks
Vinod
Re: Run and send report as email from forms10g [message #285155 is a reply to message #284686] Mon, 03 December 2007 14:49 Go to previous messageGo to next message
bala_kumar
Messages: 4
Registered: December 2007
Location: sydney
Junior Member
hi i also need to know how this could be done. could you please let me know if you find a soulution for this.
Re: Run and send report as email from forms10g [message #285156 is a reply to message #284686] Mon, 03 December 2007 14:51 Go to previous messageGo to next message
bala_kumar
Messages: 4
Registered: December 2007
Location: sydney
Junior Member
could you please let me know how your procedure can accept parameters from the form and run the report
Re: Run and send report as email from forms10g [message #288849 is a reply to message #284686] Tue, 18 December 2007 22:29 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I strongly recommend NOT using RUN_REPORT_OBJECT in 9i or 10g but to use 'web.show_document'. Search this forum for 'web.show_document david' for my reasons.

It looks like you are trying to send an email. To do this search this forum for 'utl_smtp' and 'utl_tcp' and 'utl_mail'.

David
Previous Topic: how to create one LOV from more than text item
Next Topic: How to Online Oracle Forms
Goto Forum:
  


Current Time: Fri Sep 27 08:25:32 CDT 2024