send ALV-GRID Output as EXCEL-Attachment

[Former Member]

Hello,

i have written a Report with ALV-GRID output. This output

is via Layout-Variant an Excel-sheet.

Now my Problem: I send this output as an Attachment

to an internet-Address (name@name.de). The Attachment

is in ALI and will be change via scon to HTML.

Is it Possible to send this Attachment as an EXCEL-Attachment?

Thanks for help.

Regards, Dieter

[Former Member]

have you written the code to send mail in the program ??

by using "SO_NEW_DOCUMENT_ATT_SEND_API1" ??

if so,

IN the OBJPACK, DOC_TYPE change to XLS.

IT_OBJPACK-DOC_TYPE = 'XLS' .

regards

srikanth.

[Former Member]

Hi Srikanth,

no, it's an normal Report with GRID-output.

In the Output-Window is a Send -Button wich i use.

Regards, dieter

[Former Member]

Hai

Check the following Links

In your ALV program after the alv output is build in the program do the following steps.

1). Export the list to memory

2). Import the list from mempry

3). Do a COmpress of the data

4). Send an email as an attachment using the normal FM.

Take a look at the following links which will explain how to do the above steps.

http://www.geocities.com/mpioud/Z_EMAIL_ABAP_REPORT.html

http://www.thespot4sap.com/Articles/SAP_Mail_SO_Object_Send.asp

http://www.sapdevelopment.co.uk/reporting/email/attach_xls.htm

remember to change the doc type as 'HTM' in the FM to send email

what you could do is , replace all @xx@ with the url for the same from the BSP mime repository

(url pattern will be

http://applicationserver.domain.com:port/sap/public/bsp/sap/public/bc/icons/<icon name>)

but this would pose another issue, when the user opens the mail this would require authentication info for logging on to sap and get the MIME

Regards

Sreeni