You can create a report for each letter using Oracle Reports, or another tool of your choice. The report contains the skeleton letter text and Select statements specifying the data to be extracted from the Oracle database.
Figure 1 - 46 illustrates the sequence in which you set up standard letters using Oracle Reports.