If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Emailing PDF reports from Access
Presently, I am emailing some reports from Access via a simple macro created.
The reports are emailed in the MS Snapshot format. Well, I would like to email the reports in the PDF format. I have Adobe Professional and of course everybody has or should have Adobe Reader. I would rather email the reports in PDF, but that does not appear to be an option. How can the reports be created in PDF format and emailed? know I can print the reports to the Adobe printer option, but that is not so friendly of a process. I would like to use a macro or some other script. Please note I have limited knowledge of Access. -- CMac |
#2
|
|||
|
|||
On Mon, 5 Sep 2005 04:19:02 -0700, "CraigMc"
wrote: Presently, I am emailing some reports from Access via a simple macro created. The reports are emailed in the MS Snapshot format. Well, I would like to email the reports in the PDF format. I have Adobe Professional and of course everybody has or should have Adobe Reader. I would rather email the reports in PDF, but that does not appear to be an option. How can the reports be created in PDF format and emailed? know I can print the reports to the Adobe printer option, but that is not so friendly of a process. I would like to use a macro or some other script. Please note I have limited knowledge of Access. Doing a search of this site I found references to printing to an adobe printer and references to cutepdf which is shareware that converts most everything to PDF format if you do not own the full Adobe package. Since you are using the maco to print your .snp format, use the macro to print your report and assign the printer for the report to be CutePDF (assuming you get the shareware and install it). This will give you the prompts to save the file in PDF format. I am not very advanced in Access but I think the only way to automate the report generation and e-mail prompt is though VB code but I may be wrong. |
#3
|
|||
|
|||
thanks. I do have the Adobe full version. But, even there I have to respond
to the prompts. Perhaps the answer is that I need the VB code written. I hope somebody can advise further on the topic. -- CMac "Jeff C" wrote: On Mon, 5 Sep 2005 04:19:02 -0700, "CraigMc" wrote: Presently, I am emailing some reports from Access via a simple macro created. The reports are emailed in the MS Snapshot format. Well, I would like to email the reports in the PDF format. I have Adobe Professional and of course everybody has or should have Adobe Reader. I would rather email the reports in PDF, but that does not appear to be an option. How can the reports be created in PDF format and emailed? know I can print the reports to the Adobe printer option, but that is not so friendly of a process. I would like to use a macro or some other script. Please note I have limited knowledge of Access. Doing a search of this site I found references to printing to an adobe printer and references to cutepdf which is shareware that converts most everything to PDF format if you do not own the full Adobe package. Since you are using the maco to print your .snp format, use the macro to print your report and assign the printer for the report to be CutePDF (assuming you get the shareware and install it). This will give you the prompts to save the file in PDF format. I am not very advanced in Access but I think the only way to automate the report generation and e-mail prompt is though VB code but I may be wrong. |
#4
|
|||
|
|||
Take a look at http://www.granite.ab.ca/access/pdffiles.htm.
or The snapshot format includes a viewer you can send with your report the first time (for those who don't have Access) There are several free pdf creators available too. Just google for: CutePDF or PDFCreator There are several. You'll need GhostWriter and the print driver. Have a look at http://www.cutepdf.com for one of them. Others at: http://www.pdf995.com/ http://www.primopdf.com/ "CraigMc" wrote: thanks. I do have the Adobe full version. But, even there I have to respond to the prompts. Perhaps the answer is that I need the VB code written. I hope somebody can advise further on the topic. -- CMac "Jeff C" wrote: On Mon, 5 Sep 2005 04:19:02 -0700, "CraigMc" wrote: Presently, I am emailing some reports from Access via a simple macro created. The reports are emailed in the MS Snapshot format. Well, I would like to email the reports in the PDF format. I have Adobe Professional and of course everybody has or should have Adobe Reader. I would rather email the reports in PDF, but that does not appear to be an option. How can the reports be created in PDF format and emailed? know I can print the reports to the Adobe printer option, but that is not so friendly of a process. I would like to use a macro or some other script. Please note I have limited knowledge of Access. Doing a search of this site I found references to printing to an adobe printer and references to cutepdf which is shareware that converts most everything to PDF format if you do not own the full Adobe package. Since you are using the maco to print your .snp format, use the macro to print your report and assign the printer for the report to be CutePDF (assuming you get the shareware and install it). This will give you the prompts to save the file in PDF format. I am not very advanced in Access but I think the only way to automate the report generation and e-mail prompt is though VB code but I may be wrong. |
#5
|
|||
|
|||
I use Steve Arbaugh's PDF and Mail Class which does work with Adobe, but is
significantly faster and less error prone with Win2PDF http://ourworld.compuserve.com/homepages/attac-cg/ http://www.win2pdf.com/ Between the code in the class module, and my own code, I have able to create, save as pdf's, and send by email hundreds of PO's per hour, totally automatically. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access "CraigMc" wrote in message news thanks. I do have the Adobe full version. But, even there I have to respond to the prompts. Perhaps the answer is that I need the VB code written. I hope somebody can advise further on the topic. -- CMac "Jeff C" wrote: On Mon, 5 Sep 2005 04:19:02 -0700, "CraigMc" wrote: Presently, I am emailing some reports from Access via a simple macro created. The reports are emailed in the MS Snapshot format. Well, I would like to email the reports in the PDF format. I have Adobe Professional and of course everybody has or should have Adobe Reader. I would rather email the reports in PDF, but that does not appear to be an option. How can the reports be created in PDF format and emailed? know I can print the reports to the Adobe printer option, but that is not so friendly of a process. I would like to use a macro or some other script. Please note I have limited knowledge of Access. Doing a search of this site I found references to printing to an adobe printer and references to cutepdf which is shareware that converts most everything to PDF format if you do not own the full Adobe package. Since you are using the maco to print your .snp format, use the macro to print your report and assign the printer for the report to be CutePDF (assuming you get the shareware and install it). This will give you the prompts to save the file in PDF format. I am not very advanced in Access but I think the only way to automate the report generation and e-mail prompt is though VB code but I may be wrong. |
#6
|
|||
|
|||
Emailing PDF reports from Access
Can you tell me what code you used as I am struggling to automate my
invoicing via email, I can do it with the 'snapshot' view but I want to use the PDF format - can you help? "Arvin Meyer [MVP]" wrote: I use Steve Arbaugh's PDF and Mail Class which does work with Adobe, but is significantly faster and less error prone with Win2PDF http://ourworld.compuserve.com/homepages/attac-cg/ http://www.win2pdf.com/ Between the code in the class module, and my own code, I have able to create, save as pdf's, and send by email hundreds of PO's per hour, totally automatically. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access "CraigMc" wrote in message news thanks. I do have the Adobe full version. But, even there I have to respond to the prompts. Perhaps the answer is that I need the VB code written. I hope somebody can advise further on the topic. -- CMac "Jeff C" wrote: On Mon, 5 Sep 2005 04:19:02 -0700, "CraigMc" wrote: Presently, I am emailing some reports from Access via a simple macro created. The reports are emailed in the MS Snapshot format. Well, I would like to email the reports in the PDF format. I have Adobe Professional and of course everybody has or should have Adobe Reader. I would rather email the reports in PDF, but that does not appear to be an option. How can the reports be created in PDF format and emailed? know I can print the reports to the Adobe printer option, but that is not so friendly of a process. I would like to use a macro or some other script. Please note I have limited knowledge of Access. Doing a search of this site I found references to printing to an adobe printer and references to cutepdf which is shareware that converts most everything to PDF format if you do not own the full Adobe package. Since you are using the maco to print your .snp format, use the macro to print your report and assign the printer for the report to be CutePDF (assuming you get the shareware and install it). This will give you the prompts to save the file in PDF format. I am not very advanced in Access but I think the only way to automate the report generation and e-mail prompt is though VB code but I may be wrong. |
#7
|
|||
|
|||
Emailing PDF reports from Access
I can send you the code I've written to create a pdf from either an Access
report or a Word document. Send me an email by removing the "hideme" if you'd like a copy. It works with Adobe Acrobat versions from 5 to 8. I haven't tried it, but someone else posted that in Access 2007 pdf is a supported output format, once you install the free PDF/XPS add-in from Microsoft. The code was simply: DoCmd.OutputTo ObjectType:=acOutputReport, _ ObjectName:=argRPT, _ 'the report we are working with outputformat:=acFormatPDF, _ outputfile:=strReportFile, _ 'path (drive, folder & name) to put pdf in. autostart:=True "Igreen" wrote in message ... Can you tell me what code you used as I am struggling to automate my invoicing via email, I can do it with the 'snapshot' view but I want to use the PDF format - can you help? "Arvin Meyer [MVP]" wrote: I use Steve Arbaugh's PDF and Mail Class which does work with Adobe, but is significantly faster and less error prone with Win2PDF http://ourworld.compuserve.com/homepages/attac-cg/ http://www.win2pdf.com/ Between the code in the class module, and my own code, I have able to create, save as pdf's, and send by email hundreds of PO's per hour, totally automatically. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access "CraigMc" wrote in message news thanks. I do have the Adobe full version. But, even there I have to respond to the prompts. Perhaps the answer is that I need the VB code written. I hope somebody can advise further on the topic. -- CMac "Jeff C" wrote: On Mon, 5 Sep 2005 04:19:02 -0700, "CraigMc" wrote: Presently, I am emailing some reports from Access via a simple macro created. The reports are emailed in the MS Snapshot format. Well, I would like to email the reports in the PDF format. I have Adobe Professional and of course everybody has or should have Adobe Reader. I would rather email the reports in PDF, but that does not appear to be an option. How can the reports be created in PDF format and emailed? know I can print the reports to the Adobe printer option, but that is not so friendly of a process. I would like to use a macro or some other script. Please note I have limited knowledge of Access. Doing a search of this site I found references to printing to an adobe printer and references to cutepdf which is shareware that converts most everything to PDF format if you do not own the full Adobe package. Since you are using the maco to print your .snp format, use the macro to print your report and assign the printer for the report to be CutePDF (assuming you get the shareware and install it). This will give you the prompts to save the file in PDF format. I am not very advanced in Access but I think the only way to automate the report generation and e-mail prompt is though VB code but I may be wrong. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Encrypt AccesS File? | milest | General Discussion | 2 | February 9th, 2005 07:58 PM |
Access 2000 -vs- Access 2003? | Mark | General Discussion | 5 | November 30th, 2004 06:36 AM |
Adding staff photographs to my database | KK | New Users | 2 | September 3rd, 2004 07:41 AM |
limiting access to reports | JMorrell | General Discussion | 3 | July 28th, 2004 03:52 PM |
ACCESS Reports | Steve | Setting Up & Running Reports | 2 | June 7th, 2004 02:58 PM |