Home » Developer & Programmer » Forms » Change Email Subject
Change Email Subject [message #649466] Sun, 27 March 2016 10:01 Go to next message
kuwait
Messages: 55
Registered: October 2007
Member
Hi,

I want to change the subject of an email generated report using forms 6i and oracle 9i

I used the following code

ADD_PARAMETER(pl_id, 'SUBJECT',TEXT_PARAMETER, 'Attached Report');


but it won't change it remains as the default subject "Report sent from Report Builder"

how to do it?


Following is part of the code
------------------------------

declare
pl_id paramlist;

	begin
		 pl_id := get_parameter_list('tdata');
		 if not id_null(pl_id) then
		    destroy_parameter_list(pl_id);
		 end if;
		 
		
		 pl_id := create_parameter_list('tdata');
		 add_parameter(pl_id,'PARAMFORM',text_parameter,'No');
		 ADD_PARAMETER(pl_id, 'SUBJECT',TEXT_PARAMETER, 'Attached Report');
		 add_parameter(pl_id,'DESTYPE',text_parameter,'Mail');
		 Add_Parameter(pl_id,'DESFORMAT',TEXT_PARAMETER,'PDF');
		 Add_Parameter(pl_id,'REPORT_DESFORMAT',TEXT_PARAMETER,'PDF');
		 Add_Parameter(pl_id,'DESNAME',TEXT_PARAMETER,'xxx@mail.com');
		 Run_Product(REPORTS, 'rep', ASYNCHRONOUS, RUNTIME,FILESYSTEM,pl_id, NULL);

        exception
	  when others then
	  message('Error call 87036');
        end;

[Updated on: Sun, 27 March 2016 10:02]

Report message to a moderator

Re: Change Email Subject [message #649467 is a reply to message #649466] Sun, 27 March 2016 11:14 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm not sure it'll help, but you can try it anyway: what happens if you shorten the subject to a single word (just for testing purposes), such as
ADD_PARAMETER(pl_id, 'SUBJECT',TEXT_PARAMETER, 'AttachedReport');


If it turns out to work correctly, try to use two words, but now enclose them into double quotes, such as
ADD_PARAMETER(pl_id, 'SUBJECT',TEXT_PARAMETER, '"Attached Report"');


Any improvement?

[Updated on: Sun, 27 March 2016 11:14]

Report message to a moderator

Re: Change Email Subject [message #649468 is a reply to message #649467] Sun, 27 March 2016 11:19 Go to previous messageGo to next message
kuwait
Messages: 55
Registered: October 2007
Member
Hi,

Unfortunately, I tried those before, It's the same didn't take it.

Thanks for trying to help
Re: Change Email Subject [message #649499 is a reply to message #649468] Tue, 29 March 2016 03:21 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
If the other parameters are working then I would assume the problem lies with the report not the form.
Previous Topic: How to display the environment name on login screen
Next Topic: SET BLOCK STATUS in Forms 6i
Goto Forum:
  


Current Time: Fri Mar 29 00:08:56 CDT 2024