Mailing oracle report output via SMTP

Please open this link : http://<server_name:port>/cgi-bin/rep2excel.exe?job=getwebpage&pagename=emailsetup ,

You can also visit Index page of Rep2excel, and then Rep2excel Manager, and then click Setup the email account that is used to send report.

I nput 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.
• User Name :
• Password :

Tip: If you just want to send mails to users of the same smtp server, the server always does not require authentication.

If it works, goto next step, otherwise goto step 1.

http://server_name/rep2excel.exe?job=getwebpage&pagename=testemail

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;