topic Table in an e-mail in Application Development and Automation Discussions

topic Table in an e-mail in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/table-in-an-e-mail/m-p/1939059#M388008 <HTML><HEAD></HEAD><BODY><P>And one more thing, i have to send that table in an e-mail body itself, not as an attachment. </P><P>Please suggest as soon as possible</P></BODY></HTML> Mon, 26 Feb 2007 05:14:06 GMT Former Member 2007-02-26T05:14:06Z Table in an e-mail https://community.sap.com/t5/application-development-and-automation-discussions/table-in-an-e-mail/m-p/1939059#M388008 <HTML><HEAD></HEAD><BODY><P>And one more thing, i have to send that table in an e-mail body itself, not as an attachment. </P><P>Please suggest as soon as possible</P></BODY></HTML> Mon, 26 Feb 2007 05:14:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-in-an-e-mail/m-p/1939059#M388008 Former Member 2007-02-26T05:14:06Z Re: Table in an e-mail https://community.sap.com/t5/application-development-and-automation-discussions/table-in-an-e-mail/m-p/1939060#M388009 <HTML><HEAD></HEAD><BODY><P>Use SO_NEW_DOCUMENT_SEND_API1 and put the internal table name into object_content:</P><P></P><PRE><CODE> DATA: i_email_body LIKE solisti1 OCCURS 0 WITH HEADER LINE, i_reclist LIKE somlreci1 OCCURS 1 WITH HEADER LINE, doc_data LIKE sodocchgi1. <fill in tables i_reclist, i_email_body> CALL FUNCTION 'SO_NEW_DOCUMENT_SEND_API1' EXPORTING document_data = doc_data commit_work = 'X' TABLES object_content = i_email_body receivers = i_reclist</CODE></PRE><P></P></BODY></HTML> Fri, 02 Mar 2007 17:11:59 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-in-an-e-mail/m-p/1939060#M388009 Jelena_Perfiljeva 2007-03-02T17:11:59Z Re: Table in an e-mail https://community.sap.com/t5/application-development-and-automation-discussions/table-in-an-e-mail/m-p/1939061#M388010 <HTML><HEAD></HEAD><BODY><P>Follow the link and you can send the table as an excel sheet attachment.</P><P></P><P><A href="https://wiki.sdn.sap.com/wiki/display/Snippets/Email" target="test_blank">https://wiki.sdn.sap.com/wiki/display/Snippets/Email</A><EM>from</EM>SAP</P></BODY></HTML> Fri, 02 Mar 2007 17:21:13 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-in-an-e-mail/m-p/1939061#M388010 Former Member 2007-03-02T17:21:13Z Re: Table in an e-mail https://community.sap.com/t5/application-development-and-automation-discussions/table-in-an-e-mail/m-p/1939062#M388011 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check this example..</P><P></P><UL><LI level="1" type="ul"><P>Declarations.</P></LI></UL><P>PARAMETERS: p_email(50) LOWER CASE.</P><P></P><P>DATA: document_data LIKE sodocchgi1.</P><P>DATA: t_content LIKE STANDARD TABLE OF solisti1.</P><P>DATA: s_content LIKE solisti1.</P><P>DATA: t_receivers LIKE STANDARD TABLE OF somlreci1.</P><P>DATA: s_receivers LIKE somlreci1.</P><P></P><P>START-OF-SELECTION.</P><P></P><UL><LI level="1" type="ul"><P>Receivers.</P></LI></UL><P> s_receivers-receiver = p_email.</P><P> s_receivers-rec_type = 'U'.</P><P> s_receivers-express = 'X'.</P><P> APPEND s_receivers TO t_receivers.</P><P></P><UL><LI level="1" type="ul"><P>Subject</P></LI></UL><P> document_data-obj_descr = 'New mail from Sap'.</P><P></P><UL><LI level="1" type="ul"><P>Body</P></LI></UL><P> s_content = 'Hi,'.</P><P> APPEND s_content TO t_content.</P><P></P><P> CLEAR: s_content.</P><P> APPEND s_content TO t_content.</P><P></P><P> s_content = 'Test email from sap, please don''t reply to this email'.</P><P> APPEND s_content TO t_content.</P><P></P><P> CLEAR: s_content.</P><P> APPEND s_content TO t_content.</P><P></P><P> s_content = 'Thanks,'.</P><P> APPEND s_content TO t_content.</P><P></P><P> s_content = 'Naren.'.</P><P> APPEND s_content TO t_content.</P><P></P><UL><LI level="1" type="ul"><P>Send the email.</P></LI></UL><P> CALL FUNCTION 'SO_NEW_DOCUMENT_SEND_API1'</P><P> EXPORTING</P><P> document_data = document_data</P><P> TABLES</P><P> object_content = t_content</P><P> receivers = t_receivers</P><P> EXCEPTIONS</P><P> too_many_receivers = 1</P><P> document_not_sent = 2</P><P> document_type_not_exist = 3</P><P> operation_no_authorization = 4</P><P> parameter_error = 5</P><P> x_error = 6</P><P> enqueue_error = 7</P><P> OTHERS = 8.</P><P> IF sy-subrc <> 0.</P><P> MESSAGE e208(00) WITH 'Error in sending email :-(('.</P><P> ELSE.</P><P> MESSAGE s208(00) WITH 'Email sent <SPAN __jive_emoticon_name="happy"></SPAN>)'.</P><P> ENDIF.</P><P></P><P> SUBMIT rsconn01 WITH mode = 'INT' AND RETURN.</P><P></P><P></P><P></P><P>Thanks,</P><P>Naren</P></BODY></HTML> Fri, 02 Mar 2007 17:28:47 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-in-an-e-mail/m-p/1939062#M388011 Former Member 2007-03-02T17:28:47Z Re: Table in an e-mail https://community.sap.com/t5/application-development-and-automation-discussions/table-in-an-e-mail/m-p/1939063#M388012 <HTML><HEAD></HEAD><BODY><P>The easiest solution is to write the table to a list display, save the list, convert to HTML and then pass this to the SEND function module. There are others ways, including embeding your own HTML, so that you can format it the way you want.</P><P></P><PRE><CODE> report zrich_0003 . data: imara type table of mara with header line. data: list type table of abaplist with header line. data: htmllines type table of w3html with header line. 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. * Get the data and write the list. select * into table imara from mara up to 100 rows. loop at imara. write:/ imara-matnr, imara-ersda, imara-mtart, imara-matkl, imara-groes. endloop. * Save the list call function 'SAVE_LIST' tables listobject = list exceptions list_index_invalid = 1 others = 2. * Convert it to HTML call function 'WWW_LIST_TO_HTML' tables html = htmllines. * Send the mail perform send_mail_nodialog.. * Forget about the list output. leave list-processing. ************************************************************************ * Form SEND_MAIL_NODIALOG ************************************************************************ form send_mail_nodialog. maildata-obj_name = 'TEST'. maildata-obj_descr = 'Test Subject'. loop at htmllines. mailtxt = htmllines. append mailtxt. endloop. mailrec-receiver = 'you@yourcompany.com'. mailrec-rec_type = 'U'. append mailrec. call function 'SO_NEW_DOCUMENT_SEND_API1' exporting document_data = maildata document_type = 'HTM' 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. </CODE></PRE><P></P><P>Regards,</P><P>Rich Heilman</P></BODY></HTML> Fri, 02 Mar 2007 17:30:54 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-in-an-e-mail/m-p/1939063#M388012 RichHeilman 2007-03-02T17:30:54Z