Skip to Content

After sending attachment through mail using ABAP program.....

Hello Experts,

I am facing a problem to fulfill a requirement.

My requirement is....sending the data of the internal table to an external mail with attachment(excel format). I have done with this. But when o am opening the excel sheet(attachment) it is showing a message that 'The file you are trying to open is in different format than specified by the file extension'

I am using the extension 'XLS' and 'RAW ' in the coding for the file formats.

You can please suggest your solutions if you know or already faced this type of issues.

Thank you.

Regards,

Anand

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Posted on Jun 09, 2014 at 07:06 AM

    Hi,

    The system does not trust you....😉

    I have the feeling that the file you are sending is a text file with the extension 'XLS'

    If the file is comma separated values (http://en.wikipedia.org/wiki/Comma-separated_values) then

    use the extension 'CSV' if it is a tab separated then use the extension 'TXT' .


    Regards.

    CSV is also good for tab separated I just checked by a copy of BCS_EXAMPLE_7 and changing: i_attachment_type = 'CSV' "#EC NOTEXT

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 09, 2014 at 07:14 AM

    Hi

    Please check this program BCS_EXAMPLE_7 which has all the code and try to execute and check if you get same error when you this file

    Nabheet

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 09, 2014 at 06:45 AM

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 09, 2014 at 07:21 AM

    Hello Anand,

    The Messae that you are getting while opening to the EXCEL, it is ok.

    This same message you will get when you will download the table content from a table into a spreadsheet.

    For e.g. go SE16 download the table VBAP entries using the download button.

    Thanks

    Gaurav

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 09, 2014 at 07:25 AM

    Hi,

    did you check it in the system MS Office software ,

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 09, 2014 at 07:34 AM

    Hi,

    The file might be in XLS format but the version of microsoft excel is different. The system on which you are opening the excel might have higher i.e latest version. So it's giving system message. But it will not harm the content of the excel sheet.

    Regards,

    Pravin

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.