Generate a PDF and attach it to an email
Posted on 2012-03-13
A client of mine is using VFP 7. They had a request from one of their clients to send an email with the invoice attached in PDF format.
This will have to be accomplished form with the existing FoxPro app. For another purpose we already have logic in the Foxpro app to generate an email from within Foxpro(VFP) and attach a file or files to the email. The real question here is how to do it with a PDF.
We have played with CutePDF and successfully created a PDF from FoxPro. With the free version of CutePDF the process is cumbersome and not acceptable. Each time a PDF is being created you have to name it and tell the system where to put it. For this process to work in production it has to flow without prompting. We purchased the $50 version of CutePDF and that didn't have the functionality that we were looking for. A call to tech support had them suggesting that we buy the $500 version of CutePDF. At that point we stopped. Time to investigate alternatives or at least verify with non-CutePDF employees that the $500 version will accomplish what we want it to.
Ideally the application would know where (which directory) to put the generated PDF and would fabricate a name of the file based on the client name, date etc.. Once the PDF was generated the app would create an email, attach the PDF file it just created and then move to the next invoice to do the same thing.
Has anyone worked with the pricey version of CutePDF to know whether it will accomplish our goals.
Even if it will, are their alternatives to creating PDF's from VFP that allow the app to direct the generated PDF to a specific directory with a specific file name?