send mail to different customer from one spool request

[Former Member]

Hi Friens,

i am doing a customer statement of account script which creates one spool request for some range of customer under one company code. now i want to convert the spool request in to pdf and send mail to the customers with relevant pdf attachments. how to split the pdf file according to the customer. for example under one company code having 10 customers all their statement should create under one spool request number and then i have to send mail to them with only their account statement. points will be rewarded for the best solution.

Thanks & Regards,

Ashok

[Former Member · Accepted solution]

split ur schedule job ? otherwise create a new program to run that many times ?

u cannt work around with Spoool data , u can do it before getting the data.

flow will be like this

1.get all the customers based on the selections

2. loop at itab.

at new kunnr.

submit form.

endloop.

3. get all spoool created in the above step, then convert into PDF

Regards

Prabhu

[Former Member · Accepted solution]

Hi ,

yes now i am doing similar to your tips.i am directly converting otf to pdf and send mail.But every time i don't want to see the print preview pop up window.Because after i press the print preview button then only it will execute. how to hide the pop up window and directly convert the otf to pdf.Pls answer me as soon as possibl.

thanks,

Ashok

[Former Member · Accepted solution]

check options of open_form i.e ITCPO , there u will get option to skip printpreview.

Regards

Prabhu

[Former Member · Accepted solution]

Hi Prabhu,

Thanks for your support. yes i got it.

in open_form i use dialog = ' '.( default is 'X')

Now problem solved.

regards

Ashok

[Former Member · Accepted solution]

hi Madhu,

Can you please help me on this? I have the same senario.

There is a spool generated with multiple invoices & I have to send it to diffrent-2 customers.

If possible please share the code.

Thanks,

Girdhar A.

Edited by: Girdhar Agrawal on Sep 6, 2010 9:05 AM