how to send email from oracle report 6i

5 pts.
Tags:
Oracle 6i
Oracle Reports
Oracle Reports 6i
how to send email from oracle report 6i separate page for each employee e.g employee pay slip?
ASKED: April 26, 2009  10:33 AM
UPDATED: April 27, 2009  6:25 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

First of all we need to configure Reports to use your SMTP server to send emails. The SMTP server address is held in a configuration file called rwbuilder.conf. Follow the steps below:

1. Find this file (usually in /reports/conf or search for it using Windows search)..
2. Open it for editing in your favourite editor.
3. Find an entry like 192.168.100.100 (Please note that the IP address in the file on your PC will be different to this one).
4. Change the IP address found in the above step to your SMTP server’s NAME or IP Address.
5. Save and close this file
6. Close Oracle reports if it up and then restart it (so it can read the changed config file)

The above steps would configure Reports to use your SMTP server.

Set the following “System Parameters” under Data Model in Oracle Reports for your report.

* DESTYPE = Mail
* DESNAME = email address where you want the ouput to go to

Run your report and if all goes well you should have an email in your inbox (if you supplied your email address in DESNAME parameter of course!!).

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following