Change Attached Invoice Name

There’s really two different questions here. (Disabling the default Email, and changing an email body/subject/attachment filename).

​@dsj ‘s method is best if you dont have access to PLSQL blocks and customizations, but if you do, here’s what you can do.

1: Disabling the standard “email” sent when you provide an email in the print dialog.

This is possible, it’s a bit convoluted but basically setting an SMTP_MAIL_ADDRESS against a user makes the mail_sender try to use that email address in the “from”, and typically the mail sender does not have send as privileges for that mailbox, so the email is effectively stopped dead in its track (the application message is created, but the email never sends as the exchange server replies that the mail sender account does not have send as privileges on the user’s mailbox)

In cloud this is done by setting an email in this field:

2. You can then create a PLSQL Online Event Action that triggers when the PDF is generated (this is on event ID PDF_REPORT_CREATED). Preferable if you execute it as a deferred job to be able to track if anything goes wrong etc.
   
   In this Action, you can perform the required logic to send the email to the required target, with any custom Email Subject, Body, and Attachment FileName.

Here’s a bit of a code excerpt where I do exactly this

  -- Set To List
  to_list_ := pdf_sent_to_;

  -- Set CC List
  cc_list_ := user_mail_address_;

  -- Retrieve PDF Archive
  begin
    select *
    into  pdf_archive_
    from pdf_archive t
    where t.result_key = result_key_
    and t.print_job_id = print_job_id_
    order by t.created desc
    fetch first 1 rows only;
  exception
    when others then
      raise no_pdf_archive;
  end;

  language_code_ := upper(pdf_archive_.lang_code);
  pdf_id_ := pdf_archive_.id;

  -- Set PDF Name

  report_title_ := initcap(Report_Definition_API.Get_Translated_Report_Title(report_id_ => report_id_,
                                                                             lang_code_ => lower(language_code_),
                                                                             default_value_ => 'Unknown_Report'));

  pdf_title_ := report_title_;
  -- Replace spaces in title with underscores
  pdf_title_ := replace(pdf_title_,' ','_');  
  -- Replaces any characters not accepted as a filename with dashes                                                                       

  pdf_title_ := replace(pdf_title_,'\','-');
  pdf_title_ := replace(pdf_title_,'/','-'); 
  pdf_title_ := replace(pdf_title_,'*','-');   
  pdf_title_ := replace(pdf_title_,'?','-'); 
  pdf_title_ := replace(pdf_title_,'"','-'); 
  pdf_title_ := replace(pdf_title_,'<','-'); 
  pdf_title_ := replace(pdf_title_,'>','-'); 
  pdf_title_ := replace(pdf_title_,'|','-'); 


  pdf_name_ := pdf_title_||'_'||result_key_||'_'||print_job_id_||'.pdf';                                                                          

  -- Set Attach

  attach_ := '###'||pdf_id_||'###'||print_job_id_||'###'||result_key_||'###'||pdf_name_;

(The last bit there, for setting Attach, is just one way of doing this, but this format is something that is accepted by the Mail Sender to retrieve the right file data. There’s other ways of doing this, I can elaborate if required but this is just the “simplest” way).

You can then set the Body/Subject as you want to and basically you end up calling command_sys.mail with the following parameters

  -- Send Email 


      COMMAND_SYS.Mail(sender_      => '',
                     from_        => from_email_,
                     to_list_     => to_list_,
                     cc_list_     => cc_list_,
                     bcc_list_    => '',
                     subject_     => subject_,
                     text_        => text_,
                     attach_      => attach_,
                     mail_sender_ => 'MAIL_SENDER1'); 

Obviously you’d want to make sure the from_email_ is a mail address that your mail_sender account has access to (such as itself, or any other mailbox it has send as privileges on).

Nice hack ​@SimonTestard  😎