Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

internal table data to be mailed directly in excel format

Former Member
0 Kudos

hi,

i have a requirement that :

"i want internal table data to be mailed directly in excel format"

5 REPLIES 5

Former Member
0 Kudos

Hi,

What exactely u need...Wts ur Requirement?

0 Kudos

let me tell my requirement in detail,

i have some data in internal table and i want to send this data through mail in excel format.

Former Member
0 Kudos

Send mail

maildata-obj_name = 'TEST'.

maildata-obj_descr = 'Test Subject'.

loop at htmllines.

mailtxt = htmllines.

append mailtxt.

endloop.

mailrec-receiver = 'your receiver mail id'.

mailrec-rec_type = 'U'.

append mailrec.

call function 'SO_NEW_DOCUMENT_SEND_API1'

exporting

document_data = maildata

document_type = 'EXL'

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.

Regards,

Naresh

Former Member
0 Kudos

Hi Rahul,

Check this one:

Regards,

Chandra Sekhar

Former Member
0 Kudos

thanks