hi

[Former Member]

I want to send the report output through mail, which function module i can use, or is there any other way to send the report output via mail? report contains selection screen also.

Thanks

[Former Member]

You can use fm 'SO_NEW_DOCUMENT_ATT_SEND_API1'

[amit_khare]

Report Output through mail.-

Regards,

Amit

Reward all helpful replies.

[Former Member]

check this links it may help you...

http://www.geocities.com/mpioud/Z_EMAIL_ABAP_REPORT.html

http://www.thespot4sap.com/Articles/SAP_Mail_SO_Object_Send.asp

http://www.sapdevelopment.co.uk/reporting/email/attach_xls.htm

**********************************

sample code....but above links help u lot i guess...!!!!

&----

---

*& Report ZSENDEMAIL *

*& *

&----

---

*& Example of sending external email via SAPCONNECT *

*& *

&----

---

REPORT zsendemail .

PARAMETERS: psubject(40) type c default 'Testing',

p_email(40) type c default '[email protected]'.

data: it_packing_list like sopcklsti1 occurs 0 with header line,

it_contents like solisti1 occurs 0 with header line,

it_receivers like somlreci1 occurs 0 with header line,

it_attachment like solisti1 occurs 0 with header line,

gd_cnt type i,

gd_sent_all(1) type c,

gd_doc_data like sodocchgi1,

gd_error type sy-subrc.

data: it_message type standard table of SOLISTI1 initial size 0

with header line.

***********************************************************************

*START-OF-SELECTION.

START-OF-SELECTION.

Perform populate_message_table.

*Send email message, although is not sent from SAP until mail send

*program has been executed(rsconn01)

PERFORM send_email_message.

*Instructs mail send program for SAPCONNECT to send email(rsconn01)

perform initiate_mail_execute_program.

&----

---

*& Form POPULATE_MESSAGE_TABLE

&----

---

• Adds text to email text table

----

---

form populate_message_table.

Append 'Line1' to it_message.

Append 'Line2' to it_message.

Append 'Line3' to it_message.

Append 'Test- 1' to it_message.

endform. " POPULATE_MESSAGE_TABLE

&----

---

*& Form SEND_EMAIL_MESSAGE

&----

---

• Send email message

----

---

form send_email_message.

• Fill the document data.

gd_doc_data-doc_size = 1.

• Populate the subject/generic message attributes

gd_doc_data-obj_langu = sy-langu.

gd_doc_data-obj_name = 'SAPRPT'.

gd_doc_data-obj_descr = psubject.

gd_doc_data-sensitivty = 'F'.

• Describe the body of the message

• Information about structure of data tables

clear it_packing_list.

refresh it_packing_list.

it_packing_list-transf_bin = space.

it_packing_list-head_start = 1.

it_packing_list-head_num = 0.

it_packing_list-body_start = 1.

describe table it_message lines it_packing_list-body_num.

it_packing_list-doc_type = 'RAW'.

append it_packing_list.

• Add the recipients email address

clear it_receivers.

refresh it_receivers.

it_receivers-receiver = p_email.

it_receivers-rec_type = 'U'.

append it_receivers.

• Call the FM to post the message to SAPMAIL

call function 'SO_NEW_DOCUMENT_ATT_SEND_API1'

exporting

document_data = gd_doc_data

put_in_outbox = 'X'

importing

sent_to_all = gd_sent_all

tables

packing_list = it_packing_list

contents_txt = it_message

receivers = it_receivers

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.

• Store function module return code

gd_error = sy-subrc.

• Get it_receivers return code

loop at it_receivers.

endloop.

endform. " SEND_EMAIL_MESSAGE

*&----

---

*& Form INITIATE_MAIL_EXECUTE_PROGRAM

*&----

---

• Instructs mail send program for SAPCONNECT to send email.

*----

---

form initiate_mail_execute_program.

wait up to 2 seconds.

if gd_error eq 0.

submit rsconn01 with mode = 'INT'

with output = 'X'

and return.

endif.

endform. " INITIATE_MAIL_EXECUTE_PROGRAM

[Former Member]

Hi,

a lot of threads in this forum give answer for you question.

Search for it.

The way can be printing the output and send this spool as email.

Regards, Dieter

[JozsefSzikszai]

not necessary to use the search function...

Vasu G will come, provide (usually randomly selected...) links and sample codes on any question...

[che_eky]

Hahaha

Simple law of averages, keep providing random links and code samples and your bound to answer or two a question along the way.