I need to generate a batch of invoices in PDF format and then send them automatically by email I’ve been exploring the web for some meaningful code but most examples are in VB 1. I have a cursor with N invoices and all pertinent header data 2. I want to generate N PDF files with all the invoice data and sabe them to a designated folder 3. I need to email them, one by one, to the respective customers I know this has been done zillions of times but in my case I never did it for batches and would appreciate an example on: 1. How to generate the PDF files 2. How to save them in a particular folder 3. How to email them Needles to add that the solutions have to be in VFP and FREE TIA Rafael Copquin
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
I use Rick Strahl's WW Client Tools for SMTP (and other TCP/IP stuff) and XFRX for PDF generation. All VFP solutions but not free.
--
rk
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of rafael.copquin@gmail.com Sent: Tuesday, May 16, 2017 4:37 PM To: profoxtech@leafe.com Subject: generate pdf files by batch and send them by email
I need to generate a batch of invoices in PDF format and then send them automatically by email I’ve been exploring the web for some meaningful code but most examples are in VB 1. I have a cursor with N invoices and all pertinent header data 2. I want to generate N PDF files with all the invoice data and sabe them to a designated folder 3. I need to email them, one by one, to the respective customers I know this has been done zillions of times but in my case I never did it for batches and would appreciate an example on: 1. How to generate the PDF files 2. How to save them in a particular folder 3. How to email them Needles to add that the solutions have to be in VFP and FREE TIA Rafael Copquin
I've done this all with paid solutions, but FoxyPreviewer is supposed to be able to do it all:
https://foxypreviewer.codeplex.com/
On Tue, May 16, 2017 at 4:37 PM, rafael.copquin@gmail.com wrote:
I need to generate a batch of invoices in PDF format and then send them automatically by email I’ve been exploring the web for some meaningful code but most examples are in VB
- I have a cursor with N invoices and all pertinent header data
- I want to generate N PDF files with all the invoice data and sabe them to a designated folder
- I need to email them, one by one, to the respective customers
I know this has been done zillions of times but in my case I never did it for batches and would appreciate an example on:
- How to generate the PDF files
- How to save them in a particular folder
- How to email them
Needles to add that the solutions have to be in VFP and FREE TIA Rafael Copquin
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
thank you
Rafael
On 16/05/2017 17:48, Ted Roche wrote:
I've done this all with paid solutions, but FoxyPreviewer is supposed to be able to do it all:
https://foxypreviewer.codeplex.com/
On Tue, May 16, 2017 at 4:37 PM, rafael.copquin@gmail.com wrote:
I need to generate a batch of invoices in PDF format and then send them automatically by email I’ve been exploring the web for some meaningful code but most examples are in VB
- I have a cursor with N invoices and all pertinent header data
- I want to generate N PDF files with all the invoice data and sabe them to a designated folder
- I need to email them, one by one, to the respective customers
I know this has been done zillions of times but in my case I never did it for batches and would appreciate an example on:
- How to generate the PDF files
- How to save them in a particular folder
- How to email them
Needles to add that the solutions have to be in VFP and FREE TIA Rafael Copquin
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
Rafael, We do it here for monthly statements etc ... Produce PDF Via XFRX and then CDO email sending. You are welcome to the CDO source code if you want but the XFRX is obviously chargeable but not expensive and very reliable.
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of rafael.copquin@gmail.com Sent: 16 May 2017 21:37 To: profox@leafe.com Subject: generate pdf files by batch and send them by email
I need to generate a batch of invoices in PDF format and then send them automatically by email I’ve been exploring the web for some meaningful code but most examples are in VB 1. I have a cursor with N invoices and all pertinent header data 2. I want to generate N PDF files with all the invoice data and sabe them to a designated folder 3. I need to email them, one by one, to the respective customers I know this has been done zillions of times but in my case I never did it for batches and would appreciate an example on: 1. How to generate the PDF files 2. How to save them in a particular folder 3. How to email them Needles to add that the solutions have to be in VFP and FREE TIA Rafael Copquin
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
_______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/591b62f5.51dd370a.182f6.1ccc@mx.googl... ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
On 16/05/2017 21:37, rafael.copquin@gmail.com wrote:
I need to generate a batch of invoices in PDF format and then send them automatically by email I’ve been exploring the web for some meaningful code but most examples are in VB
- I have a cursor with N invoices and all pertinent header data
- I want to generate N PDF files with all the invoice data and sabe them to a designated folder
- I need to email them, one by one, to the respective customers
I know this has been done zillions of times but in my case I never did it for batches and would appreciate an example on:
- How to generate the PDF files
- How to save them in a particular folder
- How to email them
Needles to add that the solutions have to be in VFP and FREE
The best solutions are paid but we tried a few options out recently and one was the free PDF printer that comes with Foxit reader. You can configure this to output to a certain folder and if you are doing a batch, just output one invoice, rename the file and loop through the others renaming. You can use blat to send them for free.
We ended up going for the Amyuni PDF converter, which was miles ahead of the others in terms of features and documentation.
Peter
This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715
London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
I do something similar to what you want by using the FoxyPreviewer app and CDO mail.
Laurie
On 17 May 2017 at 09:57, Peter Cushing pcushing@whisperingsmith.com wrote:
On 16/05/2017 21:37, rafael.copquin@gmail.com wrote:
I need to generate a batch of invoices in PDF format and then send them automatically by email I’ve been exploring the web for some meaningful code but most examples are in VB
- I have a cursor with N invoices and all pertinent header data
- I want to generate N PDF files with all the invoice data and sabe them
to a designated folder 3. I need to email them, one by one, to the respective customers I know this has been done zillions of times but in my case I never did it for batches and would appreciate an example on:
- How to generate the PDF files
- How to save them in a particular folder
- How to email them
Needles to add that the solutions have to be in VFP and FREE
The best solutions are paid but we tried a few options out recently and
one was the free PDF printer that comes with Foxit reader. You can configure this to output to a certain folder and if you are doing a batch, just output one invoice, rename the file and loop through the others renaming. You can use blat to send them for free.
We ended up going for the Amyuni PDF converter, which was miles ahead of the others in terms of features and documentation.
Peter
This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
[excessive quoting removed by server]
On 2017-05-16 16:37, rafael.copquin@gmail.com wrote:
I need to generate a batch of invoices in PDF format and then send them automatically by email I’ve been exploring the web for some meaningful code but most examples are in VB
- I have a cursor with N invoices and all pertinent header data
- I want to generate N PDF files with all the invoice data and sabe
them to a designated folder 3. I need to email them, one by one, to the respective customers I know this has been done zillions of times but in my case I never did it for batches and would appreciate an example on:
- How to generate the PDF files
- How to save them in a particular folder
- How to email them
Needles to add that the solutions have to be in VFP and FREE TIA Rafael Copquin
Hi Rafael,
About 20 years ago, when I worked for KePRO, we did a mass-PDF-generation method using .PS (postscript) files and Adobe Distiller. We'd put the .PS files in a network folder, and Distiller would convert them to .PDF files. Sadly though, I can't tell you more than that as I can only recall the general idea.
If I had to do this today, I'd suggest having PDFCreator or some other add-in tool (XFRX--although that's not free, FoxyPreviewer--free and I hear good things but have not yet tried it), CutePDF, or something like that, and just do a SET PRINTER TO NAME <whatever> and then run your reports, created the PDF on the fly, and then use CDO to email them.
It'll be interested to read the other responses.
hth, --Mike
-
Dave Crozier -
John Weller -
Laurie Alvey -
mbsoftwaresolutions＠mbsoftwaresolutions.com -
Peter Cushing -
rafael copquin -
rafael.copquin＠gmail.com -
Richard Kaye -
Ted Roche