Send an e-mail with attachment

[Former Member]

Hello Experts

I have created one ALV report.

Now, my requirement is that

1. While selecting one checkbox (Send e-mail), I want to send e-mail while running this report in background.

2. Report should be Excel or text as an attachment of e-mail

Can we do that?

Points will be awarder immediately.

Regards

n.master

[Former Member]

Hello Experts

I have created one ALV report.

Now, my requirement is that

1. While selecting one checkbox (Send e-mail), I want to send e-mail while running this report in background.

2. Report should be Excel or text as an attachment of e-mail

Can we do that?

Points will be awarder immediately.

Regards

n.master

[Former Member]

hi,

the following threads will help you

/thread/98781 [original link is broken]

regards,

pavan

[Former Member]

Hi,

you can do so using the function module

'SO_NEW_DOCUMENT_SEND_API1'

Regards,

siva chalasani.

[Former Member]

Hi,

1.First download ur result into a file in required format specify the file type.

2.Then use FM 'Z_SAP_MAIL_TO_SMTP_ATTACHEMENT'

to send the OP of Report as an attachment of e-mail,

Specify The DLI name(Distribution List).

i_filewithpath = Downloaded file name.

Thanks,

Kishore

[Former Member]

Create spool in background using Print On and print Off statements.

In same program

Use FM

CONVERT_ABAPSPOOLJOB_2_PDF

to convert spool to PDF file or use FM RSPO_SPOOLDATA_TO_TEXT to convert spool to text file.

For sending an email, it will depend on your system how it has been configured to send outbound emails.

example : Few systems has UNIX script running at regular time interval which will check all files in specific format on Application server and send it externally. This requires you to write files on application server in specific format. (Need to make entry in table T9AOEMAIL)

[Former Member]

I have solved this question.

[Former Member]

Hi dear,

In u r report program call "ZSND_AGN_EMAIL"

this function module directly. It will take careof

sending the email.

If it is appropriate reward me the points.

Regards

Ashok.

[Former Member]

Thanks