Skip to Content
author's profile photo Former Member
Former Member

query about excel email functionality

Hi,

I'm using this FM SO_NEW_DOCUMENT_ATT_SEND_API1 to send excel file as attachment to external emails.

the problem is that in development & quality system the excel attachment is going properly, but in production the excel file is getting hugely misaligned. Is there some other configuration required in this regards to facilitate this. Thanks in advance for the suggestions.

Regards,

Vijay

(P.S - Please don't copy paste code here)

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 04, 2006 at 06:47 AM

    Hi friend,

    For data to be properly alligned in the Excel file you need to format the data with some characters like,

    '09' - for tab

    '0D' - for next line etc.,

    Try to concatenate these characters with the fields that you pass to the excel file...

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I've done this 09 and 0D thing. That's what I said - It's working properly in development and quality. But only in PRD I'm having this problem.

      Has anybody faced this problem.

      Regards,

      Vijay

  • author's profile photo Former Member
    Former Member
    Posted on Aug 04, 2006 at 06:46 AM

    it should not come like that. any way try to do this.

    as you mentioned the attachment is an Excel file,

    just concatenate each field with a ' (aphostrophe). in excel it you say any field '0001232 , means its takes as character & will be by default LEFT-ALLIGNED.

    try this out.

    for ex:

    concatenate ''''

    v_field1

    into v_field2.

    if v_field1 is 123 , after that that willbe '123.

    so in excel, the value will be treated as character(as the value is preceded with a ' ) and left aligned.

    regards

    srikanth

    Add comment
    10|10000 characters needed characters exceeded