How to send mail 100 & more records of an internal table as excel or Pfd

[Former Member]

Hi all,

Can any one help me out how to mail the recodrs of an internal table having more than 100 records.

forums are explaining basically about the records of 255 character only but we have requirement of mailing the whole report data.

Or is any other ABAP program is available for mailing the data of the report as excel or PDF sheet.

if program is available please help

Thanks

Rajeev

Edited by: Rajeev Shrivastava on Aug 24, 2009 7:06 AM

[Former Member]

Hi,

Please check out this link.

http://www.sap-img.com/abap/sending-email-with-attachment.htm

Regards,

Subhashini

[Former Member]

Hi,

How should I send the whole records of the Internal Table ???

Thanks

Rajeev

[Former Member]

Hi,

You can save the data in excel sheet and use it as an attachment in your mail right?

Regards,

Subhashini

[Former Member]

Hi Rajeev,

You can use the spool request which can be converted in excel or pdf and send across on e-mail.

Refer following links :

https://wiki.sdn.sap.com/wiki/display/Snippets/Convert%20Spool%20request%20to%20PDF%20and%20send%20a...

Regards,

Vivek

[Former Member]

Hi Vivek,

Firstly thanks..Your Ans r really help ful.

but I still have some query,

How should I take the numeric & float values..because In one of my report there is Arrear which like this 23419.90.

but its taking only character type..

please help

Thanks

Rajeev

Edited by: Rajeev Shrivastava on Aug 24, 2009 9:28 AM

Edited by: Rajeev Shrivastava on Aug 24, 2009 9:38 AM

[Former Member]

and please also elaborate ..how should I the create the spool request of the records of Internal table.

Thanks

Rajeev

Edited by: Rajeev Shrivastava on Aug 24, 2009 9:28 AM

Edited by: Rajeev Shrivastava on Aug 24, 2009 9:50 AM

[Former Member]

Hi Rajeev,

Refer following :

All numeric and date data will be transfered as Char only to excel or pdf.

Regards,

Vivek

[Former Member]

HI vivek,

One more question ..

How should I add the sender address for the prgoram which is sending the excel sheet as attachment.???

Thanks

Rajeev

Edited by: Rajeev Shrivastava on Aug 24, 2009 12:28 PM

Edited by: Rajeev Shrivastava on Aug 24, 2009 1:14 PM

[Former Member]

Hi,

Do the following settings to add reciever address:

wa_receivers-receiver = so_malid-low.

wa_receivers-rec_id = so_malid-low.

wa_receivers-rec_type = 'U'.

wa_receivers-com_type = 'INT'.

wa_receivers-notif_del = 'X'.

wa_receivers-notif_ndel = 'X'.

APPEND wa_receivers TO gi_receivers.

and to set the sender address:

CALL FUNCTION 'SO_DOCUMENT_SEND_API1'

EXPORTING

document_data = wa_doc_data

sender_address = gc_sender_address

sender_address_type = gc_sender_address_type

commit_work = 'X'

TABLES

packing_list = gi_packing_list

contents_txt = gi_messages

receivers = gi_receivers.

Where:

gc_sender_address TYPE soextreci1-receiver VALUE 'sender email id',

gc_sender_address_type TYPE soextreci1-adr_typ VALUE 'INT'.

Hope it helps.

Regards,

Rajesh Kumar

[Former Member]

Thanks

Issue resolved

[Former Member]

Hi,

If ur issue is resolved then you should close the thread.

Regards,

Rajesh Kumar

[Former Member]

Nothing Mate.. Just to remind for close the thread