How to have a trigger fire an email with concurrent program output as an attachment?

 Greetings,

I have a requirement of automating some reports to be avaliable in the employee self services menu. Once selected and run by filling the appropriate parameters, an email notification should be sent to the user including the concurrent program output as an attachment and simultaneously have another email sent to a group including the report name and user name ran that report. I am unable to display such info within the trigger I have created. Please provide me a method to display the necessary code in PL/SQL within the existing trigger.

Existing Trigger:

=============

CREATE OR REPLACE TRIGGER APPS.XXEITC_LETTER_REQUEST