+
+<hr>
+<h2>Outbound messages</h2>
+<%perl>
+$sth = $dbh->prepare("SELECT * FROM texts ORDER BY textid");
+$sthi = $dbh->prepare(<<END);
+ SELECT * FROM addresses
+ WHERE textid = ?
+ ORDER BY emailaddr
+END
+$sth->execute();
+</%perl>
+% while (my $row= $sth->fetchrow_hashref()) {
+<form action="edit" method="get">
+<h3>Message "<% $row->{'desc'} |h %>"</h3>
+
+<&| txtable, tx => $row &>
+% $sthi->execute($row->{'textid'});
+% my $anyused = 0;
+% while (my $rowi= $sthi->fetchrow_hashref()) {
+<tr><td>Used for:</td><td><% $rowi->{'emailaddr'} |h %></td></tr>
+% $anyused++;
+% }
+% if ($anyused) {
+<tr><td colspan=2>Not currently in use</td></tr>
+% }
+</&>
+<pre>
+<% $row->{'text'} |h %>
+</pre>
+
+<input type="submit" name="t_<% $row->{'textid'} %>"
+ value="Edit or configure this message">
+<hr>
+% }
+<h3>Add new message</h3>
+<input type="submit" name="create"
+ value="Start adding new message">
+</form>