Skip to Content
avatar image
Former Member

internal table data to be mailed directly in excel format

hi,

i have a requirement that :

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Sep 01, 2008 at 09:03 AM

    Hi,

    What exactely u need...Wts ur Requirement?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • avatar image
    Former Member
    Sep 01, 2008 at 11:10 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 01, 2008 at 11:14 AM

    Hi Rahul,

    Check this one:

    excel sheet as an attachment to the mail box

    Regards,

    Chandra Sekhar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 17, 2008 at 01:05 PM

    thanks

    Add comment
    10|10000 characters needed characters exceeded