convert spool request to HTML

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Rocky1]

Hi,

Plz chk Hope it helps u.

Thanks & Regards

Rocky

[Former Member]

solved.....