While operating a Oracle APEX application it is often necessary to send tabular SQL reports via mail. This may be an administration mail about the status of the APEX application or for reporting data to users or stakeholder of the APEX application. Especially for the latter case the layout of this mail should be nice and handy. An easy way to accomplish this is to send the report as an HTML table in a HTML mail via APEX mail.
Recently I have posted a generic function on apextipps, which executes an arbitrary SQL select and renders the result set as an HTML table. Along I gave an example for a general CSS style sheet to do the HTML layout part of the APEX mail.