Export Report As PDF

[abbaddon223]

Hi,

I'm trying to export a report as PDF giving it a name at the same time. I'll then email this out.

The email bit I'm fine with, but I'm struggling to get the report to save as a PDF

Dim outputFileName As String
outputFileName = CurrentProject.Path & "\Mail_Merges\Templates\Bulk\Email Quote From Dialler\" & "Quote" & [Quote_URN] & ".csv"
DoCmd.OutputTo acOutputReport, "Digital Service Cover Quote", acFormatPDF, outputFileName

Any help with this would be greatly appreciated!!

Phil.

 

[pr2-eugin]

What exactly do you mean that it is not saving the file?

You do realise that you have use acFormatPDF but saving a CSV file right?

 

[abbaddon223]

Nooooooooo!!! The shame :banghead:

Thanks mate!!

 

[pr2-eugin]

No shame in learning something.. You're welcome.. Good luck !