You can use HTML in your email to format the body. Develop your "table" in a HTML editor like dreamweaver, then use this as a template. Works really good.
Here is a sample program using HTML in the email body.
report zrich_0002.
data: maildata like sodocchgi1.
data: mailtxt like solisti1 occurs 10 with header line.
data: mailrec like somlrec90 occurs 0 with header line.
start-of-selection.
clear: maildata, mailtxt, mailrec.
refresh: mailtxt, mailrec.
perform build_text_message.
perform build_receivers.
perform send_mail_nodialog..
************************************************************************
* Form BUILD_TEXT_MESSAGE
************************************************************************
form build_text_message.
maildata-obj_name = 'TEST'.
maildata-obj_descr = 'Test Subject'.
<b> mailtxt = '<html>'.
append mailtxt.
mailtxt = '<head>'.
append mailtxt.
mailtxt = '<title>Untitled Document</title>'.
append mailtxt.
mailtxt = '<meta http-equiv="Content-Type" content="text/html;'.
append mailtxt.
mailtxt = 'charset=iso-8859-1">'.
append mailtxt.
mailtxt = '</head>'.
append mailtxt.
mailtxt = '<body>'.
append mailtxt.
mailtxt = '<div align="center"><em><font' .
append mailtxt.
mailtxt = 'color="#0000FF" size="+7" face="Arial,'.
append mailtxt.
mailtxt = 'Helvetica, sans-serif">THIS'.
append mailtxt.
mailtxt = ' IS A TEST </font></em><font' .
append mailtxt.
mailtxt = 'color="#0000FF" size="+7" face="Arial,'.
append mailtxt.
mailtxt = 'Helvetica, sans-serif"></font>'.
append mailtxt.
mailtxt = '</div>'.
append mailtxt.
mailtxt = '</body>'.
append mailtxt.
mailtxt = '</html>'.
append mailtxt.</b>
endform.
************************************************************************
* Form BUILD_RECEIVERS
************************************************************************
form build_receivers.
* mailrec-receiver = 'you@yourcompany.com'.
mailrec-rec_type = 'U'.
append mailrec.
endform.
************************************************************************
* Form SEND_MAIL_NODIALOG
************************************************************************
form send_mail_nodialog.
call function 'SO_NEW_DOCUMENT_SEND_API1'
exporting
document_data = maildata
<b> document_type = 'HTM'</b>
put_in_outbox = 'X'
tables
object_header = mailtxt
object_content = mailtxt
receivers = mailrec
exceptions
too_many_receivers = 1
document_not_sent = 2
document_type_not_exist = 3
operation_no_authorization = 4
parameter_error = 5
x_error = 6
enqueue_error = 7
others = 8.
if sy-subrc <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
* WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
endif.
endform.
Regards,
Rich Heilman
- SAP Managed Tags:
Here is some sample HTML code for displaying a table, All you need to do is replace the text with your values. That's it. This table has 3 rows with 5 columns.
<table width="75%" border="1">
<tr>
<td width="20%">This is cell 1 1</td>
<td width="20%">This is cell 1 2</td>
<td width="20%">This is cell 1 3</td>
<td width="20%">This is cell 1 4</td>
<td width="20%">This is cell 1 5</td>
</tr>
<tr>
<td width="20%">This is cell 2 1</td>
<td width="20%">This is cell 2 2</td>
<td width="20%">This is cell 2 3</td>
<td width="20%">This is cell 2 4</td>
<td width="20%">This is cell 2 5</td>
</tr>
<tr>
<td width="20%">This is cell 3 1</td>
<td width="20%">This is cell 3 2</td>
<td width="20%">This is cell 3 3</td>
<td width="20%">This is cell 3 4</td>
<td width="20%">This is cell 3 5</td>
</tr>
</table>
Regards,
Rich Heilman
- SAP Managed Tags:
