Schedule job to send to external email address

[Former Member]

We wish to execute a daily report in the background and send the report to an external email. The idea is that a management report is set up to send to a senior manager every morning for the previous days data.

I can add a recipient to the background job using the Properties - Cover sheets option, but this sends a the spool file to the recipient which is not acceptable.

If I execute report in foreground (for example report FBL1N) I can then send the report to a recipient via List u2013 Send, however I cannot save this in the variant to then execute in background.

I realise this could be done using ABAP but we don't want to create a copy report for what looks like should be something that SAP can do as standard

Thanks

[Former Member · Accepted solution]

HI,

the way I do this for some daily/weekly check reports is the following:

in SAP Business workplace (T-code SBWP) create a distribution list for the external email-adress (in the distribution list content key in the email-adress in "recipient" and as "recipient type" set "via internet").

In SM37 job scheduling schedule the job for the time it should be executed and as "spool list recipient" add the distribution list you've created before.

Try this with your own external email-adress first to see the result.

Best regards, Christian

[Former Member · Accepted solution]

Thanks

That's worked

Edited by: Richard Somerset on Jul 23, 2009 10:30 AM

[Former Member · Accepted solution]

I need to schedule a job every day for prevous days data. I have set up the vairant ot use posting date -1.

So I can add email address I need to schedule the daily job in SM37. However this will call the variant set up for the original job but I need to call the variant in the program sio that the posting date is advanced.

Is there anyway to add distribution list to the scehduled job wehn executed from the report and not from SM37?

[former_member581688 · Accepted solution]

If you schedule a daily job via SM36 and assign the variant you created with the dynamic date calculation of posting date-1, each day's job will calculate the date to use based on the variant. So today's job will use yesterday's date, tomorrow's job will use today's date and so forth with each day's job using the previous day's date. You can also assign the distribution list to the job in SM36.

Regards,

Shannon

[Former Member · Accepted solution]

I'll try that thanks

[former_member373850 · Accepted solution]

Dear Christain

Is there a way to have Email main body in the above issue.

I was able to generate the mail n attachment is coming.

But I am not able to open the attachment as PDF.

Also I an not able to add Email main body text like:

Dear Sir/Madam,

Please find attached......

Prompt reply is appreciated.

Regards

Naman Shah

[martin_badik · Accepted solution]

Is it possible to save to local disk (instead of email)?

Thanks