Run and send report as email from forms10g [message #284686] |
Fri, 30 November 2007 09:49 |
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 #288849 is a reply to message #284686] |
Tue, 18 December 2007 22:29 |
|
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
|
|
|