topic Re: After sending attachment through mail using ABAP program..... in Application Development and Automation Discussions

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

Former Member — Mon, 09 Jun 2014 06:27:14 GMT

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

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

Former Member — Mon, 09 Jun 2014 06:45:37 GMT

This message was moderated.

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

rosenberg_eitan — Mon, 09 Jun 2014 07:06:45 GMT

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

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

nabheetscn — Mon, 09 Jun 2014 07:14:03 GMT

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

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

Former Member — Mon, 09 Jun 2014 07:21:57 GMT

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

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

Former Member — Mon, 09 Jun 2014 07:25:15 GMT

Hi,

did you check it in the system MS Office software ,

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

Former Member — Mon, 09 Jun 2014 07:34:22 GMT

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

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

Former Member — Mon, 09 Jun 2014 09:53:09 GMT

File format is governed by the specification and it does not depend on viewer/editor program version.