To send Excel Options in mail...

[Former Member]

Hi all ,

Have requerment to send excel options in mail but data in row having more than 225 characater ,have using the method name

CL_DOCUMENT_BCS=>CREATE_DOCUMENT please guide me send more number character in a rows .

Regards,

santosh.

[former_member183990]

hi santosh

greetings for the day

FYI link

http://forums.sdn.sap.com/search.jspa?q=CL_DOCUMENT_BCS

cheers

S.Janagar

[Former Member]

My dear S.Janagar,

Know to send using this method ,My question My data in row having more than 225 characater using this method or any other method is there to send mail which can fit more than 225 character in excel and send mail .

Please Guide me

Regards,

Santosh

[former_member183990]

hi santhosh

there are lot of questions that has been previously posted by previous users

see the below

http://www.sdn.sap.com/irj/scn/advancedsearch?query=emailwithmorethan255+char

in this one such thread is

read the answer given by thomas jung

answer given by dileep kumar

and try to search for that

please posting

cheers

S.Janagar

Edited by: Janagar Sundaramoorthy Nadar on Apr 12, 2010 7:28 AM

[Former Member]

Dear S.Janagar,

i check all the blogs but am not able understand ,Can please send sample code it will helpfull for me.....

Regards,

santosh

Edited by: santosh jajur on Apr 12, 2010 2:34 PM

Edited by: santosh jajur on Apr 12, 2010 2:52 PM

[Former Member]

Santhosh,

Change the data type of that field to some 400.

Thats the simple solution.

Thanks.

[Former Member]

Dear Viji,

Send attachment through standard function module or methods ,how it possable to change the data length fields,

regards,

santosh

[Rocky1]

Hi Santosh,

You can send data with length greater than 255 character to the excel sheet as an attachment but the data will be displayed in the next line in the excel sheet.I think, Its not possible to display data greater than 255 characters in single line in the excel sheet via mail. For this you can use the following logic:

  CLEAR lv_success_attach.

*adding line feed for every row in success table for sending attachment through mail.

  CONCATENATE  lc_con_cret      " lc_con_cret    TYPE c      VALUE cl_abap_char_utilities=>cr_lf.
                             lv_success      "single row 
                   INTO  lv_success_attach.

  lv_length = c_length.  "255
  lv_offset = c_offset.  "0

  lv_strlen = STRLEN( lv_success_attach ).

* dividing every row into 255 characters
"This loop will run more than once if the data in a single row is greater than 255 characters
  DO.

    IF lv_strlen LT c_length.
      lv_length = lv_strlen.
    ENDIF.

    wa_success_attach1 = lv_success_attach+lv_offset(lv_length).
    APPEND wa_success_attach1 TO it_success_attach1.
    CLEAR  wa_success_attach1.

    lv_offset = lv_offset + lv_length.
    lv_strlen = lv_strlen - lv_length.
    IF lv_strlen = 0.
      EXIT.
    ENDIF.
  ENDDO.

Hope it will help you. If it is not clear, please feel free to post queries. I will try to explain it to you.

Thanks & Regards

Rocky

[Former Member]

Dear Rocky,

Thanks for the Suggestion ,Have different question need to send excel file attachment in color format in mail ,please can guide me how to due it and if its possable please send the code..

Regards,

santhu

Edited by: santosh jajur on Apr 13, 2010 9:45 AM