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
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
Add a comment