StrReportFile = strCurrentPath & “Products Shipped.snp” StrReportFile = strCurrentPath & “Products Shipped.pdf”ĭoCmd.OutputTo objecttype:=acOutputReport, _ _ Msg.Subject = “Products to reorder for ” _ Set msg = appOutlook.CreateItem(olMailItem) StrReportFile = strCurrentPath & “Products To Reorder.snp” If the PDF file creation succeeds, go directly to the CreateEmail section, skipping the CreateSnapshot section StrReportFile = strCurrentPath & “Products To Reorder.pdf”ĭebug.Print “Report and path: ” & strReportFileĭoCmd.OutputTo objecttype:=acOutputReport, _ StrCurrentPath = įirst try to export to PDF (this will only work if you have installed the Save to PDF utility)
This error handler goes to the CreateSnapshot section if saving to PDF fails
Microsoft save as pdf add in 2007 code#
With the Save as PDF utility installed, you can export a report to a PDF file using code like the following (each function can be run from a macro in the sample database, ExportToPDF.accdb): Selecting a file name and folder for the PDF fileįigure C. The PDF selection opens a dialog where you can browse for the folder where you want the PDF file to be saved:įigure B. To save a report as a PDF file, select the report, then open the Office menu and select the Save As command select the PDF choice, as shown in Figure A, to save the report to a PDF file. Saving to PDF is primarily useful for reports, though you might occasionally want to save a form as a PDF to send it to someone for review of the form’s appearance. Once you have downloaded the SaveAsPDF.exe file, just run it – there is no setup program, not even a success message, but Access 2007 now has PDF support. (If the link is broken, just search for “Save as PDF” on the Downloads page of the Microsoft site.) The Save as PDF utility can be downloaded from here. Saving to PDF didn’t make it into the release version of Access 2007, but Microsoft has provided a Save to PDF utility (downloadable from the link below) that adds a PDF selection to the Save As submenu of the new Office menu that replaces the old File menu. An Access report saved as a PDF file can be opened by anyone (unlike Access snapshots, which are only viewable by recipients who have Access, or the Access Snapshot Viewer, installed). Click the Create PDF button and follow any additional prompts to create and save the PDF file to your computer.How to save a report to PDF file in Access 2007.įor many years now, Access users have wanted the option of saving a report to the PDF format. You can leave this as the default, or you can change the option to Specific folder, requiring you to then select where to save the PDF file on your computer. By default, the Save As option will be set to Ask when creating PDF. If using PrimoPDF, a PrimoPDF window opens.Choose the location where you want to save the PDF file, enter a file name for the PDF file, and click the Save button. If using CutePDF, a Save As window opens.On the Print page or window, change the selected printer to the CutePDF Writer or PrimoPDF printer option, depending on which you installed.
Microsoft save as pdf add in 2007 install#
We recommend one of the two following free PDF conversion applications.ĭownload and install one of the two PDF conversion applications, then follow the steps below to print your Word document to a PDF file. Printing to PDF requires your computer has a PDF creation program installed, so that Word can print to that PDF converter. The published PDF file will be opened in your default PDF viewing application.Ī Word document can be electronically printed to a PDF format, creating a PDF file.Make sure the Save as type drop-down list is set to PDF (*.pdf), then click the Publish button. In the Publish as PDF or XPS window, choose the location where you want to save the file.Select the Create PDF/XPS Document option, then click the Create PDF/XPS button.Follow the steps below to export your Word 2016 document to PDF. Click the Save button to save the Word document as a PDF.Ī new feature available in Microsoft Word 2016 is the ability to export a Word document to PDF format, creating a PDF file.In the Save as type drop-down list, select the PDF (*.pdf) option.
On the Save As window, click the Browse button or option to select a location on your computer to save the file.Click the File tab or menu option at the top-left of the Word program window.Open an existing Word document or create a new Word document.In most versions of Microsoft Word, you can save the Word document straight to a PDF file type by following the steps below.
0 kommentar(er)
