send ALV-GRID Output as EXCEL-Attachment

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/ )

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

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.