Skip to Main Content

Send mail with attachment from a Module in Forms 10g

Hafed BenteftifaOct 20 2008 — edited Oct 21 2008

An interesting email with attachments case if someone has a better solution.

Form module is called. Let's call it INVOICE_MOD. User enters a new invoice and then can either choose to PRINT or MAIL the invoice.
If user clicks on PRINT button, a PDF is generated (thru report server 10g) and user can either physically print the invoice or save the invoice on his desktop.
If user clicks on MAIL button, an email should be sent to client. The email should contain the following:
-From, to, subject, body and the invoice attached as PDF.

Please make not of the last requirement, that is the invoice that was created should be attached to the email as PDF.

Restriction: we can not store anything on the application server although we can manipulate the reports server cache.

Solution that was implemented makes use of BLOBs where the pdf is stored in a table before being sent.
See Metalink NOTE:330146.1 and 70110.1. also has some interesting implementations.
I also went thru the JAVAMAIL bean but this requires attachments on the client side.

Thanks for any input.

Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Nov 18 2008
Added on Oct 20 2008