Parameter form calling report to destype=Mail [message #433298] |
Tue, 01 December 2009 05:31 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
trivedisushil
Messages: 2 Registered: November 2006 Location: Kenya
|
Junior Member |
![sushil_t48](/forum/theme/orafaq/images/yahoo.png)
|
|
I am trying to send multiple emails from this form which is a parameter passing and running the report form.
I have created one table emp1 as below in scott schema database 9i & [app 10g forms reps.]
create table emp1 as select * from emp;
then i altered emp1 and added
alter table emp1 add email varchar2(100);
i updated all 14 records with different email id's in email column.
1. Created report with parameter emp_no and eml on emp1 table
2. Created Form with parameter to send empno,desname=email,destype=mail to report as an parameter value but with parameter=NO
should generate 14 reports with successfully run and should through email.
this is failing to send email although i get successfully run.
can anyone guide me for the same.
|
|
|
|