How to send a report to PDF To Fax it

[sistemaPR]

I created an application that creates 3 or four reports, now I need to make the report in PDF format automatically, can that be done. The objective is to send the report by fax. With an application install here ( Called RightFax). Do you have any Tips, on how to do this.

[HansV]

Access 2007 (SP2 and later), 2010 and 2013 have the ability to save a report as PDF built-in.
For example, in Access 2010/2013:

- Select a report in the navigation pane.
- Activate the External Data tab of the ribbon.
- Click 'PDF or XPS' in the Export group.
- Select PDF in the 'Save as Type' dropdown.

or

- Open the report in Print Preview.
- Click 'PDF or XPS' in the Data group of the Print Preview tab of the ribbon.
- Select PDF in the 'Save as Type' dropdown.

In VBA:

Code: Select all

    DoCmd.OutputTo ObjectType:=acOutputReport, ObjectName:="MyReport", _
        OutputFormat:=acFormatPDF, OutputFile:="C:\Exports\MyReport.pdf"

You should of course change the name of the report and the path / filename of the output file.

[sistemaPR]

this is the command "C:\Program Files\RightFax\Client\fuw32.exe" That I am using to startup RightFAX, but do you know the switch to create a new fax ? or where to look for. I look in google for command line for rightFax, but did not find any. nothing ..

[HansV]

Apparently RightFax includes a "fax printer", so perhaps you can print your report to fax:

Code: Select all

    Application.Printer = "RightFax Fax Printer"
    DoCmd.OpenReport ReportName:="MyReport", View:=acViewPreview

RightFax also has an API (Application Programming Interface) that you can use by setting the correct references in Tools | References...
See OpenText RightFax 10.5 COM Reference Guide for technical documentation and VBA And Rightfax for an example.