topic Re: convert spool request to HTML in Application Development and Automation Discussions

convert spool request to HTML

Former Member — Tue, 24 Nov 2009 13:31:20 GMT

Hello,

I have got a spool request no.

Now I need to send this data from spool to external recipient address as a HTML attachment.

Kindly suggest me which function modules I should use?

Regards,

Krutika

Re: convert spool request to HTML

Former Member — Tue, 24 Nov 2009 13:44:15 GMT

Hi ,

try thsi way..

Fetching Spool data into internal table

CALL FUNCTION 'RSPO_RETURN_ABAP_SPOOLJOB'

EXPORTING

rqident = p_spool "Pass spool Number

TABLES

buffer = t_mail_data.

then pass the Internal table data to below function module tables ITABLE then it will return HTML table with HTML format

WWW_ITAB_TO_HTML

Regards,

Prabhudas

Re: convert spool request to HTML

Rocky1 — Tue, 24 Nov 2009 14:05:08 GMT

Hi,

Plz chk Hope it helps u.

Thanks & Regards

Rocky

Re: convert spool request to HTML

Former Member — Thu, 26 Nov 2009 04:51:27 GMT

Hi,

Thanks for your help.

Can you pls guide me on how to convert spool data in the form of list report into excel format to send the mail to reciever?

I have used 'RSPO_RETURN_SPOOLJOB' to convert spool data to internal table & then 'SO_DOCUMENT_SEND_API1' to send a mail to extrenal address. But data is sent in Text file format.

But users want mail report in excel format.

Kindly help with this.

Is there any other function module whic Ican use to convert spool data to excel format.

Regards,

Krutika

Re: convert spool request to HTML

Former Member — Thu, 26 Nov 2009 04:58:07 GMT

Hello,

Converting spool to excel could be messy and the formatting will be lost. If you could convince your users to have a pdf attachment instead of excel, your task will be very easy.

Vikranth

Re: convert spool request to HTML

Former Member — Thu, 26 Nov 2009 05:54:13 GMT

Hi,

While preparing the packing list, the doc_type parameter should be 'HTM'. If you are using it as RAW then it will send mail in text format.

Thanks

Papiya

Re: convert spool request to HTML

Former Member — Thu, 26 Nov 2009 08:39:15 GMT

Hi,

Actually the the data is a report data which cannot be usefull if sent in PDF format , as it contains tables entries.

Hnece I have to send it in EXCEL fomrat.

Kindly help.

Regards,

Krutika

Re: convert spool request to HTML

Former Member — Wed, 02 Dec 2009 05:27:00 GMT

Hi,

Thnkx for ur help.

Can u pls tell me, the document size calculated in FM SO_DOCUMENT_SEND_API1 is in bytes or is in charecters?

I need to calculate the file size in bytes.

Regards,

Krutika

Re: convert spool request to HTML

Former Member — Fri, 04 Dec 2009 06:45:33 GMT

solved.....