topic Re: Sending email from batch job in Application Development and Automation Discussions

Sending email from batch job

former_member66888 — Thu, 22 Nov 2007 07:15:05 GMT

Hi,

I'm trying to send the report output from a SAP Query (SQ01) to a email address.

If the output format of my report is in ABAP List, the htm file i receive in my inbox is formatted correctly. However, if my report is in ALV format, then the attachment in my inbox contains pernr in all columns i.e., all columns are nod displayed with the actual data but rather, with the first column repeated 8 times.

Can anyone help resolve this issue.

Alternatively, is it possible to create an excel attachment from the job sceduler (SM36) and send that in email?

Thanks

Re: Sending email from batch job

Former Member — Thu, 22 Nov 2007 14:08:08 GMT

Hi,

You can send the output spool of the completed job.

For this select the job and click on the spppl button. Now goto the menu spool request and select Forward-> send using SAP office.

Make sure that the recipient also have a valid mail id maintained in the user master (SU01) as INT type.

Hope this helps you.

Regards,

Subbu.

Re: Sending email from batch job

former_member66888 — Tue, 27 Nov 2007 15:17:58 GMT

Actually, the idea was to automate the dispatch of email. It should go out automatically every month w/o human intervention.

Did manage to do that. It's just that when the report output format is alv, the email attachment contains just one column. I was wondering what the reason for this is and if there is a remedy.

thanks