Submitted by Kent on Tue, 03/13/2012 - 09:40
Forums
InterForm

Hi,

We currently have some reports that we have designed overlays for in Interform, we use finishing definitions (prepare for e-mail) to find keys in the spool and use a exitprogram to find what e-mail adresses to send the e-mail with attatched PDF too.

We would like to be able to do the same thing for our Interxel overlays that we have created.

So is it possible to use the same solution?

If possible:

How do we set up the AFC to select the XLS "overlay" instead?
How do we send the attached XLS file in Interform (Can only find options to send PDF) ?

If not possible:
What would be the best soloution for this?

Br
Kent

Leif Jacobsen

Tue, 03/13/2012 - 13:40

Permalink

Hi Kent

In the e-mail defintion, you can attach an extra file (InterFormVer2011), if you want to send the XLS file along with the PDF file.

Otherwise you can send the XLS file from the AFC job using a function "8 = Call Program".

In the manual there is a detailed description on page 32.

http://www.system-method.com/sites/default/files/InterForm/manual/Interexcel2011.pdf

 

Rgs

Leif Jacobsen

Thanks for the quick response Leif,

What I was hoping for was to have the same solution for XLS as for the PDF attachments. Where we are using the e-mail finishing definitions to find key fields in the spool, calling an exit program that finds the e-mail addresses depending on the keys (the nice thing is that the files are also automatically split).

I guess to have the same possibility for the XLS file we have to first create a split program, having a e-mail finishing definition with a exit program call and convert the file to XLS. Afterwards we send both the PDF and the XLS as attatchments?

Our Wishes:

Would be to have is the same solution for PDF and XLS. Using an E-mail Finishing definition to take keys from the spool and call exit program.

Hi Kent

Unfortunately, it is not possible to use the e-mail definition for that purpose. However, it's a good idea, and I will create a development project at InterForm. 

Instead you can use the split function, and an exit pgm to e-mail the XLS files. You can re-use your e-mail code in the split pgm.

If you use exit parameter 1 in the split pgm, the spool file will be automatically splitted, if there is a change in that line/position.

Rgs

Leif Jacobsen