SO_DOCUMENT_SEND_API1 Emailing XLSX File

[andrewscott9]

Hi there,

I am trying to use the FM SO_DOCUMENT_SEND_API1 to email a XLSX file attachment, but it isn't working. It would appear the file extension only allows 3 characters. I want to be able to pass 'XLSX'

It works fine with 'XLS' but get the format error when users try to open the attachment

Any ideas how I can send XLSX?

[andrewscott9]

Hi there,

I am trying to use the FM SO_DOCUMENT_SEND_API1 to email a XLSX file attachment, but it isn't working. It would appear the file extension only allows 3 characters. I want to be able to pass 'XLSX'

It works fine with 'XLS' but get the format error when users try to open the attachment

Any ideas how I can send XLSX?

[abo]

It would help if you added the relevant bits of your code 🙂

Anyhow, this question has probably been asked before and this might be a good answer.

[Sandra_Rossi]

It has been asked many times, last time was last week.

[matt]

Don't use the FM. Use the CL_BCS... classes. Far easier to use and less problematic.

[andrewscott9]

The reason I ask this question is that I have searched for some help and everything is pointing towards object oriented code. I have absolutely no idea about this coding technique. I'm old school and would prefer if it was possible to provide a solution in normal ABAP code.

Is there such a solution? I'm hoping so 🙂

[FredericGirod]

andy.scott3 : no

It is a good day to test ABAP Object, and when you will try it, you never want to come back to not-normal abap programming

[andrewscott9]

Unfortunately my good friend I dont hve the time to learn OO

[matt]

It's no more OO than using a FM. You create objects and call their methods. No OO concepts needed. Take the time to read the blogs and learn.

You do not have time to use obsolete function modules that are inflexible and difficult to use.

[matt]

Time spent in learning better techniques ALWAYS results in saving time in the long run. Also makes you more employable. I certainly wouldn't recruit anyone who didn't know how to use CL_BCS, CL_SALV_TABLE etc. Because knowledge and experience of these makes for faster more robust developments. And therefore saves the employer money.

[andrewscott9]

Thanks for you suggestions but I'm a bit long in the tooth for that. I'm hoping to retire next year!! Thats how old I am

[Sandra_Rossi]

I don't find the answer posted last week which concerned &SO_FILENAME.

And generally speaking, I don't see any code in the Web for your function module but the trick is to define &SO_FILENAME=filename.xlsx in the header parameter.