Mailing oracle report output via SMTP

1)
Setup the email account used to send email.
Please open this link : http://<server_name:port>/cgi-bin/rep2excel.exe?job=getwebpage&pagename=emailsetup ,
input the details and then click submit button.

Email Address : This item is not important for Rep2excel Server.
SMTP Server : Rep2excel will send mails through this server, the default port is 25.
If you don't know the location of your smtp server, please refer to your ISP or network administrator.
"My outgoing server requires authentication" Check Box : The box should be checked if your server requires authentication.
If the box is checked , you should input the user name and password.
Tip: If you just want to send mails to users of the same smtp server, the server always does not require authentication.
User Name :
Password :

2)
Test the account settings, if it works, goto step 3, otherwise goto step 1.
http://server_name/rep2excel.exe?job=getwebpage&pagename=testemail

3)
Appending "&mailto=accout_name@thedomain.com" to the URL that call rep2excel.

An Example:

The sample code call rep2excel to send the oracle report (not only in html format) to specified recipients bill@microsoft.com.

declare
v_url varchar2(1000);
begin
v_url := 'http://SVR_NAME:7777/dev60cgi/rwcgi60?server=rep_svr&report=test_report.rdf&userid=scott/tiger@test&destype=cache&desformat=HTMLCSS';
--Modify begin
v_url:=encode_url(v_url);--Please don't omit this step;
web.show_document('http://web-server:7777/cgi-bin/rep2excel.exe?filepath='||v_url||'&job=sendemail&mailto=bill@microsoft.com','_blank');
--Modify end
end;